topic Converting character yyyy-q to numeric yyqd. in SAS Programming

Converting character yyyy-q to numeric yyqd.

soneil9 — Mon, 15 May 2017 20:44:43 GMT

Hey guys,

I have a pipe-delimited text file that I'm trying to import to a SAS table and the formatting is not going particularly well.

I have a column labeled "QRTR" which is essentially in this format: "2014-2". This value represents the 2nd quarter of 2014.

Is there a way for me to convert this charvar to a numeric with an INPUT statement, and then convert the numeric to its' correct format using yyqd.?

Thank you,

Sean

Re: Converting character yyyy-q to numeric yyqd.

Reeza — Mon, 15 May 2017 21:11:22 GMT

Read it in as character, replace - with Q and convert using ANYDTDTE informat.

data test;
informat date $8.;
input date $;
y = input(translate(date, "Q", "-"), anydtdte.);
format y yyqd.;
cards;
2012-3
2013-1
2014-2
2015-5
2016-1
;
run;

Re: Converting character yyyy-q to numeric yyqd.

ballardw — Mon, 15 May 2017 21:15:23 GMT

data example;
   x = "2014-2";
   date= input(translate(x,'Q','-'),yyq6.);
   format date yyq6.;
run;

The resulting date acutally is assumed to be the first day the calendar quarter. You can use date9. or other format to examine it if needed.

Re: Converting character yyyy-q to numeric yyqd.

soneil9 — Wed, 17 May 2017 15:34:44 GMT

Thank you both! I added in your code to my data step and it worked beautifully.

Re: Converting character yyyy-q to numeric yyqd.

mkeintz — Wed, 17 May 2017 21:27:20 GMT

Then mark a solution