topic quarter dates to normal dates in SAS Programming

quarter dates to normal dates

amanjot_42 — Wed, 24 Jul 2019 11:17:22 GMT

Hi guys,

I am trying to convert quarters to date, like 2007Q1 (I am having as this in my dataset) to 31/03/2007.

Can you please help me with the program?

Cheers

Amanjot

Re: quarter dates to normal dates

Patrick — Wed, 24 Jul 2019 11:27:57 GMT

@amanjot_42 wrote:

Hi guys,

I am trying to convert quarters to date, like 2007Q1 (I am having as this in my dataset) to 31/03/2007.

Can you please help me with the program?

Cheers

Amanjot

Is the variable holding 2007Q1 of type character or numeric?

Re: quarter dates to normal dates

amanjot_42 — Wed, 24 Jul 2019 11:29:43 GMT

Hi, thanks for replying,
Its character!

Re: quarter dates to normal dates

Patrick — Wed, 24 Jul 2019 11:44:29 GMT

Below should work.

data test;
  format sas_date_value ddmmyy10.;
  quarter_string='2007Q1';
  sas_date_value=intnx('quarter',input(quarter_string,yyq6.),0,'e');
  output;
  stop;
run;
proc print data=test;
run;

Re: quarter dates to normal dates

amanjot_42 — Wed, 24 Jul 2019 11:53:49 GMT

Thanks,

But I have noticed that I need this conversion for full one column named 'dataquater' with values like 2007Q1 2007Q2 and so on.

Is this code works for full column?

Re: quarter dates to normal dates

Kurt_Bremser — Wed, 24 Jul 2019 11:58:52 GMT

@amanjot_42 wrote:

Thanks,

But I have noticed that I need this conversion for full one column named 'dataquater' with values like 2007Q1 2007Q2 and so on.

Is this code works for full column?

Of course it will work. A data step iterates through all observations in the dataset used in the set statement.

@Patrick just had to make up usable data artificially because you did not provide an example dataset; otherwise his data step would have taken your dataset as input.

Re: quarter dates to normal dates

amanjot_42 — Wed, 24 Jul 2019 12:15:58 GMT

Here is the code:

data want;
set have;
format sas_date_value ddmmyy10.;
quarter_string='2007Q1';
sas_date_value=intnx('quarter',input(quarter_string,yyq6.),0,'e');
output;
stop;
run;

But this shows result for only one observation at the end. Even I tried this with column name: quarter_string=dataquarter

Same results showing for one observation only!

Re: quarter dates to normal dates

Kurt_Bremser — Wed, 24 Jul 2019 12:20:52 GMT

Remove the unnecessary statements, and use your variable from the dataset:

data want;
set have;
format sas_date_value ddmmyy10.;
sas_date_value=intnx('quarter',input(dataquater,yyq6.),0,'e');
run;

Read the documentation for the meaning of the output and stop statements.

Re: quarter dates to normal dates

amanjot_42 — Wed, 24 Jul 2019 12:47:51 GMT

thanks!

It worked well.

Re: quarter dates to normal dates

Kurt_Bremser — Wed, 24 Jul 2019 13:04:36 GMT

Please mark @Patrick's post as the solution, I only adapted it to your data.