topic Re: Selecting data based on fixed date in SAS Programming

Selecting data based on fixed date

abdulla — Sun, 06 Oct 2019 09:45:12 GMT

Date	price
19890731	1.981
19900731	1.287
19910731	1.792
19921231	7.271
19931231	13.017
19941231	22.317
19981231	27.857
19991231	26.242
20001231	35.12
20011231	12.808
20021231	11.907
19901231	5.656
19911231	3.85

From the above data I want to keep data related 31st December. So, I need code for YR1231. Please help

Re: Selecting data based on fixed date

ed_sas_member — Sun, 06 Oct 2019 09:17:32 GMT

HI @abdulla ,

Maybe this is something you can try:

data have;
	input Date yymmdd8. price;
	format Date date9.;
	cards;
19890731	1.981
19900731	1.287
19910731	1.792
19921231	7.271
19931231	13.017
19941231	22.317
19981231	27.857
19991231	26.242
20001231	35.12
20011231	12.808
20021231	11.907
19901231	5.656
19911231	3.85
;
run;

data want;
	set have;
	where month(date)=12 and day(date)=31;
run;

Hope this help.

Re: Selecting data based on fixed date

abdulla — Sun, 06 Oct 2019 09:27:14 GMT

Hi, how will I do that without input command?

Re: Selecting data based on fixed date

ed_sas_member — Sun, 06 Oct 2019 09:28:14 GMT

Hi, is your file already a SAS dataset?

Re: Selecting data based on fixed date

abdulla — Sun, 06 Oct 2019 09:30:06 GMT

Yes

Re: Selecting data based on fixed date

ed_sas_member — Sun, 06 Oct 2019 09:31:23 GMT

Perfect. And what is the type of the Date variable? (Num or Char). Is it already recognize as a date ?

Re: Selecting data based on fixed date

abdulla — Sun, 06 Oct 2019 09:34:26 GMT

I think it is num. It is exactly what I have given in the example. So, I have a large data set. I imported the excel in which date is given in the same style as my example

Re: Selecting data based on fixed date

ed_sas_member — Sun, 06 Oct 2019 09:39:17 GMT

OK. I encourage you to check the variable type / format / etc. by using a proc contents:

proc contents data=have;
run;

If it is a character variable, you will a have to convert it using the input() function or the substr() function depending if you need to have this variable as a date.

If it is a numeric variable, you will a have to apply a date format.

Re: Selecting data based on fixed date

abdulla — Sun, 06 Oct 2019 09:40:26 GMT

Alphabetic List of Variables and Attributes
# Variable Type Len Label
4 Assets Num 8 Assets
2 Date Num 8 Date
5 Earnings Num 8 Earnings
3 FY Num 8 FY
1 gvkey Num 8 gvkey

This is what I have

Re: Selecting data based on fixed date

abdulla — Sun, 06 Oct 2019 09:46:51 GMT

So, I have attached example of my data. Please download it and use proc import to import the data. Then what code should I use to get my desired result?

Re: Selecting data based on fixed date

ed_sas_member — Sun, 06 Oct 2019 09:47:02 GMT

Could you please try this ?

data have2;
	set have;
	format date2 date9.;
	date2 = input(put(date,8.),yymmdd8.); /* Date2 = date in a date format*/
run;

Re: Selecting data based on fixed date

abdulla — Sun, 06 Oct 2019 09:52:33 GMT

Thank you very much. It worked

Re: Selecting data based on fixed date

ed_sas_member — Sun, 06 Oct 2019 09:53:14 GMT

Awesome! Have a great day.