Help using Base SAS procedures

proc sql case when

Reply
Contributor
Posts: 28

proc sql case when

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.

Super User
Super User
Posts: 7,955

Re: proc sql case when

Posted in reply to septemberbulb

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.

Super User
Posts: 7,786

Re: proc sql case when

Posted in reply to septemberbulb

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 2 replies
  • 154 views
  • 0 likes
  • 3 in conversation