topic Re: Create new variable in SAS Programming

Create new variable

jhh197 — Wed, 19 Jan 2022 19:20:51 GMT

Hi ,

I have a dataset which has rpflag , rp1,rp2,rp3,rp4 amounts in numeric format . I want to create rp5 column

case when rpflag = 'Y' then (TRIM(put(rp1,8.)))||'/'||(TRIM(put(rp2,8..)))
when rpflag = 'N' then (TRIM(put(rp3,8.)))||'/'||(TRIM(put(rp4,8.)))
else '' end as rp5

RPFlag	RP1	RP2	RP3	RP4	RP5
Y	20	35	0	0	20/35
N	0	0	20	30	20/30
N	0	0	0	0	0/0
Y	0	0	0	0	0/0
Y	56	33	0	0	56/33

Re: Create new variable

jhh197 — Wed, 19 Jan 2022 19:21:23 GMT

Can anyone please help thank you

Re: Create new variable

PeterClemmensen — Wed, 19 Jan 2022 19:40:59 GMT

Does it have to be SQL code?

Re: Create new variable

Reeza — Wed, 19 Jan 2022 19:44:57 GMT

Make sure to read the log and include in future posts.

You have two periods in the PUT statement.

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 68         
 69         
 70         proc sql;
 71         create table want as
 72         Select *,
 73         case when rpflag = 'Y' then (TRIM(put(rp1,8.)))||'/'||(TRIM(put(rp2,8..)))
                                                                                  _
                                                                                  22
                                                                                  200
 ERROR 22-322: Syntax error, expecting one of the following: ), -.  
 
 ERROR 200-322: The symbol is not recognized and will be ignored.

That's fairly complicated coding though - using CATX() is preferable - it trims automatically and adds in the / in between.

This is cleaner IMO:

case when rpflag = 'Y' then catx('/', put(rp1, 8.), put(rp2, 8.))
when rpflag = 'N' then catx('/', put(rp1, 8.), put(rp2, 8.))
else '' end as rp6

@jhh197 wrote:

Hi ,

I have a dataset which has rpflag , rp1,rp2,rp3,rp4 amounts in numeric format . I want to create rp5 column

case when rpflag = 'Y' then (TRIM(put(rp1,8.)))||'/'||(TRIM(put(rp2,8..)))
when rpflag = 'N' then (TRIM(put(rp3,8.)))||'/'||(TRIM(put(rp4,8.)))
else '' end as rp5

RPFlag RP1 RP2 RP3 RP4 RP5

Y 20 35 0 0 20/35

N 0 0 20 30 20/30

N 0 0 0 0 0/0

Y 0 0 0 0 0/0

Y 56 33 0 0 56/33

Re: Create new variable

Tom — Wed, 19 Jan 2022 20:29:07 GMT

CATX() also does not require you to convert your numbers to strings. It will convert them automatically.

case when rpflag = 'Y' then catx('/', rp1,rp2)
     when rpflag = 'N' then catx('/', rp3,rp4)
     else ' ' 
end as rp6

Re: Create new variable

jhh197 — Wed, 19 Jan 2022 20:41:29 GMT

Thank you so much it worked

Re: Create new variable

jhh197 — Wed, 19 Jan 2022 20:42:11 GMT

Thank you everyone for helping 🙂

Re: Create new variable

Reeza — Wed, 19 Jan 2022 21:01:43 GMT

@Tom wrote:

CATX() also does not require you to convert your numbers to strings. It will convert them automatically.
case when rpflag = 'Y' then catx('/', rp1,rp2)
     when rpflag = 'N' then catx('/', rp3,rp4)
     else ' ' 
end as rp6

True and even simpler!