topic Re: Extracting month/day from dates in New SAS User

Extracting month/day from dates

AMMAN — Fri, 01 Feb 2019 00:03:49 GMT

data month;
set work.student_roster;
length justmonth $15;
justmonth = scan(birth_day, 2, 3);
run;

I need to extract the month from a field formatted as a date9. For example, if the value is 31Jan1999, I need to extract "Jan" as a new variable. I'm using the scan function but I'm getting weird results:

I think this is because of the format. I need to reformat this variable into a string? If that's correct, can you please suggest the best way to go about it?

Re: Extracting month/day from dates

Reeza — Fri, 01 Feb 2019 00:52:24 GMT

If you have a SAS date, which is a variable that's numeric with a date format then you have a number and SCAN() will not work on a number. You can convert it to a character or you can use formats to get your desired output.

data have;

format date date9.;

do date='01Jan2018'd to '31Dec2018'd by 30;
    month = put(date, monname3.);
    day = day(date);
    output;
end;

run;

@AMMAN wrote:
data month;
set work.student_roster;
length justmonth $15;
justmonth = scan(birth_day, 2, 3);
run;
I need to extract the month from a field formatted as a date9. For example, if the value is 31Jan1999, I need to extract "Jan" as a new variable. I'm using the scan function but I'm getting weird results:

I think this is because of the format. I need to reformat this variable into a string? If that's correct, can you please suggest the best way to go about it?

Re: Extracting month/day from dates

ChrisBrooks — Fri, 01 Feb 2019 01:06:35 GMT

Hi @AMMAN

Actually the dates in your attachment aren't formatted as date9 but as mmddyy9 but the same solution should work either way. You can use a put statement with the monnmae format as shown below (I've used the first three records from your attachment

data have;
	infile datalines dlm=",";
	length name $5 bday 8;
	informat bday mmddyy9.;
	format bday mmddyy9.;
	input name bday;
datalines;
Chas,5/15/1986
Pearl,3/6/1997
Troy,3/26/1999
;
run;

data want;
	set have;
	justmonth=substr(strip(put(bday, monname.)),1,3);
run;

Re: Extracting month/day from dates

ballardw — Fri, 01 Feb 2019 15:54:12 GMT

@ChrisBrooks wrote:

Hi @AMMAN

Actually the dates in your attachment aren't formatted as date9 but as mmddyy9 but the same solution should work either way. You can use a put statement with the monnmae format as shown below (I've used the first three records from your attachment

@ChrisBrooks

Why not

justmonth= put(bday, monname3.);

Re: Extracting month/day from dates

AMMAN — Fri, 01 Feb 2019 19:20:48 GMT

Thank you!

Re: Extracting month/day from dates

AMMAN — Fri, 01 Feb 2019 19:21:12 GMT

Thank you! This worked!

Re: Extracting month/day from dates

AMMAN — Fri, 01 Feb 2019 19:21:55 GMT

Thank you. This worked. In fact, I tried all the recommendations and they worked! I'm not sure how to mark "solution" in this case.

Re: Extracting month/day from dates

ChrisBrooks — Sat, 02 Feb 2019 00:51:07 GMT

Good point @ballardw that's more succinct!

Re: Extracting month/day from dates

ChrisBrooks — Sat, 02 Feb 2019 00:52:46 GMT

Good to hear @AMMAN I'd encourage you to pick and solution and mark it as accepted. It helps others when searching/filtering through posts.