How to convert date from 2014Q3 to 30SEP2014

eagles_dare13 — Tue, 04 Nov 2014 18:58:17 GMT

I have a date that is coming in from an excel like this:2014Q3.

How to convert this to the last day of the quarter and store in date9. format like 30SEP2014.t

Re: How to convert date from 2014Q3 to 30SEP2014

art297 — Tue, 04 Nov 2014 19:14:58 GMT

Depends upon whether it imported as a SAS date or as a character variable. Here is how to convert either:

data have;

input qtr yyq6. charqtr $;

format qtr cqtr date9.;

qtr=intnx('quarter',qtr,0,'E');

cqtr=intnx('quarter',input(charqtr,yyq6.),0,'E');

cards;

2014Q3 2014Q3

;