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);
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.