conditional processing

5 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€64.99
List Price:  €92.85
You save:  €27.85
£55.77
List Price:  £79.68
You save:  £23.90
CA$95.68
List Price:  CA$136.70
You save:  CA$41.01
A$105.96
List Price:  A$151.38
You save:  A$45.42
S$94.48
List Price:  S$134.98
You save:  S$40.50
HK$546.78
List Price:  HK$781.15
You save:  HK$234.36
CHF 63.33
List Price:  CHF 90.48
You save:  CHF 27.14
NOK kr761.11
List Price:  NOK kr1,087.35
You save:  NOK kr326.23
DKK kr485.02
List Price:  DKK kr692.92
You save:  DKK kr207.89
NZ$116.44
List Price:  NZ$166.35
You save:  NZ$49.91
د.إ257.06
List Price:  د.إ367.25
You save:  د.إ110.18
৳7,660.01
List Price:  ৳10,943.35
You save:  ৳3,283.33
₹5,835.78
List Price:  ₹8,337.18
You save:  ₹2,501.40
RM331.75
List Price:  RM473.95
You save:  RM142.20
₦86,437.65
List Price:  ₦123,487.65
You save:  ₦37,050
₨19,492.21
List Price:  ₨27,847.21
You save:  ₨8,355
฿2,572.74
List Price:  ฿3,675.50
You save:  ฿1,102.76
₺2,264.43
List Price:  ₺3,235.04
You save:  ₺970.61
B$355.02
List Price:  B$507.19
You save:  B$152.17
R1,295.44
List Price:  R1,850.71
You save:  R555.27
Лв127.05
List Price:  Лв181.51
You save:  Лв54.46
₩94,909.58
List Price:  ₩135,590.93
You save:  ₩40,681.35
₪260.15
List Price:  ₪371.66
You save:  ₪111.51
₱3,993.87
List Price:  ₱5,705.78
You save:  ₱1,711.90
¥10,713.01
List Price:  ¥15,304.96
You save:  ¥4,591.95
MX$1,187.73
List Price:  MX$1,696.83
You save:  MX$509.10
QR254.83
List Price:  QR364.06
You save:  QR109.23
P950.82
List Price:  P1,358.38
You save:  P407.55
KSh9,247.76
List Price:  KSh13,211.65
You save:  KSh3,963.89
E£3,352.12
List Price:  E£4,788.95
You save:  E£1,436.83
ብር4,006.43
List Price:  ብር5,723.72
You save:  ብር1,717.28
Kz58,511.64
List Price:  Kz83,591.64
You save:  Kz25,080
CLP$65,950.47
List Price:  CLP$94,219
You save:  CLP$28,268.52
CN¥506.53
List Price:  CN¥723.65
You save:  CN¥217.11
RD$4,055.76
List Price:  RD$5,794.19
You save:  RD$1,738.43
DA9,420.16
List Price:  DA13,457.95
You save:  DA4,037.79
FJ$157.70
List Price:  FJ$225.30
You save:  FJ$67.59
Q542.52
List Price:  Q775.06
You save:  Q232.54
GY$14,601.52
List Price:  GY$20,860.22
You save:  GY$6,258.69
ISK kr9,773.40
List Price:  ISK kr13,962.60
You save:  ISK kr4,189.20
DH703.98
List Price:  DH1,005.73
You save:  DH301.75
L1,236.34
List Price:  L1,766.28
You save:  L529.93
ден3,998.26
List Price:  ден5,712.05
You save:  ден1,713.78
MOP$561.77
List Price:  MOP$802.57
You save:  MOP$240.79
N$1,291.99
List Price:  N$1,845.78
You save:  N$553.78
C$2,569.36
List Price:  C$3,670.67
You save:  C$1,101.31
रु9,319.09
List Price:  रु13,313.56
You save:  रु3,994.46
S/260.54
List Price:  S/372.22
You save:  S/111.67
K269.79
List Price:  K385.44
You save:  K115.64
SAR262.50
List Price:  SAR375.01
You save:  SAR112.51
ZK1,882.68
List Price:  ZK2,689.66
You save:  ZK806.98
L323.40
List Price:  L462.03
You save:  L138.62
Kč1,628.77
List Price:  Kč2,326.92
You save:  Kč698.14
Ft25,334.28
List Price:  Ft36,193.38
You save:  Ft10,859.10
SEK kr755.02
List Price:  SEK kr1,078.64
You save:  SEK kr323.62
ARS$61,468.17
List Price:  ARS$87,815.44
You save:  ARS$26,347.26
Bs483.33
List Price:  Bs690.51
You save:  Bs207.17
COP$271,845.87
List Price:  COP$388,367.89
You save:  COP$116,522.02
₡35,672.25
List Price:  ₡50,962.55
You save:  ₡15,290.29
L1,724.16
List Price:  L2,463.20
You save:  L739.03
₲522,510.75
List Price:  ₲746,475.93
You save:  ₲223,965.17
$U2,674.97
List Price:  $U3,821.56
You save:  $U1,146.58
zł281.37
List Price:  zł401.98
You save:  zł120.60
Already have an account? Log In

Transcript

Welcome clinical data management program using SAS In this video we will be discussing about condition processing or the concept of condition processing. So in order to do condition processing again we'll be using data step we'll be using if conditions, we will be using the same data set that is disease, which we were working before, we had already brought our data set in the SAS environment using the live name statement. So now let's learn how to do condition processing. We are forming an output data set named disease one. We are forming the output data set inside work it is optional. Wherever you want to create it, you can create it you can create inside a moment leverage or work on creating it inside work.

Then set main data series CDM or disease CDM is a library. So basically, using the set state in my input data set is getting copied in my output. dataset under whatever manipulations will be done or whatever condition processing will be done, it will be shown in our output data set. So if you open the output data set, then only we can see the results, I want to display those observations in the output data set where the average on disco commute. So, I want to display those observations where average underscore commute is greater than 20. And I do another condition that is gender has to be equal to female.

Okay, I'm adding another condition that is on disease equals to hypertension. So, basically I want to display those observations where my average commute is greater than 20. And gender is equal to female and disease equal to hypertension. So, given that in an if condition Because there are multiple conditions like I want observations which is which has to fulfill all the conditions, that's why I have used the anchor statement. So you know and is a logical statement. So if the observations where all the conditions are going to be fulfilled, those observations will only be displayed then we are giving the run statement.

So, let's run this code. So now our results will be displayed in disease one data set just because it's a data set we are not going to get in result viewer we will open disease one to check our results to see only female gender observations of patients are displayed with average commute greater than 20 and diseases equal to hypertension. So this is a type of condition processing, or this is a format or this is a procedure by which we do condition processing. We'll do another condition processing where we want to display those observations where age is greater than 75. disease is equal to Alzheimer's or say we want to display those patients who are senior citizens we generally say the senior citizens patients are patients who are above 60 years. So, we will be displaying those observations who are senior citizens that is whose age is greater than 60 and who are suffering from disease that is a sinus disease.

So, for this we are going to use our disease for data set which we had already formed in our last video which where we have computed the age of different patients now we are going to use the data set over here as the input data set so we are forming our own data centers data disease six, any name you can give, I'm forming it inside work, set disease for which is already formed inside work. If you end your session your work library generally vanishes that is the resistance of work leverage vanishes work remains. So if you have to get back the data sets again, you have to run the code to get back your data set. Since I work, so my included as it says disease code where my age was computed, I want those observations where age is greater than 60. That is I want patients with more senior citizens and who are suffering from Alzheimer's disease and disease equal to as it was.

Okay. So let's run this code. Again, this is our data manipulation. So we'll be seeing our code in our dataset that is disease six To see here, all patients with age greater than 60 are displayed and who are suffering from Alzheimer's disease. So these are other senior citizens who are having age greater than 60 and who are suffering from Alzheimer's disease, we know that mostly the senior citizens are prone to this disease. So that's why I showed you this condition processing.

So in this video we'll be doing here in our next video, we'll be dealing with accumulating total or creating accumulating totals for now. Let me end this video here. Thank you, goodbye. See you all for the next video.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.