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
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.
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.
Tom
data test;
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' */
drop i;
end;
run;
@ShiroAmada Some of those columns are numeric and some will likely be character.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.