01-23-2017 10:07 AM
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:
create table new as
case when codes=' ', then rules.codes where codesdate=min(original.codesdate)
end as codes;
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.
01-23-2017 10:12 AM
Start by posting some test data - in the form of a datastep. Follow this post if you need to:
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.
01-23-2017 10:13 AM
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.