topic Convert char Quarter_year into sas date in SAS Programming

Convert char Quarter_year into sas date

Ronein — Thu, 30 Jan 2025 06:29:36 GMT

Hello

What is the way to convert values (char values) as Q4-2024,Q3-2024,Q2-2024,Q1-2024,Q1-2025 to sas date?

Data have;
input Quarter_Year $;
cards;
Q4-2024
Q3-2024
Q2-2024
Q1-2024
Q1-2025
;
Run;

Re: Convert char Quarter_year into sas date

Amir — Thu, 30 Jan 2025 07:23:15 GMT

Hi,

You could try something like the following. It uses the YYQ function, which "returns a SAS date value that corresponds to the first day of the specified quarter."

data want;
  set have;

  format date2 date9.;
  
  date1 = yyq(input(scan(quarter_year,2),8.),input(char(quarter_year,2),8.));
  date2 = date1;
run;

Thanks & kind regards,

Amir.

Re: Convert char Quarter_year into sas date

Ksharp — Thu, 30 Jan 2025 08:21:49 GMT

Data have;
input Quarter_Year $;
cards;
Q4-2024
Q3-2024
Q2-2024
Q1-2024
Q1-2025
;
Run;

data want;
 set have;
 date=input(cats(scan(Quarter_Year,-1,'-'),scan(Quarter_Year,1,'-') ),yyq8.); 
 format date date9.;
run;