topic Where= command with formatted date variable in SAS Procedures

Where= command with formatted date variable

BchBnz — Sun, 16 Mar 2014 21:56:13 GMT

Hello everyone,

I hope you are well.

I know my question might seem basic but I can't seem to figure it out.

I am trying to filter my data based on a date variable

My date variable is formatted using yymmdd10.

I tried

Where 20080102 <=date <= 20101231;

Where '20080102'd <=date <= '20101231'd;

Where "2008-01-02" <=date <= "2010-12-31";

Sorry for taking your time. Thank you very much for your help.

Tom — Sun, 16 Mar 2014 22:09:35 GMT

Date literals in SAS use the DATE format. The format attached the variable does not matter as the format does not modify the stored value.

Where '02JAN2008'd <=date <= '31DEC2010'd;

BchBnz — Sun, 16 Mar 2014 23:18:28 GMT

Oh I did not know that!

Thank you very much Tom. You are always very helpful.