I'm creating a new variable, d_religion2 from an existing variable, d_religion. All I'm trying to do is redefine the categories of the variable (should be super easy, right?). In the dataset I'm working with, the categories of d_religion are words - catholic, evangelical, jewish, etc. - I attached a screen shot of a table of d_religion so you can see what I mean. How do I write that in an if/then statement? Because writing something like "if d_religion=catholic then d_religion2=christian;" for example, doesn't work. Hopefully this is clear......let me know if you have questions. I know this is probably simple haha. Thanks!
Since I never download attachments, I'll take a guess here
data want;
set have;
if upcase(d_religion)='CATHOLIC' then d_religion2='CHRISTIAN';
else if upcase(d_religion)='BUDDHIST' then d_religion2='INDIAN';
/* And so on */
run;
The proper way to provide sample data is https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/
Since I never download attachments, I'll take a guess here
data want;
set have;
if upcase(d_religion)='CATHOLIC' then d_religion2='CHRISTIAN';
else if upcase(d_religion)='BUDDHIST' then d_religion2='INDIAN';
/* And so on */
run;
The proper way to provide sample data is https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.