topic Re: Problem with inserting DATE from a MACRO variable (Part II) in SAS Programming

Problem with inserting DATE from a MACRO variable (Part II)

Emoji — Wed, 04 Jan 2023 01:01:32 GMT

Sorry for posting my question again but the previous post does not let me to reply to the comments:

Here is my code and error that I get:

Thanks for your help. Please see the entire code and log below:

Code:

%LET DAYS= %EVAL( %SYSFUNC(INTNX(QTR,'01JAN2022'D, (&LOOP-1), E))-%SYSFUNC(INTNX(QTR,'01JAN2022'D, (&LOOP-1), B)) + 1);
%LET QUARTER_DAY_START = %SYSFUNC(DEQUOTE(" '%SYSFUNC(INTNX(MONTH, '01JAN2022'D, (&LOOP-1)*3, B), DATE11.)' "));
%LET QUARTER_DAY_END = %SYSFUNC(DEQUOTE(" '%SYSFUNC(INTNX(MONTH, '01JAN2022'D, ((&LOOP-1)*3)+ 2, E), DATE11.)' "));
%LET QUARTER_START_DATE = %SYSFUNC(INTNX(QTR,'01JAN2022'D,0,B));
%LET QUARTER_END_DATE = %SYSFUNC(INTNX(QTR,'01JAN2022'D,0,E));
%PUT &=DAYS;
%PUT &=QUARTER_DAY_START;
%PUT &=QUARTER_DAY_END;

DATA MY_NEW_TABLE;
SET WORK.MY_OLD_TABLE;
date = intnx('qtr','01jan2022'd,qtr-1,'b') to intnx('qtr','01jan2022'd,qtr-1,'e');
RUN;

Log:

1 The SAS System 06:13 Tuesday, December 13, 2022

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program 3';
4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=SVG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 %macro HTML5AccessibleGraphSupported;
15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16 %mend;
17 FILENAME EGHTML TEMP;
18 ODS HTML5(ID=EGHTML) FILE=EGHTML
19 OPTIONS(BITMAP_MODE='INLINE')
20 %HTML5AccessibleGraphSupported
MPRINT(HTML5ACCESSIBLEGRAPHSUPPORTED): ACCESSIBLE_GRAPH
21 ENCODING='utf-8'
22 STYLE=HtmlBlue
23 NOGTITLE
24 NOGFOOTNOTE
25 GPATH=&sasworklocation
26 ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
27
28 %LET DAYS= %EVAL( %SYSFUNC(INTNX(QTR,'01JAN2022'D, (&LOOP-1), E))-%SYSFUNC(INTNX(QTR,'01JAN2022'D, (&LOOP-1), B)) + 1)
28 ! ;
29 %LET QUARTER_DAY_START = %SYSFUNC(DEQUOTE(" '%SYSFUNC(INTNX(MONTH, '01JAN2022'D, (&LOOP-1)*3, B), DATE11.)' "));
30 %LET QUARTER_DAY_END = %SYSFUNC(DEQUOTE(" '%SYSFUNC(INTNX(MONTH, '01JAN2022'D, ((&LOOP-1)*3)+ 2, E), DATE11.)' "));
31 %LET QUARTER_START_DATE = %SYSFUNC(INTNX(QTR,'01JAN2022'D,0,B));
32 %LET QUARTER_END_DATE = %SYSFUNC(INTNX(QTR,'01JAN2022'D,0,E));
33 %PUT &=DAYS;
DAYS=90
34 %PUT &=QUARTER_DAY_START;
QUARTER_DAY_START='01-JAN-2022'
35 %PUT &=QUARTER_DAY_END;
QUARTER_DAY_END='31-MAR-2022'
36
37
37 ! DATA MY_NEW_TABLE;
38 SET WORK.MY_OLD_TABLE ;
39 date = intnx('qtr','01jan2022'd,qtr-1,'b') to intnx('qtr','01jan2022'd,qtr-1,'e');
__
22
202
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT,
IN, LE, LT, MAX, MIN, NE, NG, NL, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.

ERROR 202-322: The option or parameter is not recognized and will be ignored.

40 RUN;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.MY_NEW_TABLE may be incomplete. When this step was stopped there were 0 observations and 5 variables.
2 The SAS System 06:13 Tuesday, December 13, 2022

NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

41
42 %LET _CLIENTTASKLABEL=;
43 %LET _CLIENTPROCESSFLOWNAME=;
44 %LET _CLIENTPROJECTPATH=;
45 %LET _CLIENTPROJECTPATHHOST=;
46 %LET _CLIENTPROJECTNAME=;
47 %LET _SASPROGRAMFILE=;
48 %LET _SASPROGRAMFILEHOST=;
49
50 ;*';*";*/;quit;run;
51 ODS _ALL_ CLOSE;
52
53
54 QUIT; RUN;
55

Re: Problem with inserting DATE from a MACRO variable (Part II)

russt_sas — Fri, 06 Jan 2023 20:13:17 GMT

What are you trying to do with this statement because the 'TO' is not valid here:

date = intnx('qtr','01jan2022'd,qtr-1,'b') to intnx('qtr','01jan2022'd,qtr-1,'e');

With separate assignment statements it works:
date1 = intnx('qtr','01jan2022'd,qtr-1,'b');
date2= intnx('qtr','01jan2022'd,qtr-1,'e');

Re: Problem with inserting DATE from a MACRO variable (Part II)

Reeza — Fri, 06 Jan 2023 20:30:02 GMT

%LET DAYS= %EVAL( %SYSFUNC(INTNX(QTR,'01JAN2022'D, (&LOOP-1), E))-%SYSFUNC(INTNX(QTR,'01JAN2022'D, (&LOOP-1), B)) + 1);
%LET QUARTER_DAY_START = %SYSFUNC(DEQUOTE(" '%SYSFUNC(INTNX(MONTH, '01JAN2022'D, (&LOOP-1)*3, B), DATE11.)' "));
%LET QUARTER_DAY_END = %SYSFUNC(DEQUOTE(" '%SYSFUNC(INTNX(MONTH, '01JAN2022'D, ((&LOOP-1)*3)+ 2, E), DATE11.)' "));
%LET QUARTER_START_DATE = %SYSFUNC(INTNX(QTR,'01JAN2022'D,0,B));
%LET QUARTER_END_DATE = %SYSFUNC(INTNX(QTR,'01JAN2022'D,0,E));
%PUT &=DAYS;
%PUT &=QUARTER_DAY_START;
%PUT &=QUARTER_DAY_END;

DATA MY_NEW_TABLE;
SET WORK.MY_OLD_TABLE;

do date = intnx('qtr','01jan2022'd,qtr-1,'b') to intnx('qtr','01jan2022'd,qtr-1,'e');
    output;
end;

RUN;

Re: Problem with inserting DATE from a MACRO variable (Part II)

russt_sas — Fri, 06 Jan 2023 20:39:52 GMT

Is this code giving you an error?

DATA MY_NEW_TABLE;
SET WORK.MY_OLD_TABLE;

do date = intnx('qtr','01jan2022'd,qtr-1,'b') to intnx('qtr','01jan2022'd,qtr-1,'e');
    output;
end;

RUN;

Re: Problem with inserting DATE from a MACRO variable (Part II)

PaigeMiller — Fri, 06 Jan 2023 21:13:58 GMT

You still haven't explained what you are trying to do, as several people requested in the last thread.

Please explain what you are trying to do. I get the feeling you are going about this in a very difficult way, when simpler code would work, but since I don't know what you are trying to do, I cannot help at this point in time.

Also, several people in the earlier thread have pointed out that this is not valid SAS syntax

date = intnx('qtr','01jan2022'd,qtr-1,'b') to intnx('qtr','01jan2022'd,qtr-1,'e');

and they also pointed out that you might want the statement to begin with a DO

do date = intnx('qtr','01jan2022'd,qtr-1,'b') to intnx('qtr','01jan2022'd,qtr-1,'e');

although maybe that's not what you want, and again if you explained what you are trying to do, we could be more definitive in our advice.

Its almost as if we are talking and you're not listening.

Re: Problem with inserting DATE from a MACRO variable (Part II)

mkeintz — Sat, 07 Jan 2023 04:55:07 GMT

I second @PaigeMiller 's request for an explanation of what you are trying to do. As it stands, I don't have any idea.

But the code presented has the earmarks of a hammer looking for a nail. You might be offered a simpler alternative if we had a clearer idea of the objective.