Hi all,
I'm curious to know what is best solution to following problem. I've a dataset which stores the information about SAS format as a variable value.
data chk;
input a $ b $ ;
cards;
1 $ch1k.
3 $ch1k.
3 $ch2k.
;
run;
proc format;
value $ch1k
1 = "Avg"
2 = "Good"
other = " "
;
value $ch2k
3 = "Low"
4 = "Super Low"
;
quit;
Here, for first 2 observations, I want to apply format $ch1k. and for 3rd observation I want $ch2k. As a result, I want following dataset
data desired_value;
input a $ b $ c$;
cards;
1 $ch1k. Avg
3 $ch1k. .
3 $ch2k. Low
;
run;
Use PUTC, it can take a variable name as a format.
c = putc(a, b);
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.