topic Re: month of time in SAS Programming

month of time

znhnm — Fri, 30 Dec 2022 02:35:08 GMT

I have a time type columnç One example record is: 03JUN22:00:00:00.

How can I get the month part of it, JUN? Thank you!

Re: month of time

Astounding — Fri, 30 Dec 2022 02:57:35 GMT

This will get you the month as a number from 1 to 12:

m = month(datepart(varname));

Will that do?

Or maybe your original variable is a character string and you could use:

m = substr(varname, 3, 3);

Re: month of time

andreas_lds — Fri, 30 Dec 2022 07:03:29 GMT

This seems to be a datetime variable, that is a numeric variable with a format attached displaying the value as date and time. Maybe it is a string. Impossible to know without seeing the result of proc contents of the dataset containing the variable.

Re: month of time

s_lassen — Fri, 30 Dec 2022 09:47:38 GMT

As @andreas_lds noted, this can be a datetime variable (numeric) or a string. You can use PROC CONTENTS to find out what it is.

In the first case, get the date part, and use a format to get the month name, e.g.:

Length Month $3;
Month=put(datepart(<column name>),monyy5.);

The MONYY format actually gets both the month and the year, e.g. "JUN22", but because we set the length of the MONTH variable to 3, it will only contain "JUN".

In the second case, you can use SUBSTR:

Length Month $3;
Month=substr(<column name>,3,3);

Re: month of time

znhnm — Fri, 30 Dec 2022 09:51:09 GMT

Hi, thank you. It's Num 8 type DATETTIME. format.

Re: month of time

znhnm — Fri, 30 Dec 2022 10:01:55 GMT

It helped a lot, thank you!

Re: month of time

Ashish_Vashist — Fri, 30 Dec 2022 10:05:32 GMT

Data Question;
	Date_Time_Variable = Dhms('03JUN22'd,00,00,00);
	format Date_Time_Variable datetime. ;
run;

/* YOU CAN USE THIS COUSTOM FORMAT FOR MONTHS*/
Proc Format;
	value  MonthName    1 = "JAN"
						2 = "FEB"
						3 = "MAR"
						4 = "APR"
						5 = "MAY"
						6 = "JUN"
						7 = "JUL"
						8 = "AUG"
						9 = "SEP"
						10= "OCT"
						11= "NOV"
						12= "DEC"
						;
run;
	
Data Answer;
	set Question;
	*Extract Date from Date_Time_Variable;
	Date  = DatePart(Date_Time_Variable);
	*Extracting Month From Date using Month Function that will return corresponding month number (1 - 12);
	MonthNumber = Month(Date);
	*Creating another variable Month that will use the above created 
        Format;
	Month = put(MonthNumber,MonthName.);
	format date date9.;
run;

Re: month of time

znhnm — Fri, 30 Dec 2022 11:11:40 GMT

Thanks lot for this! I was trying to find a solution to have it on both number on 3-letter format. I have it both with your way which is amazing.