topic Re: SAS - create new variable with year quarter in format YYYYQQ from YYYY-MM-DD in New SAS User

SAS - create new variable with year quarter in format YYYYQQ from YYYY-MM-DD

adrfinance — Thu, 27 Feb 2020 10:06:23 GMT

Hello,

I have a dataset that has date entried in the following form:

2017-06-30

and I would like to generate a new variable that has the year and the quarter in the following format:

YYYYQQ

i.e. the above entries would be:

2017Q2

How can I do that?

Re: SAS - create new variable with year quarter in format YYYYQQ from YYYY-MM-DD

ed_sas_member — Thu, 27 Feb 2020 10:12:07 GMT

Hi @adrfinance

You can try the YYQ format:

data have;
	input date:YYMMDD10.;
	format date YYQ.;
	datalines;
2017-06-30
;
run;

Re: SAS - create new variable with year quarter in format YYYYQQ from YYYY-MM-DD

ed_sas_member — Thu, 27 Feb 2020 10:13:59 GMT

If the initial variable is a character variable and not a SAS date, you can use the input() function:

data have;
	input date $10.;	
	format date_q YYQ.;
	date_q = input(date, YYMMDD10.);
	datalines;
2017-06-30
;
run;

Re: SAS - create new variable with year quarter in format YYYYQQ from YYYY-MM-DD

adrfinance — Thu, 27 Feb 2020 10:24:52 GMT

Can you please take the values from a variable instead of using inline?

Re: SAS - create new variable with year quarter in format YYYYQQ from YYYY-MM-DD

Kurt_Bremser — Thu, 27 Feb 2020 12:46:40 GMT

@adrfinance wrote:

Can you please take the values from a variable instead of using inline?

Datalines and input CREATE A VARIABLE, so your question is nonsense.

If you want to read existing values from a dataset, use the set statement, and the variables from the incoming dataset.

PS if you want code that is applicable to your data, it is necessary to supply that data, in a data step with datalines (see the gazillion examples her on the communities).

Use the "little running man" to post your code.