*** THIS DATA SET IS USED BELOW;

data both;
input gender : $1. age;
datalines;
M 34
F 50
F 34
F 88
M 15
m 23
f 45
;
run;

*** HOW MANY OBSERVATIONS WILL THERE BE IN THE FOLLOWING SAS DATA SETS;
*** WHAT ARE THE VALUES OF GENDER AND AGE IN THE DATA SETS;

data males;
set both;
if gender eq 'M';
run;

proc print data=males;
run;

data females;
set both;
where gender eq 'F';
run;

proc print data=females;
run;

data males females;
set both;
if gender eq 'M' then output males;
else                  output females;
run;

proc print data=males;
run;

proc print data=females;
run;

data males females;
set both;
if gender in ('M' 'm') then output;
age = age + 1;
run;

proc print data=males;
run;

proc print data=females;
run;

data new1;
set both;
if gender in ('M' 'm') then return;
age = age - 1;
run;

proc print data=new1;
run;

data new2;
set both;
if gender in ('M' 'm') then output;
age = age - 1;
run;

proc print data=new2;
run;

data new3;
set both;
if gender in ('M' 'm') then delete;
age = age - 1;
run;

proc print data=new3;
run;

data males females;
set both;
if gender in ('M' 'm') then output;
age = age + 1;
run;

proc print data=males;
run;

proc print data=females;
run;


*** HOW MANY OBSERVATIONS WILL THERE BE IN THE DATA SET STUDY;
*** WHAT ARE THE VALUES OF GENDER AND CHOL IN THE DATA SETS;

data study;
input gender : $1. chol;
if gender eq 'M';
datalines;
M 130
F 175
M 167
F 110
M 210
M 132
;
run;

proc print data=study;
run;

data study;
input gender : $1. chol;
if gender eq 'F' then delete;
datalines;
M 130
F 175
M 167
F 110
M 210
M 132
;
run;

proc print data=study;
run;

data study;
input gender : $1. chol;
if gender eq 'M' then output;
datalines;
M 130
F 175
M 167
F 110
M 210
M 132
;
run;

proc print data=study;
run;

data study;
input gender : $1. chol;
if gender eq 'F' then return;
chol = 1.1*chol;
datalines;
M 130
F 175
M 167
F 110
M 210
M 132
;
run;

proc print data=study;
run;

data study;
input gender : $1. chol;
if gender eq 'F' then return;
chol = 1.1*chol;
output;
datalines;
M 130
F 175
M 167
F 110
M 210
M 132
;
run;

proc print data=study;
run;