i have some code here...
data weight;
input IDNUMBER $ Week1 Week2;
WeightLoss2=Week1-Week2;
datalines;
2477 195 163
2431 220 198
2456 173 155
2412 135 116
;
proc sql;
alter table weight add DELETE char(2), DEL2 char(2);
quit;
data weight;
set weight;
if WeightLoss2>20 then DELETE='Y';
else DELETE='N';
run;
proc print data=weight;
run;
okay, so this code clearly creates a table and conditionally updates it. notice i create two tables. when i run the update, is it possible to update two columns at once either to the same value or another? so...
data weight;
set weight;
if WeightLoss2>20 then DELETE='Y' and DEL2='Y';
else DELETE='N' and DEL2='N';
run;
You can by using DO END;
data weight;
set weight;
if WeightLoss2>20 then DO;
DELETE='Y' ;
DEL2='Y';
END;
else DO;
DELETE='N' ;
DEL2='N';
END;
run;
You can by using DO END;
data weight;
set weight;
if WeightLoss2>20 then DO;
DELETE='Y' ;
DEL2='Y';
END;
else DO;
DELETE='N' ;
DEL2='N';
END;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.