Hi,
I have a dataset with a set of numeric variables. The names are like "a_1" to "a_8" up to "f_1" to "f_6". So the names are a letter, underscore and a number (not all the numeric variables are like this, but most of them).
I want to remove all the zeroes in the numeric variables with the structure like the one above. But I cant get any kind of wildcards to work. Does anyone have any idea?
So far, my attempts has been like:
data dataset1;
set dataset1;
if b%= 0 then b%= ' ' ;
run;
Best regards,
Hank
You are using the wrong syntax. You will need to create and ARRAY using a SAS Variable List then you can iterate through the elements in the array and use an IF statement to change the values as you see fit.
You are using the wrong syntax. You will need to create and ARRAY using a SAS Variable List then you can iterate through the elements in the array and use an IF statement to change the values as you see fit.
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.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.