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

[Mgarret]

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!

[Reeza]

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;