Can some one please help me in identifying the issue here. When my if condition is true the value is being retained. Any input is helpful. Please find the attached files.
data test(keep= aeacnno aeshosp aesdisab _aescong _aeshosp _aesdisab);
set AE_shell ae;
if aeacnno eq 1 then _aescong= 'Y';
if aeshosp eq 1 then _aeshosp= 'Y';
if aesdisab eq 1 then _aesdisab= 'Y';
run;
Thank You.
Or since it appears you are using the AE_SHELL dataset to set the variable order and attributes add the call missing to end of the step. Just add an OUTPUT statement before the call missing. Otherwise the reference to those variables in the CALL MISSING statement before the SET statement will make them the first three variables in your dataset.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.