Help using Base SAS procedures

Character yes/no format

Accepted Solution Solved
Reply
Contributor
Posts: 23
Accepted Solution

Character yes/no format

I have a dataset that has a variable 'volcano' where responses are coded as 'rupture' or 'no rupture.' I want to create a character yes/no format and apply it to the 'volcano' variable so that 'rupture' changes to 'yes' and 'no rupture' changes to 'no.' I know how to do this using IF/THEN statements, but not using a format. How do I apply this update to the dataset/'volcano' variable using a character yes/no format?


Accepted Solutions
Solution
‎03-18-2013 11:27 AM
Super Contributor
Posts: 543

Re: Character yes/no format

Hi.

proc format;

     value $ yesno "rupture" = "Yes"

          "no rupture" = "No"

;

quit;

data want;

     set have;

     format volcano $yesno.;

run;

Good luck!

Anca.

PS: make sure that the spelling of 'rupture'/'no rupture' is exactly as in the variable's value.

View solution in original post


All Replies
Solution
‎03-18-2013 11:27 AM
Super Contributor
Posts: 543

Re: Character yes/no format

Hi.

proc format;

     value $ yesno "rupture" = "Yes"

          "no rupture" = "No"

;

quit;

data want;

     set have;

     format volcano $yesno.;

run;

Good luck!

Anca.

PS: make sure that the spelling of 'rupture'/'no rupture' is exactly as in the variable's value.

Contributor
Posts: 23

Re: Character yes/no format

Thanks, that worked!

☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 599 views
  • 0 likes
  • 2 in conversation