I'm having a brain freeze trying to imagine how a dataset name is used with a FORMAT= option (possibly a PROC TABULATE statement?? but then I would expect the format to be a numeric format, not a character format):
Which resolves to:
This is taken from a Proc SQL statement I've had to change names etc due to the nature of the data. What you say it should resolve to is correct but it doesn't. This line is followed by about 20 more bringing in various variables and formatting them. I get the same error for everyone.
Suggest you explain your SAS log diagnostics perspective by adding the following line:
OPTIONS SOURCE SOURCE2 MACROGEN SYMBOLGEN MPRINT;
Then don't always focus on the exact line that's raising the error condition - but also be cognizant of any comments and incorrectly (syntax) structured SAS code just prior to the error point.
Yours is typical - though without seeing the code just before the PROC SQL statement, it's a guess. Check for a SAS comment that is not terminated correctly, with a trailing asterisk. If that's not it, add the OPTIONS and rerun. Then if you can't figure it out, paste the more complete SAS Log, and include the SAS-generate logic that occurs just before the error message.
OK so here's the actual log. The first part is pretty usual EG generated code.
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL=%NRBQUOTE(Lib and intial Code);
4 %LET _EGTASKLABEL=%NRBQUOTE(Lib and intial Code);
5 %LET _CLIENTPROJECTNAME=%NRBQUOTE(\\Dfz70162\199682030\workgroup\DMS99\42633-Auto Check PC New Claims\Live
5 ! SAS\Development Folder\AutoCheck_NEWACC_LiveV3Chop.egp);
6 %LET _SASPROGRAMFILE=;
7 %LET DLAC_DATE = %STR(090222);
8 %LET ICAC_DATE = %STR(090305);
9 %LET IICSC_DATE = %STR(090305);
10 %LET PCC_DATE = %STR(090313);
11 %LET PCC_MINUS1_DATE = %STR(090306);
12 %LET PCNC_DATE = %STR(090313);
13 %LET PSCSC_DATE = %STR(090305);
15 ODS _ALL_ CLOSE;
NOTE: Some of your options or statements may not be supported with the Activex or Java series of devices. Graph defaults for these
drivers may be different from other SAS/GRAPH device drivers. For further information, please contact Technical Support.
16 OPTIONS DEV=ACTIVEX;
17 FILENAME EGHTML TEMP;
NOTE: Writing HTML(EGHTML) Body file: EGHTML
18 ODS HTML(ID=EGHTML) FILE=EGHTML ENCODING='utf-8' STYLE=EGDefault
18 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/Enterprise%20Guide%204/BIClientStyles/EGDefault.css")
18 ! ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/graph/v91/sasgraph.exe") NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation
18 ! ;
64 CREATE TABLE WORK.PMC_CUSTOMERS_NEW_ACC AS SELECT PRIMARYDATA_NAMES_&PCC_DATE..IDNO FORMAT=$8.,
I ran with the option and got the following
35 PROC SQL;
36 CREATE TABLE WORK.PMC_CUSTOMERS_NEW_CLAIMS AS SELECT PRIMARYDATA_NAMES_&PCC_DATE..IDNO FORMAT=$8.,
SYMBOLGEN: Macro variable PCC_DATE resolves to 090313
SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
36 CREATE TABLE WORK.PMC_CUSTOMERS_NEW_ACC AS SELECT PRIMARYDATA_NAMES_&PCC_DATE..IDNO FORMAT=$8.,
ERROR 202-322: The option or parameter is not recognized and will be ignored.
I have all the periods in the right places. The only thing I can put it down to at the moment is the way the macro variable is used by EG from the intial input form.
By coding in the macro value without the use of the parameter form everything works fine.
Cynthia, I ran your code and it works fine but if I change the 'macro' to an EG parameter and then input its value via the parameter input screen I then get the same error I am experiencing with my own code.
Message was edited by: Ted
Like Scott, I think it's possible that your error may be coming from some other location in your code. There are a few different ways to use a compound name to reference a particular column in a SELECT clause. The program below creates some test data and any of the methods work for me. I don't get any errors in the SAS log.