topic Re: proc sql case when in SAS Procedures

proc sql case when

septemberbulb — Mon, 23 Jan 2017 15:07:37 GMT

Hello,

I am a new programmer and hope to get some help.I've already created a table. However, some codes can not be grabed because of the applicationdate not equal to codesdate. So I want to add the blank obs from the previous applicationdate. I am not quite sure whether can I use proc sql case when like this as below:

proc sql;

create table new as

select origianl*

case when codes=' ', then rules.codes where codesdate=min(original.codesdate)

else original.codes

end as codes;

quit;

whehter can I use other more simple logic for example data; set; My goal is to look back to the rules table where the codedate is min() when the codes are blank and the rest keep their original value.

thank you.

Re: proc sql case when

RW9 — Mon, 23 Jan 2017 15:12:05 GMT

Start by posting some test data - in the form of a datastep. Follow this post if you need to:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Secondly, your SQL statement is invalid in several ways, first you have no "from" clause, second origianl* - is invalid.

Post what you have, and show what you want at the end. Note you don't necessarily need to use SQL, but its hard to advise on the limited information you have provided.

Re: proc sql case when

Kurt_Bremser — Mon, 23 Jan 2017 15:13:17 GMT

Please supply some example data (in a data step) for us to play around with, and so we get a feel for your data structure.

And post the desired result.