topic Re: Formatting value in SAS Programming

Formatting value

rgururaj1980 — Mon, 12 Jun 2017 20:04:37 GMT

Hello, please help me in the below issue for formatting in sas
I have a file containing variable Result which has value of
(C1='y' and b1='N' and a1='y') like that
I want to replace a1,b1,c1 etc with text. Like customer1='y' and customerb ='n'

Re: Formatting value

PeterClemmensen — Mon, 12 Jun 2017 20:07:48 GMT

Just to be clear, you have a character variable called Result which contains a string like "(C1='y' and b1='N' and a1='y')" ?

Re: Formatting value

rgururaj1980 — Mon, 12 Jun 2017 21:29:11 GMT

Yes

Re: Formatting value

rgururaj1980 — Mon, 12 Jun 2017 21:30:00 GMT

I have lot of values like d1, e1 etc

Re: Formatting value

Reeza — Mon, 12 Jun 2017 21:48:20 GMT

http://www2.sas.com/proceedings/sugi30/001-30.pdf

This paper walks through how to recode variables using a format. It's well written and clear.

Another standard way to recode is IF/THEN statements.

Re: Formatting value

ChrisNZ — Tue, 13 Jun 2017 05:00:48 GMT

C1 is your variable name, so you want to rename your variables.

You'll need something like:

data WANT;
  set HAVE(rename=(C1=CUSTOMER1 
                   B1=CUSTOMERB)
          );
  RESULT=(CUSTOMER1 ='Y' & CUSTOMERB='N' );
run;

Re: Formatting value

rgururaj1980 — Tue, 13 Jun 2017 14:34:17 GMT

Formula is my variable name and it contains "c1=yes,b1=no, z3=yes" . It has value like this . I want to change c1 b1 e1 with text

Re: Formatting value

rgururaj1980 — Tue, 13 Jun 2017 14:37:36 GMT

I have different values for different observation

Re: Formatting value

ChrisNZ — Wed, 14 Jun 2017 01:41:12 GMT

Your explanations were not clear. Always show : this is what I have & this is what I want.

Like this?

data WANT;
  length RESULT $1000;
  RESULT= "(C1='y' and b1='N' and a1='y')" ;
  RESULT=transtrn(RESULT,'C1=','CUSTOMER1=');
  RESULT=transtrn(RESULT,'b1=','CUSTOMERB=');
  putlog RESULT=;
run;

RESULT=(CUSTOMER1='y' and CUSTOMERB='N' and a1='y')

Don't forget to make your string longer.