data test2; set cert.furnture; if finish='oak'; if price<100 then delete; TotalPrice+price; drop price; run; proc print data=test2 noobs; run;
data test2; set cert.furnture; if finish='oak' and price<200; TotalPrice+price; drop price; run; proc print data=test2 noobs; run;
data test2; set cert.furnture; if finish='oak' and price<200 then delete; TotalPrice+price; drop price; run; proc print data=test2 noobs; run;
data test2; set cert.furnture; if finish='oak' and price<100 then do; TotalPrice+price; drop price; end; run; proc print data=test2 noobs; run;
if finlexam>=95 and (research='A' or (project='A' and present='A')) then Grade='A+';
finlexam>=95
research='A'
project='A' and present='A'
research='A' or (project='A' and present='A')
Status
|
Type
|
Count
|
Action
|
Control
|
---|---|---|---|---|
OK
|
3
|
12
|
E
|
Go
|
if status='OK' and type=3 then Count+1; if status='S' or action='E' then Control='Stop';
Count = 12 Control = Go
Count = 13 Control =Stop
Count = 12 Control =Stop
Count = 13 Control = Go
if code='1' then Type='Fixed'; if code='2' then Type='Variable'; if code^='1' and code^='2' then Type='Unknown';
if code='1' then Type='Fixed'; else if code='2' then Type='Variable'; else Type='Unknown';
if code='1' then Type='Fixed'; if code='2' then Type='Variable'; else Type='Unknown';
if code='1' then type='Fixed'; else code='2' and type='Variable'; else type='Unknown';
if code='1' and type='Fixed'; then code='2' and type='Variable'; else type='Unknown';
data work.newloan; set cert.records; TotLoan+payment; if code='1' then Type='Fixed'; else Type='Variable'; length type $ 10; run;
data stresstest(drop=timemin timesec); set cert.tests; TotalTime=(timemin*60)+timesec; SumSec+totaltime; run;
proc print data=stresstest; label totaltime='Total Duration of Test'; drop sumsec; run;
proc print data=stresstest(keep=totaltime timemin); label totaltime='Total Duration of Test'; run;
data stresstest; set cert.tests; TotalTime=(timemin*60)+timesec; keep id totaltime tolerance; run;
data work.cardiac(drop=age group); set cert.fitness(keep=age weight group); if group=2 and age>40; run;
data cert.fastordr(drop=ordrtime); set cert.orders(keep=product units price); if ordrtime<4; Total=units*price; run;
data cert.orders(drop=ordrtime); set cert.fastordr(keep=product units price); if ordrtime<4; Total=units*price; run;
data cert.fastordr(drop=ordrtime); set cert.orders(keep=product units price ordrtime); if ordrtime<4; Total=units*price; run;