topic Convert quarter to dates in SAS Enterprise Guide

Convert quarter to dates

ywon111 — Wed, 23 Sep 2020 11:15:58 GMT

Have a dataset with a quarter variable like below:

Quarter
202009
202003
202003
202006

Is there a way to convert this to a date? Ideally something like ddmmmyy

Thanks

Re: Convert quarter to dates

PaigeMiller — Wed, 23 Sep 2020 11:32:37 GMT

Are these numeric values? Are these formatted as yymmn6.? Are they character values?

Depending on your answers above, the method to convert to dates changes.

Re: Convert quarter to dates

ywon111 — Wed, 23 Sep 2020 11:35:07 GMT

They are not formatted. Importing from an excel and all it displays in
excel is 202009 (example). Thanks ##- Please type your reply above this
line. No attachments. -##

Re: Convert quarter to dates

PaigeMiller — Wed, 23 Sep 2020 11:37:23 GMT

But I don't care how it displays in Excel. Is that how it displays in SAS? Is it numeric or character in SAS?

Re: Convert quarter to dates

novinosrin — Wed, 23 Sep 2020 13:11:06 GMT

Hi @ywon111 , @PaigeMiller is asking for the metadata/descriptor info or in other words properties of your sas dataset that was created by importing the contents of the excel file.

To view the descriptor portion, you would need to run

proc contents data=your_sasdataset;

run

The output of proc contents would contain whether your quarter variable is numeric or char and other info. Please provide that info and then based upon which the SAS community would recommend your much needed solution. Thank you!

Re: Convert quarter to dates

ballardw — Wed, 23 Sep 2020 14:21:22 GMT

@ywon111 wrote:
Have a dataset with a quarter variable like below:

Quarter
202009
202003
202003
202006

Is there a way to convert this to a date? Ideally something like ddmmmyy

Thanks

Yes there is a way. Assuming the value you show is actually YYYYMM (not quarter but month). However the approach varies depending on 1) whether the value after you brought it into SAS is character or numeric and 2) which particular date, which must include a day of the month, you want. The simplest SAS tools would assume that you want to create the first date of the calendar quarter such as 01/09/2020. If you expect something else from 202009 then you need to specify it.

Re: Convert quarter to dates

ywon111 — Wed, 23 Sep 2020 20:53:05 GMT

It's displayed as numeric in SAS.
Thanks

Re: Convert quarter to dates

ywon111 — Wed, 23 Sep 2020 23:17:56 GMT

It's formatted as numeric in SAS.

From proc contents: Format: BEST12.

Re: Convert quarter to dates

Kurt_Bremser — Thu, 24 Sep 2020 06:04:50 GMT

Since the variable shows months, not quarters, you can convert it with this:

quarter = input(put(quarter,6.),yymmn6.);
format quarter yymmdd10.;