Hi i am trying to create multiple table from a dataset , so in the data statement i have mentioned all those table name (macro variable table_name) i have pasted the log file which is showing some syntax error , please help me to resolve the issue 23 GOPTIONS ACCESSIBLE;
SYMBOLGEN: Macro variable TABLE_NAME resolves to ATLANTA BRECKSVILLE CHICAGO CLEVELAND COLUMBUS DETROIT MIDDLEBRG_HTS MOUNT_VERNON
PHILA PHILADELPHIA SYLVANIA TOLEDO
24 data &table_name.;
25 set multiple_table;
26 do i=1 to &count.;
SYMBOLGEN: Macro variable COUNT resolves to 12
27 if ProviderCity = cat('"',scan(&var_names.,i,","),'"') then output scan(&output_name.,i,",");
SYMBOLGEN: Macro variable VAR_NAMES resolves to "ATLANTA,BRECKSVILLE,CHICAGO,CLEVELAND,COLUMBUS,DETROIT,MIDDLEBRG HTS,MOUNT
VERNON,PHILA,PHILADELPHIA,SYLVANIA,TOLEDO"
SYMBOLGEN: Macro variable OUTPUT_NAME resolves to
"ATLANTA,BRECKSVILLE,CHICAGO,CLEVELAND,COLUMBUS,DETROIT,MIDDLEBRG_HTS,MOUNT_VERNON,PHILA,PHILADELPHIA,SYLVANIA,TOLEDO"
27 if ProviderCity = cat('"',scan(&var_names.,i,","),'"') then output scan(&output_name.,i,",");
_
22
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, RC, _DATA_, _LAST_, _NULL_.
27 if ProviderCity = cat('"',scan(&var_names.,i,","),'"') then output scan(&output_name.,i,",");
_
76
ERROR 76-322: Syntax error, statement will be ignored.
28 end;
29 run;
... View more