topic Re: ERROR 22-322: Syntax error I am new to SAS. Would someone help me with this error? in SAS Programming

ERROR 22-322: Syntax error I am new to SAS. Would someone help me with this error?

jmanning29 — Sun, 20 Oct 2019 19:09:22 GMT

I am new to SAS. Would someone help me with this error?

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 proc print data=/** Import an XLSX file. **/

75 PROC IMPORT DATAFILE="/folders/myfolders/U2_A1FBStockPrice.xlsx"

______

ERROR 22-322: Syntax error, expecting one of the following: ;, (, BLANKLINE, CONTENTS, DATA, DOUBLE, GRANDTOTAL_LABEL,

GRANDTOT_LABEL, GRAND_LABEL, GTOTAL_LABEL, GTOT_LABEL, HEADING, LABEL, N, NOOBS, NOSUMLABEL, OBS, ROUND, ROWS, SPLIT,

STYLE, SUMLABEL, UNIFORM, WIDTH.

ERROR 76-322: Syntax error, statement will be ignored.

76 OUT=WORK.FB_StockPrice

77 DBMS=XLSX

78 REPLACE;

79 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

81 /** Print the results. **/

83 PROC PRINT DATA=WORK.B_StockPrice; RUN;

ERROR: File WORK.B_STOCKPRICE.DATA does not exist.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

85 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: ERROR 22-322: Syntax error I am new to SAS. Would someone help me with this error?

SASKiwi — Sun, 20 Oct 2019 19:20:13 GMT

This is the cause of your problem. You've partly commented a line and what is left isn't a valid SAS statement.

proc print data=/** Import an XLSX file. **/

Either remove the line entirely or change it so the whole line is a comment:

/** proc print data= Import an XLSX file. **/

Re: ERROR 22-322: Syntax error I am new to SAS. Would someone help me with this error?

jmanning29 — Sun, 20 Oct 2019 19:28:20 GMT

Thank You Very Much!

Re: ERROR 22-322: Syntax error I am new to SAS. Would someone help me with this error?

ballardw — Mon, 21 Oct 2019 15:12:49 GMT

It helps to post log results or code into code box opened on the forum using the {I} icon to preserve formatting.

Such as:

14   proc print data=/** Import an XLSX file. **/
15
16   PROC IMPORT DATAFILE="/folders/myfolders/U2_A1FBStockPrice.xlsx"
          ------
          22
          76
ERROR 22-322: Syntax error, expecting one of the following: ;, (, BLANKLINE, CONTENTS, DATA,
              DOUBLE, GRANDTOTAL_LABEL, GRANDTOT_LABEL, GRAND_LABEL, GTOTAL_LABEL, GTOT_LABEL,
              HEADING, LABEL, N, NOOBS, NOSUMLABEL, OBS, ROUND, ROWS, SPLIT, STYLE, SUMLABEL,
              UNIFORM, WIDTH.
ERROR 76-322: Syntax error, statement will be ignored.
17      OUT=WORK.FB_StockPrice
18      DBMS=XLSX
19      REPLACE;
20   RUN;

Now it is possible to see that the diagnostics indicate the proximate error is the word IMPORT. Which is not an option for PROC PRINT which is what the "expected" elements are: Proc Print options. The code was attempting to Print the dataset Proc due to the reasons pointed out by @SASKiwi .