topic Re: Char Date to SAS Date in SAS Enterprise Guide

Char Date to SAS Date

aakash93 — Thu, 19 Jul 2018 23:04:28 GMT

Hi I'm quite new to SAS. With that said, I'm trying to convert a character date in the format of "Q12018" to SAS date. Preferably in the same format or similar format. Any help would be appreciated!

Re: Char Date to SAS Date

Reeza — Thu, 19 Jul 2018 23:09:49 GMT

SAS dates have a month day component attached. What would you want 2018 Q1 mapped to?

You can still display it in a similar format.

data demo;
*numeric date;
date='01Jan2018'd;
*character date;
date_char = 'Q12018';

*conversion;
date_num = mdy(input(substr(date_char, 2, 1), 8.)*3, 
            1, 
            input(substr(date_char, 3), 8.)
            );

*apply formats for display;
format date date_num yyq6.;
run;

proc print data=demo;run;

@aakash93 wrote:

Hi I'm quite new to SAS. With that said, I'm trying to convert a character date in the format of "Q12018" to SAS date. Preferably in the same format or similar format. Any help would be appreciated!

Re: Char Date to SAS Date

ballardw — Thu, 19 Jul 2018 23:32:49 GMT

One approach:

data example;
   char='Q12018';
   datenum= input(strip(catt(substr(char,3),substr(char,1,2))),yyq7.);
   put datenum=date9. datenum=yyq.;
run;

The yyq informat assigns the first day of the calendar quarter as the actual date value.

Re: Char Date to SAS Date

aakash93 — Fri, 20 Jul 2018 14:41:46 GMT

It worked, I appreciate it!