topic Re: Subset dataset by date in SAS Programming

Subset dataset by date

ganeshsas764 — Wed, 30 Mar 2016 14:22:40 GMT

hi ,

this isate ganesh, i have one doubt ,

id name date

101 xxx 19/05/15

102 YYY 19/06/16

103 zzz 19/05/15

i want '19/05/15' date values into output dataset ,how to solve this probleam .

Regards

A.Ganesh

subset date value

ganeshsas764 — Wed, 30 Mar 2016 14:00:37 GMT

hi ,

this is ganesh, i have one doubt ,

id name date

101 xxx 19/05/15

102 YYY 19/06/16

103 zzz 19/05/15

i want '19/05/15' date values only into output dataset ,how to solve this probleam .

Regards

A.Ganesh

Re: subset date date

LinusH — Wed, 30 Mar 2016 14:03:07 GMT

Please elaborate.

Is the example data from an external file?

And you wish to store it in a SAS data set (output)?

Use an informat to translate the date into a SAS date numerical variable.

Re: subset date date

RW9 — Wed, 30 Mar 2016 14:03:33 GMT

Hi,

Is date a numeric variable or character. Depending on that you could use where clause or if etc.

data want;
  set have;
  where date="19/05/15";
run;

or 

data want;
  set have;
  where date=input("19/05/15",ddmmyy8.);
run;

Re: subset date date

ganeshsas764 — Wed, 30 Mar 2016 14:07:40 GMT

that values are stored in sas dataset,how to subset particular date values

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: subset date date

ganeshsas764 — Wed, 30 Mar 2016 14:11:40 GMT

tq

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Subset dataset by date

Reeza — Wed, 30 Mar 2016 14:24:30 GMT

If you have a SAS date you can use the following to filter.

You can specify a date constant in SAS using the date9 format and with a d after the date.

"05Sep2015"d

Or you can use the MDY function to create a SAS date

mdy(5, 19, 15)

Re: Subset dataset by date

ogustavo — Tue, 06 Apr 2021 19:24:11 GMT

Use quotations followed by d (if using only date - dt, if you're using datetime), and write the date case as "19May15"d (it won't work with "19/05/15"d):

/* ===================================== */
/* Date */

DATA subset_by_date;
	INPUT id name $ date;
	INFORMAT date ddmmyy8.;
	FORMAT date ddmmyy8.;
	DATALINES;
101 xxx 19/05/15
102 YYY 19/06/16
103 zzz 19/05/15
;
RUN;

DATA works;
	SET subset_by_date;
	WHERE date = '19May15'd;
RUN;
* Returns only ids 101 and 103;

DATA works_too;
	SET subset_by_date;
	WHERE '18MAY15'D < date < '20May15'd;
RUN;
* Returns only ids 101 and 103;

DATA wont_work;
	SET subset_by_date;
	WHERE date = '19/05/15'd;
RUN;
* ERROR: Invalid date/time/datetime constant '19/05/15'd. ;

/* ===================================== */
/* Datetime */

DATA subset_by_datetime;
	INPUT id name $ datetime;
	INFORMAT datetime anydtdtm40.;
	FORMAT datetime datetime.;
	DATALINES;
101 xxx 19/05/15
102 YYY 19/06/16
103 zzz 19/05/15
;
RUN;

DATA works_datetime;
	SET subset_by_datetime;
	WHERE datetime = '16Jun19:00:00:00'dt;
RUN;
* Returns only id 102 ;

Re: subset date value

SAS-questioner — Tue, 06 Apr 2021 20:13:37 GMT

When you said you want '19/05/15' date values only into output dataset, do you mean make all other dates become '19/05/15', or you want to delete other dates but '19/05/15'?

Re: Subset dataset by date

Reeza — Tue, 06 Apr 2021 21:13:45 GMT

@SAS-questioner @ogustavo This is a 5 year old thread, if you have a question it may be best to post it as a new post not on top of this one. Only users who initially responded to this post will see any updates/responses.

Re: Subset dataset by date

ogustavo — Tue, 06 Apr 2021 22:28:41 GMT

@Reeza What I posted is a possible solution to the OP's issue, is it not? Where is the proper place for that?

Re: Subset dataset by date

Reeza — Wed, 07 Apr 2021 02:37:57 GMT

I'm not sure of the value of answering a 5+ year old question but that is your prerogative.