update multiple columns

Accepted Solution Solved
Reply
Contributor
Posts: 29
Accepted Solution

update multiple columns

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;


Accepted Solutions
Solution
‎05-23-2018 03:04 PM
Valued Guide
Posts: 591

Re: update multiple columns

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;
Thanks,
Suryakiran

View solution in original post


All Replies
Solution
‎05-23-2018 03:04 PM
Valued Guide
Posts: 591

Re: update multiple columns

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;
Thanks,
Suryakiran
Contributor
Posts: 29

Re: update multiple columns

Posted in reply to SuryaKiran
yeah, right. thanks...
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 103 views
  • 0 likes
  • 2 in conversation