Help using Base SAS procedures

Proc sql and pulling obs =< the last date of the month

Reply
Frequent Contributor
Posts: 142

Proc sql and pulling obs =< the last date of the month

Hi—

I’m trying to pull cases which are =< to the last date of the month based on a certain date variable (DISPOSITION_DATE). The dataset contains data for all 12 months of the year so I’m not sure of to take this into account.

Proc sql;

create table want as

select distinct

var1,

var2,

var3

datepart(DISPOSITION_DATE),

from

have;

quit;

Any help is greatly appreciated!

Super User
Posts: 17,829

Re: Proc sql and pulling obs =< the last date of the month

It depends on the relation between your disposition date and the last date of the month.

You'll need to provide some more information on your criteria and some sample data with expected output is always helpful.

If you had a fixed date something like the following would work.

Proc sql;

create table want as

select distinct var1,  var2, var3

from have

where datepart(disposition_date) <= '31jul2012'd

;

quit;

Ask a Question
Discussion stats
  • 1 reply
  • 196 views
  • 0 likes
  • 2 in conversation