topic Re: Help with Date Range in New SAS User

Help with Date Range

Jallah_Kennedy — Mon, 03 Oct 2022 21:03:08 GMT

Please help me with selecting record from a certain date range. The variable is Comp_Date (formatted already as a date) and I want to select (e.g. 20, 30...) records to view all with all of the other variables.

Thanks.

Re: Help with Date Range

ballardw — Mon, 03 Oct 2022 21:18:50 GMT

20 or 30 is not a "date range". A date range would typically refer to a start date value and and end date value. Is that what you want?

If so, what range specifically do you want?

Re: Help with Date Range

Reeza — Mon, 03 Oct 2022 21:26:11 GMT

Using sashelp.Stocks as an example as no data is provided:

data stocks;
set sashelp.stocks (obs=30 where =( '01Jan1990'd <= date <= '31Dec1995'd));
run;

Log:

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 68         
 69         data stocks;
 70         set sashelp.stocks (obs=30 where =( '01Jan1990'd <= date <= '31Dec1995'd));
 71         run;
 
 NOTE: There were 30 observations read from the data set SASHELP.STOCKS.
       WHERE (date>='01JAN1990'D and date<='31DEC1995'D);
 NOTE: The data set WORK.STOCKS has 30 observations and 8 variables.

@Jallah_Kennedy wrote:

Please help me with selecting record from a certain date range. The variable is Comp_Date (formatted already as a date) and I want to select (e.g. 20, 30...) records to view all with all of the other variables.

Thanks.

Re: Help with Date Range

Jallah_Kennedy — Mon, 03 Oct 2022 23:39:37 GMT

Thanks you so much. It worked. Much appreciated.