topic Re: Convert numeric columns to date in SAS Enterprise Guide

Convert numeric columns to date

PatrykSAS — Mon, 04 May 2020 09:13:34 GMT

Hi all,

my dataset contains 2 numeric columns YEAR and MONTH. Example:

YEAR MONTH

2017 6

2018 8

2017 5

2019 11

I want to see a date of them (in SAS date format). It should looks like:

DATE

2017-06

2018-08

2017-05

2019-11

Have you any idea how to achieve that?

Have a nice day 🙂

Re: Convert numeric columns to date

PeterClemmensen — Mon, 04 May 2020 09:11:51 GMT

Do you want DATE to be a character or SAS Date variable?

Re: Convert numeric columns to date

PatrykSAS — Mon, 04 May 2020 09:12:38 GMT

Date should be SAS date variable

Re: Convert numeric columns to date

ed_sas_member — Mon, 04 May 2020 09:19:37 GMT

Hi @PatrykSAS

You can do this.

-> the MDY() function returns a SAS date value from month, day, and year values.

-> DATE will be a valid SAS date, with a format to have the desired display

-> Here, the first of each month have been imputed.

Best,

data have;
	input YEAR MONTH;
	datalines;
2017   6
2018   8
2017   5
2019   11
;
run;

data want;
	set have;
	format DATE yymmd7.;
	DATE = mdy(MONTH,1,YEAR);
run;

Re: Convert numeric columns to date

PeterClemmensen — Mon, 04 May 2020 09:15:47 GMT

Try this

data have;
input YEAR MONTH;
datalines;
2017 6
2018 8
2017 5
2019 11
;

data want;
    set have;
    date=mdy(month, 1, year);
    format date yymmd7.;
run;

Re: Convert numeric columns to date

ballardw — Mon, 04 May 2020 09:17:25 GMT

data want;

set have;

date = mdy(month,1,year);

format date yymmd7.;

run;

Any SAS date must have a day of the month associated. SAS will use the first of the month as the day for the year and month only informats. So this would be consistent.

Re: Convert numeric columns to date

PatrykSAS — Mon, 04 May 2020 09:21:02 GMT

It works great, thank you all

Re: Convert numeric columns to date

novinosrin — Mon, 04 May 2020 12:08:39 GMT

"Any SAS date must have a day of the month associated. SAS will use the first of the month as the day for the year and month only informats. So this would be consistent."

Good morning and Thank you Sir @ballardw for that. Those are valuable information/notes I am looking from veterans like you. Well, I often take notes in many of the threads you participate since the time you once taught me time series shifting intervals like fiscal- years/quarters. In essence, what I need is the mechanics of how stuff works, I shall do the coding myself. Thank you once again for all the notes that are priceless.