Macro turn to weird error

[hhchenfx]

Hello Everyone,

I run a simple macro to import and sql to main file.

To my surprise, Studio give a weird notice and I cant understand why it is like that.

Yes, I replace the &text_to_sub with B to check and it works.

To make matter worse, after that, no code run, I got to logout and log back in to get SAS run code.

Below is my code and the notice I got.

Please help.

HHCFX

%macro my3macro (text_to_sub=);

proc import datafile="/..../Week6_HW1.xlsx"
out= &text_to_sub
dbms=xlsx
replace;
sheet="&text_to_sub";
run;

data &text_to_sub; set &text_to_sub;
rename value= &text_to_sub;
run;

proc sql;
    create table unit_all
    as select *
    from unit_all as a left join &text_to_sub as b
    on a.day=b.day;quit;

%mend;

%macro my3macro (text_to_sub=B);

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

2 TITLE;

3 FOOTNOTE;

4 OPTIONS LOCALE=en_US DFLANG=LOCALE;

NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks.

5 DATA _NULL_;

6 RUN;

7 OPTIONS VALIDVARNAME=ANY;

8 OPTIONS VALIDMEMNAME=COMPAT;

9 FILENAME _HTMLOUT TEMP;

10 FILENAME _PDFOUT TEMP;

11 FILENAME _GSFNAME TEMP;

12 FILENAME _DATAOUT TEMP;

13 %LET SYSCC=0;

14 %LET _CLIENTAPP='SAS Studio';

15 %LET _CLIENTAPPABREV=Studio;

16 %LET _CLIENTAPPVERSION=3.7;

17 %LET _CLIENTVERSION=3.7;

18 %LET _CLIENTMODE=wip;

19 %LET _SASSERVERNAME=%BQUOTE(SASApp);

20 %LET _SASHOSTNAME=%BQUOTE(odaws03-prod-us);

21 %LET _SASPROGRAMFILEHOST=%BQUOTE(odaws03-prod-us);

22 %LET _CLIENTUSERID=%BQUOTE(hnguyen6);

23 %LET _CLIENTUSERNAME=%BQUOTE(hnguyen6);

24 %LET CLIENTMACHINE=%BQUOTE(198.202.4.116);

25 %LET _CLIENTMACHINE=%BQUOTE(198.202.4.116);

26 %let SASWORKLOCATION="%sysfunc(getoption(work))/";

27 FILENAME _CWD '.';

28 DATA _NULL_;

29 CALL SYMPUT('_SASWORKINGDIR',PATHNAME('_CWD'));

30 RUN;

31 FILENAME _CWD;

32

33 %LET _SASPROGRAMFILE = %NRQUOTE(%NRSTR());

34 %LET _BASEURL = %BQUOTE(https://odamid.oda.sas.com/SASStudio/);

35 %LET _EXECENV=SASStudio;

36 DATA _NULL_;

37 CALL SYMPUT("GRAPHINIT","");

38 CALL SYMPUT("GRAPHTERM","");

39 RC=TSLVL('SASXGOPT','N');

40 _ERROR_=0;

41 IF (RC^=' ') THEN DO;

42 CALL SYMPUT("GRAPHINIT","GOPTIONS RESET=ALL GSFNAME=_GSFNAME;");

43 CALL SYMPUT("GRAPHTERM","GOPTIONS NOACCESSIBLE;");

44 END;

45 RUN;

46 DATA _NULL_;

47 RC=SYSPROD("PRODNUM002");

48 IF (RC^=1) THEN DO;

49 CALL SYMPUT("GRAPHINIT","");

50 CALL SYMPUT("GRAPHTERM","");

51 END;

52 RUN;

53 %LET _DATAOUT_MIME_TYPE=;

54 %LET _DATAOUT_NAME=;

55 %LET _DATAOUT_TABLE=;

56 %LET _DATAOUT_URL=;

57 %SYMDEL _DATAOUT_MIME_TYPE _DATAOUT_NAME _DATAOUT_URL _DATAOUT_TABLE;

58 %LET _SASWS_ = %BQUOTE(/home/hnguyen6);

59 %LET _SASWSTEMP_=%BQUOTE(/home/hnguyen6/.sasstudio/.images/94e978bb-701a-4b5a-9394-24c866cc608b);

60 ODS LISTING CLOSE;

61 ODS AUTONAVIGATE OFF;

62 ODS GRAPHICS ON;

63 ODS HTML5 (ID=WEB) DEVICE=PNG GPATH="&_SASWSTEMP_" ENCODING=utf8 FILE=_HTMLOUT (TITLE='Results: Program 2')

63 ! STYLE=Htmlblue OPTIONS(BITMAP_MODE='INLINE' OUTLINE='ON' SVG_MODE='INLINE'

63 ! CSS_PREFIX='.ods_94e978bb-701a-4b5a-9394-24c866cc608b' BODY_ID='div_94e978bb-701a-4b5a-9394-24c866cc608b' );

64 ODS PDF (ID=WEB) STYLE=Pearl FILE=_PDFOUT;

65 &GRAPHINIT;

66 OPTIONS FIRSTOBS=1;

67 OPTIONS OBS=MAX;

68 OPTIONS DTRESET DATE NUMBER NOTES;

69 OPTIONS NOTES STIMER SOURCE NOSYNTAXCHECK;

70

71 proc import datafile="/home/hnguyen6/my_content/FIN_ACCT_ANALYTICS/Homework/Week6_HW1.xlsx"

72 out= Unit

73 dbms=xlsx

74 replace;

75 sheet="A";

76 run;

77

78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

79 ODS HTML CLOSE;

80 &GRAPHTERM; ;*';*";*/;RUN;QUIT;

81 QUIT;RUN;

82 ODS HTML5 (ID=WEB) CLOSE;

83

84 ODS PDF (ID=WEB) CLOSE;

85 FILENAME _GSFNAME;

86 DATA _NULL_;

87 RUN;

88 OPTIONS VALIDMEMNAME=COMPAT;

89 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;

90

[SASKiwi · Accepted solution]

%macro my3macro (text_to_sub=);

proc import datafile="/..../Week6_HW1.xlsx"
out= &text_to_sub
dbms=xlsx
replace;
sheet="&text_to_sub";
run;

data &text_to_sub; set &text_to_sub;
rename value= &text_to_sub;
run;

proc sql;
    create table unit_all
    as select *
    from unit_all as a left join &text_to_sub as b
    on a.day=b.day;quit;

%mend my3macro;

%my3macro (text_to_sub=B);

[hhchenfx]

Yes, I also just figure it out.

[SASKiwi]

So it works correctly now? If so please mark as answered.

[Ksharp]

That is not an error.

Just add an option to suppress it.

option noquotelenmax;