topic Re: Proc sql and pulling obs =< the last date of the month in SAS Procedures

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

Mgarret — Mon, 09 Jul 2012 18:28:14 GMT

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!

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

Reeza — Mon, 09 Jul 2012 19:11:10 GMT

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;