topic Re: PROC SQL Case WHEN....how to? in SAS Procedures

PROC SQL Case WHEN....how to?

VinnyR — Wed, 21 Feb 2018 18:01:35 GMT

Edited...

How would I in a Proc SQL statement maintain this datastep: Also, I want to obtain a cartesian product so there is a deviation form datastep but it will be controlled by a where clause in the Proc SQl Code.

data want;

merge dset_1 dset_2;

by "some common variable properly sorted";

if dset_1.var1 = dset_2.var1 then do;

dset_1.var2=dset_2.var2;

dset_1.var3=dset_2.var3;

end;

else do;

dset_1.var1= "Missing";

dset_1.var2= "Missing";

end;

run;

Somebody please help me understand this. I tried various combinations nothing worked.

Regards,

Vinny.

Re: PROC SQL Case WHEN....how to?

tomrvincent — Wed, 21 Feb 2018 17:57:29 GMT

I don't know what 'contelled' is, but what do you want to happen if dset_1.var1 is not equal to dset_2.var1?

Re: PROC SQL Case WHEN....how to?

VinnyR — Wed, 21 Feb 2018 18:03:18 GMT

Hi Tom,

I am sorry about that...updated the information.Thanks for noticing and notifying.

Regards,

Vinny.

Re: PROC SQL Case WHEN....how to?

tomrvincent — Wed, 21 Feb 2018 18:06:06 GMT

so you'd want to do a left join between the 2 tables. Then your case statement can be something like

case when table2.var is missing then 'missing' else table2.var end

Re: PROC SQL Case WHEN....how to?

LinusH — Fri, 23 Feb 2018 16:02:40 GMT

You'll need a case for each var assignment, hence repeating of some logic - one little drawback for SQL over the data step.