topic Re: simple conversion of character variables in SAS Procedures

simple conversion of character variables

trekvana — Wed, 06 Oct 2010 18:56:30 GMT

hello all-

say i have a character variable x=(a,a,a,a,c,c,b,b,b,d,d,e) how can i convert this to y=(1,1,1,1,2,2,3,3,3,4,4,5).

ive tried the input command but im not sure how to use this. im assuming there must be an easy way to do this

cheers

Re: simple conversion of character variables

sbb — Wed, 06 Oct 2010 19:01:59 GMT

Look at using the TRANSLATE function - you will need to define argument2 and argument3 with the value mapping/associations.

Scott Barry
SBBWorks, Inc.

Re: simple conversion of character variables

SASKiwi — Wed, 06 Oct 2010 20:05:14 GMT

I would be inclined to create an custom INFORMAT to do this:

proc format;
invalue alpha_order 'A' = 1;
run;

data test;
var = 'A';
var_order = input(var, alpha_order.);
put _all_;
run;

You could expand this example to cover all 26 alphabet letters, or write a DATA step to generate a PROC FORMAT input dataset automatically.

Re: simple conversion of character variables

Ksharp — Mon, 11 Oct 2010 09:06:28 GMT

Just as SBB said.Try this.
[pre]
data a;
input x $;
datalines;
a
a
a
a
c
c
b
b
b
d
d
e
;

data b;
set a;
_x=translate(x,'12345','abcde');
run;
proc print;
run;
[/pre]

Ksharp