topic Re: How to find a particular date from a dataset in SAS Programming

How to find a particular date from a dataset

anilatikkha310 — Mon, 15 May 2017 19:04:34 GMT

Hi,

I am trying to fetch the id's who transacted money on 25thDec2016 only.

id	date	Transaction_Amount
1	25-Dec-16	2300
2	16-May-16	3000
3	1-Jan-16	1200
4	25-Dec-16	4000
5	31-Oct-16	9000
6	25-Sep-16	1700
7	25-Dec-16	800
8	19-Mar-16	500
9	9-Jul-16	2000
10	25-Dec-16	1500

Please help!!

Re: How to find a particular date from a dataset

PeterClemmensen — Mon, 15 May 2017 19:15:36 GMT

How is your data stored? Is date stored as a character or numeric variable?

Re: How to find a particular date from a dataset

anilatikkha310 — Mon, 15 May 2017 19:22:28 GMT

The date is stored in numeric format.
##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: How to find a particular date from a dataset

PeterClemmensen — Mon, 15 May 2017 19:28:05 GMT

You can extract the relevant observations like this

data have;
input id $ date :date7. Transaction_Amount;
format date date7.;
datalines;
1 25-Dec-16	2300
2 16-May-16	3000
3 1-Jan-16 1200
4 25-Dec-16	4000
5 31-Oct-16	9000
6 25-Sep-16	1700
7 25-Dec-16	800
8 19-Mar-16	500
9 9-Jul-16 2000
10	25-Dec-16 1500
;

data want;  
   set have;
   where date = '25DEC16'd;
run;

Is that what you want?

Re: How to find a particular date from a dataset

Reeza — Mon, 15 May 2017 19:54:55 GMT

If the field is a SAS date, numeric with a date format then you need a date literal.

Date Literal (d)

When hard coding in a date into your code or creating a date, you need to specify it in the DATE9. format, and add a d at the end. For example:

date_var = ’31Jan2016’d;

You aren’t required to put in a 4 year date, but I highly recommend it. Another way to reference a date without using a literal is to use the MDY function. 1,

x = MDY(1, 31, 2016);

With the dates specified in this format you can use it in your code, either assign it to a variable or use it for comparison. The following two lines of code will result in the same thing

if x=’31Jan2016’d then do;

if x=mdy(1, 31, 2016) then do;

Re: How to find a particular date from a dataset

anilatikkha310 — Tue, 16 May 2017 03:05:03 GMT

Thanks for explaining the above cases it is really informative.