topic Re: Extracting a variables by date in SAS Programming

Extracting a variables by date

jflo36 — Mon, 23 May 2016 16:23:28 GMT

I am trying to extract variables from a dataset by certain date, but my code is not working. I will get the columns header with 0 rows.

can someone please help? attached is the code I use.

PROC SQL;
CREATE TABLE TEST AS
SELECT CURRENT_DATE, BLANK_NUMBER
FROM BLANK.DATA
WHERE CURRENT_DATE IN (04-01-2016 - 04-30-2016);
QUIT;

Thanks,

Re: Extracting a variables by date

ballardw — Mon, 23 May 2016 17:27:52 GMT

You should have gotten error messages with that code. In the future if you have code throwing errors include the log with the code and the error messages for best results.

If your current_date is an actual SAS date value then you do comparisons with literal values using "ddMONYYYY"D syntax. That is the only allowable form for explicit dates. So you likely needed to use "01APR2016"d and "30APR2016"d. Second the IN operator doesn't use a - to indicate a range, use : instead in( 1:10) is range of 1 to 10.

Easier in this case may be to use

Where Month(Current_date) = 4

where Current_date is between "01APR2016"d and "30APR2016"d;

Re: Extracting a variables by date

jflo36 — Mon, 23 May 2016 18:00:24 GMT

Thanks ballardw! I try it but it did not work.

Re: Extracting a variables by date

ballardw — Mon, 23 May 2016 20:38:30 GMT

Please show the Log of the submitted code and any error messages. "Didn't work" is awful vague to try to work with.