topic Re: Trying to create a new variable in SAS Enterprise Guide

Trying to create a new variable

anonymous_user — Wed, 24 Nov 2021 19:05:28 GMT

Pulling only EM codes and trying to create a column to flag EM codes:

data EMpull;
set OUTPAT;
if cpt between '99201' and '99215' or between
'99241' and '99245'
or '99381' and '99397' or
'99354' and '99355'
or '99401' and '99412' then EMflag="EM";
run;

Re: Trying to create a new variable

PaigeMiller — Wed, 24 Nov 2021 19:26:16 GMT

What is your question?

Re: Trying to create a new variable

anonymous_user — Wed, 24 Nov 2021 19:52:27 GMT

I figured it out. Was just trying to pull in all EM code data.

Now I'm trying to split them into two quarters - 1/1/2021 - 3/31/2021 = Q1 and 4/1/2021 - 6/30/2021 i= Q2. Where would I do that in this data set?

data EMpull;
set OUTPAT;
where ( '99201' <= cpt <= '99215')
or (cpt between '99241' and '99245')
or (cpt between '99381' and '99397')
or (cpt between '99354' and '99355')
or (cpt between '99401' and '99412');
run;

Thank you,

Re: Trying to create a new variable

Reeza — Wed, 24 Nov 2021 20:03:51 GMT

data EMpull;
set OUTPAT;
where ( '99201' <= cpt <= '99215')
or (cpt between '99241' and '99245')
or (cpt between '99381' and '99397')
or (cpt between '99354' and '99355')
or (cpt between '99401' and '99412');

Quarter = put(date, yyq6.);
QuarterNumber = QTR(date);

run;

Re: Trying to create a new variable

anonymous_user — Wed, 24 Nov 2021 21:18:07 GMT

I'm trying to create a a Q! and Q2 date range. How do i create that first?

Q1 = 1/1/2021 thru 3/31/2021 and Q2 = 4/1/2021-6/30/2021

Re: Trying to create a new variable

Reeza — Wed, 24 Nov 2021 22:21:41 GMT

What does that mean in terms of a data set? My assumption was you had a date variable that you want to categorize rows as Q1/Q2.

Re: Trying to create a new variable

anonymous_user — Wed, 24 Nov 2021 22:28:04 GMT

Yes I have two date ranges to split into quarters - Q1 and Q2.

This is what I have:

if ('01Jan2021' <= eventDate <= '31Mar2021') THEN Q1;
else if ('01Apr2021' <= eventDate <= '30Jun2021') THEN Q2;

RUN;

Re: Trying to create a new variable

anonymous_user — Wed, 24 Nov 2021 22:29:26 GMT

Yes I have two date ranges to split into quarters - Q1 and Q2.

This is what I have:

if ('01Jan2021' <= eventDate <= '31Mar2021') THEN Q1;
else if ('01Apr2021' <= eventDate <= '30Jun2021') THEN Q2;

RUN;

Re: Trying to create a new variable

anonymous_user — Wed, 24 Nov 2021 22:30:26 GMT

I just want a column called "QTR" then in that column for each date range should say either Q1 or Q2

Re: Trying to create a new variable

Reeza — Wed, 24 Nov 2021 22:56:18 GMT

Did you try the code I posted? What did you get?

Re: Trying to create a new variable

anonymous_user — Wed, 24 Nov 2021 23:10:03 GMT

it gives me this error:

Quarter=2021-05 QuarterNumber=. _ERROR_=1 _N_=1

It's not showing the Q1 or Q2 or anything in the data for that column

Re: Trying to create a new variable

Reeza — Wed, 24 Nov 2021 23:16:55 GMT

data EMpull;
set OUTPAT;
where ( '99201' <= cpt <= '99215')
or (cpt between '99241' and '99245')
or (cpt between '99381' and '99397')
or (cpt between '99354' and '99355')
or (cpt between '99401' and '99412');

 
*brute force method - not recommended;
if ('01Jan2021' <= eventDate <= '31Mar2021') THEN QTR="Q1";
else if ('01Apr2021' <= eventDate <= '30Jun2021') THEN QTR="Q2";

*better way;
QTR=catt('Q', qtr(eventDate));

RUN;

Fully tested example:

data stocks;
set sashelp.stocks;
where stock = 'IBM';
QTR=catt("Q", qtr(date));
YEAR_QTR = put(date, yyq6.);
keep date QTR YEAR_QTR;
run;

@anonymous_user wrote:

it gives me this error:

Quarter=2021-05 QuarterNumber=. _ERROR_=1 _N_=1

It's not showing the Q1 or Q2 or anything in the data for that column

Re: Trying to create a new variable

anonymous_user — Sat, 27 Nov 2021 01:18:40 GMT

Ok , how do you create the actual date range?

Like for Q1 = 1/1/2021-3/31/2021 and Q2 is 4/1/2021-6/30/2021.

I tried doing between operators and it doesn't work.

Sorry for my ignorance, I need this laid out in lay terms.

Re: Trying to create a new variable

anonymous_user — Sat, 27 Nov 2021 01:31:21 GMT

This is what I've done with the example you provided (the output isnt making sense):

QTR=catt('Q1', qtr('01Jan2021' <= eventDate <= '31Mar2021'));
/*catt('Q2', qtr('01Apr2021' <= eventDate <= '30Jun2021'));*/
YEAR_QTR = put(('01Jan2021' <= eventDate <= '31Mar2021'), yyq6.);
RUN;

Re: Trying to create a new variable

Tom — Sat, 27 Nov 2021 03:31:07 GMT

@anonymous_user wrote:

...

QTR=catt('Q1', qtr('01Jan2021' <= eventDate <= '31Mar2021'));

...

YEAR_QTR = put(('01Jan2021' <= eventDate <= '31Mar2021'), yyq6.);

...

The QTR() function operates on DATE values, but you passed it a BOOLEAN value (1=true 0=false) instead.

The YYQ. format operates on DATE values, but you also passed it a BOOLEAN value.

Since 0 and 1 are the first and second day of 1960 your code is equivalent to:

QTR='Q11';
YEAR_QTR = '1960Q1';

Why not try:

QTR=qtr(eventDate);
YEAR_QTR = put(eventDate,yyq6.);

Then if you want to limit the data to values in first two quarters of 2021 you could add:

if year_qtr in ('2021Q1' '2021Q2');

Re: Trying to create a new variable

anonymous_user — Sat, 27 Nov 2021 03:39:40 GMT

This is what I got:

21
22 GOPTIONS ACCESSIBLE;
23 data EMpull;
24 set OUTPAT;
25 where ( '99201' <= cpt <= '99215')
26 or (cpt between '99241' and '99245')
27 or (cpt between '99381' and '99397')
28 or (cpt between '99354' and '99355')
29 or (cpt between '99401' and '99412');
30
31 QTR=qtr(eventDate);
32 YEAR_QTR = put(eventDate,yyq6.);
_____
484
NOTE 484-185: Format $YYQ was not found or could not be loaded.

33 if year_qtr in ('2021Q1' '2021Q2');
34
35 /*QTR=catt("Q", qtr('01Jan2021' <= eventDate <= '31Mar2021'));
36
37 /*YEAR_QTR = put(('01Jan2021' <= eventDate <= '31Mar2021'), yyq6.);*/
38
39 RUN;

Re: Trying to create a new variable

anonymous_user — Sat, 27 Nov 2021 03:48:20 GMT

There are only two quarters in my data - Jan - jun - q1 and q2; there is no q3 or q4.

Re: Trying to create a new variable

anonymous_user — Sat, 27 Nov 2021 03:50:18 GMT

The YEAR-QTR column is giving me year month and thats after i changed the q6. to q7. - q6. only gave me 2021-0 and no month number wher as q7. gave me 2021-03 for March 2021.

Re: Trying to create a new variable

Tom — Sat, 27 Nov 2021 06:06:19 GMT

That is saying that you cannot use the YYQ format with a character variable. Your dates need to be actual DATE values to use date operations. SAS stores dates as the number of days since 1960.

So perhaps the first thing you need to do is convert eventDate into an actual DATE.

What types of strings does it contain? Find the right informat that will convert string in that style into date values and use the INPUT() function.