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.
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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.