08-22-2017 12:19 PM
I am new to SAS EG 7.1 and i want to recode the zero values and character string specifically this type "?" in columns X1 to X13 in my dataset to NA. I have in total 13 variables and a response variable Y. i have imported the data and its been converted to a SAS data. I have also succeeded in coding the "0" and "1" in the response variable to "No" and "Yes" as i want. please help!. N:B the data is an xlsx file. Thanks
08-22-2017 01:35 PM
08-22-2017 01:37 PM
NA isn't typically used in SAS so I would review how SAS stores and treats missing and decide if you want missing or some other variable. A lot depends on what you're doing with the data down the line.
08-22-2017 02:50 PM
SAS has "special" missing values; you can use "dot" followed by a letter.
So, while both . and .n would be considered missing by computational procedures, you could tell the difference between them in a data step.
08-23-2017 04:18 AM
array var(3) $2 x1-x3 ("0" "?" "1"); /* X1='0', X2='?' and x3='1' */
put X1 X2 X3;
do i=1 to dim(var);
if var(i) in ('0','?') then var(i)='NA'; /*The value for X1='NA', X2='NA' and x3='1' */