Hi Everyone,
So I have a long list of variables and I only want to keep (or drop) all variables with "Jan" or "jan".
Any help is very much appreciated.
HHC
data have;
input Jan1 _1_jan Feb March_ ;
datalines;
1 0 0 0
2 1 1 1
;run;
UNTESTED CODE
proc sql; select distinct name into :names separated by ' ' from dictionary.columns where upcase(memname)='HAVE' and upcase(libname)='WORK'
and upcase(name)?'JAN'; quit; data want;
set have (drop=&names); /* OR set have (keep=&names); */
run;
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.
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.