I have 50 survey variables, named AB1, AB2, AB3,...,AB50. Most of these variables contain a survey response, either answer choice A, B, or C. In some cases, there is no response in which the field has NULL entered in the cell. How do I change all of these NULL responses to a 0 without doing an if/then statement for each individual variable? Thanks for any help!
data want;
set have;
array abvar{*} $ AB1-AB50;
do i = 1 to dim(abvar);
if missing(abvar(i)) then abvar(i) = '0';
end;
drop i;
run;
If you need this only for display purposes then you can also use:
options missing='0';
Only works for numerical variables.
Change @ketpt42's code above to
if abvar(i)='NULL' then abvar(i) = '0';
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
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.
Ready to level-up your skills? Choose your own adventure.