Applying SAS format

Neeta — Mon, 17 Jul 2017 19:03:22 GMT

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;

Re: Applying SAS format

Reeza — Mon, 17 Jul 2017 19:20:06 GMT

Use PUTC, it can take a variable name as a format.

c = putc(a, b);

Neeta — Mon, 17 Jul 2017 19:44:39 GMT

Awesome! Thanks a lot!