DATA Step, Macro, Functions and more

Applying SAS format

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Applying SAS format

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;

 

 

 


Accepted Solutions
Solution
‎07-17-2017 03:44 PM
Super User
Posts: 17,784

Re: Applying SAS format

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

 

c = putc(a, b);

View solution in original post


All Replies
Solution
‎07-17-2017 03:44 PM
Super User
Posts: 17,784

Re: Applying SAS format

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

 

c = putc(a, b);
Occasional Contributor
Posts: 14

Re: Applying SAS format

Awesome! Thanks a lot!
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 104 views
  • 1 like
  • 2 in conversation