Hi everybody!
In my dataset, for every customer I have the corresponding column with "Active" or "Passive"
How can I convert them in Active = 0 and Passive = 1 on SAS
Thank you in advance
So you have a character column and want it displayed as 1 or 0, then a proc format and apply that to your column would be simplest. Alternatively create new column and rename:
data want; set have; num_col=ifn(char_col="Active",1,0); run;
Its useful to post test data in the form of a datastep and what you want the output to look like otherwise we are just guessing.
At first, thank you from the prompt reply.
My dataset look like
curtomer Status
1 Active
2 Passive
3 Passive
4 Passive
5 Active
6 Active
ect. so I want Passive and Active to be transformed in 0 and 1
thank you
What do you mean by transformed? If you want to replace the text "Active" with the text "1" then:
var=tranwrd(var,"Active","1");
But if you want a numeric variable then you have to rename, create a new one:
data want; set have (rename=(var=old_var)); var=ifn(old_var="Active",1,0); run;
data have;
input customer status $;
cards;
1 Active
2 Passive
3 Passive
4 Passive
5 Active
6 Active
;
run;
proc format library=work;
invalue stat
"Active" = 1
"Passive" = 0
other = -1
;
value $stat
"Active" = '1'
"Passive" = '0'
other = '.'
;
run;
data want;
set have;
stat_num = input(status,stat.);
stat_num2 = ifn(status="Active",1,0);
format status $stat.;
run;
Note how I presented your example data in a form that allows for easy recreation through a simple copy/paste and run.
You see three possible methods for achieving your objective, the last by not changing/setting any value at all, but by applying a display format.
Which method you use depends on the format in which you want to have the 0s and 1s.
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.