topic Re: Transactions depending upon Mode of holding !! in SAS Programming

Transactions depending upon Mode of holding !!

allurai0412 — Fri, 01 Mar 2013 09:46:41 GMT

hi ,

My data looks like this ..

For JOINT MODE and ANYONE OR SURVIVOR ...>PANGNO , PANGNO2 ...should and must be there.

For Single ..............> only one filed PANGNO ......should be there..

My output requires like this..

Regards

ALLU

esjackso — Fri, 01 Mar 2013 12:40:14 GMT

Is the question how to make the last column in the output? Not clear on the help that is needed.

allurai0412 — Fri, 01 Mar 2013 12:49:34 GMT

yes...the question about the last coulmn....

esjackso — Fri, 01 Mar 2013 12:59:15 GMT

See if this works. Check the capitalization of the data to make sure the code matches the data.

data output;

length auth $ 15;

set data;

auth = "Invalid";

if MOHDESC in ("JOINT MODE" "ANYONE OR SURVIVOR") and PANGNO ne "" and PANGNO2 ne "" then do;

if mohdesc = "JOINT MODE" then auth = "Both";

else auth = "Any";

end;

else if MOHDESC = "SINGLE" and (PANGNO ne "" or PANGNO2 ne "") then auth ="single";

run;

allurai0412 — Fri, 01 Mar 2013 13:20:06 GMT

hi...

i need the condition for "SINGLE "

like this

it should and must have only one "PANGNO ".... will below code , that you have provided works ??

else if MOHDESC = "SINGLE" and (PANGNO ne "" or PANGNO2 ne "") then auth ="single";

regards

ALLU

esjackso — Fri, 01 Mar 2013 13:34:35 GMT

if it you want to check for only one PAGNO for Single I would do something like the following:

else if MOHDESC = "SINGLE" and ((PANGNO ne "" and PANGNO2 = "") or ((PANGNO = "" and PANGNO2 ne ""))

then auth ="single";

allurai0412 — Tue, 05 Mar 2013 08:03:06 GMT

Thanks....