topic Re: IF THEN in SAS Programming

IF THEN

souji — Tue, 07 Jan 2020 03:24:05 GMT

　In SAS Prep guide, how it defined id=1147 is age 65 (it could be some # in age)..please explain

data work.clean_data;

set cert.pats;

gender=upcase(Gender);

if Gender='G' then Gender='M';

if id=1147 then age=65;

else if id=5277 then age=75;

run;

proc print data=work.clean_data;

run;

Re: IF THEN

Patrick — Tue, 07 Jan 2020 03:57:51 GMT

The value of ID comes from your source table cert.pats.

The code then has a condition which tests the value of ID (if id=1147). If the value of ID coming from your source table is 1147 then the condition becomes true and the bit after THEN gets executed. So here a value of 65 gets assigned to variable age overwriting whatever value age had before. The result gets at the end of the data step written to output table work.clean_data.

Re: IF THEN

ed_sas_member — Tue, 07 Jan 2020 07:23:28 GMT

Hi @souji

Please compare the two datasets below (on the left, the initial dataset cert.pats; on the right the new one that has been created):

Firstly, we ensure that all gender values are in upper case, because we want to replace all "G" by "M". If there was a value like "g", the condition won't apply.
Secondly, for the specific ID value 1147 (age = 116), we want to replace the age by 65 (which is more plausible). The same for id=5277 (age 202 replaced by 75).

cert.patswork.clean_data

Re: IF THEN

souji — Tue, 07 Jan 2020 16:37:01 GMT

Thank You for the explanation , but I can give the other number ( like 80) instead of 65