How to convert date value from day to Quarter in SAS

date sas datastep
Elif Y picture Elif Y · Oct 8, 2014 · Viewed 8.3k times · Source

I have a data set like this:

date 
01JAN90
01APR90
01JUL90
01OCT90
01JAN91
01APR91
01JUL91
01OCT91

I want to convert the date value into 

date
1990Q1
1990Q2
1990Q3
1990Q4
1991Q1
1991Q2
1991Q3
1991Q4

How can I do it in SAS?

Answer

PKumar picture PKumar · Oct 8, 2014

Use something like this :

format date yyq.;

where "date" is your date variable.

It will do your job.

Edit: After the datetime7. error, If your date is in character datetime format, first extract the date using datepart and then apply the format on the date.

sasdate = datepart(date);
fmtdate = put(sasdate,yyq.);

Here fmtdate is your final answer.

see here for format yyq.

see here for datepart

Hope this finally helps

Related questions

sas date - convert today() into yyyymmdd format

How do I convert a SAS date such as "30JUL2009"d into YYYYMMDD format (eg 20090730)? So for instance: data _null_; format test ?????; test=today(); put test=; run; Would give me "test=20090730" in the log...

Read More
sas adding 7 days to a date

I would need to add to a date format variable 7 days. The variable is creation_date and is like 01JAN14:00:08:04. I wrote this in a data step sevendays_after=CREATION_DATE+ 7 * 24 * 60 * 60; but the result is like 1.70476E9 and I need …

Read More
SAS - Custom Date Format - YYYYMMDDhhmmss

I need to add a current date to the output I am exporting from SAS in the following format: filename_YYYYMMDDhhmmss.csv I am creating a macro variable the following way: %let date_human = %sysfunc(today(), YYYYMMDDn8.); Does anybody know …

Read More