proc sql case when

[septemberbulb]

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.

[RW9]

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-dat...

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.

[Kurt_Bremser]

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.