05-23-2018 02:28 PM
i have some code here...
input IDNUMBER $ Week1 Week2;
2477 195 163
2431 220 198
2456 173 155
2412 135 116
alter table weight add DELETE char(2), DEL2 char(2);
if WeightLoss2>20 then DELETE='Y';
proc print data=weight;
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...
if WeightLoss2>20 then DELETE='Y' and DEL2='Y';
else DELETE='N' and DEL2='N';
Need further help from the community? Please ask a new question.