Hi all, I'm testing the following: %let var0="dog"n? "cat"n?;
%let var=%scan(&var0,1,?,m);
%put &var;
%let var2=%qtrim(%qscan(&var,1,%str(%")));
%put &var2;
%let j=1;
data test ;
length landing_page_url $300.;
input id landing_page_url $;
datalines;
10 cccc
5 dd
;
run;
proc freq data=test noprint;
tables landing_page_url / out=_&var2.&j (drop=count) missing;
run; I'm getting a no real explicative error in the proc freq output: 83 proc freq data=test noprint;
84 tables landing_page_url / out=_&var2.&j (drop=count) missing;
SYMBOLGEN: Macro variable VAR2 resolves to dog
SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
SYMBOLGEN: Macro variable J resolves to 1
NOTE: Line generated by the macro variable "J".
84 _dog1
---
22
---
76
ERROR 22-322: Syntax error, expecting one of the following: ;, (, AGREE, ALL, ALPHA, BDT, BIN, BINOMIAL, CELLCHI2, CHISQ, CL, CMH,
CMH1, CMH2, COMMONRISKDIFF, COMONMRDIFF, CONTENTS, CONVERGE, CROSSLIST, CUMCOL, DEVIATION, EXACT, EXPECTED, FISHER,
FORMAT, GAILSIMON, GS, JT, KAPPA, LINE, LIST, MAXITER, MAXLEVELS, MEASURES, MISSING, MISSPRINT, NOCOL, NOCUM, NOFREQ,
NOPERCENT, NOPRINT, NOROW, NOSPARSE, NOWARN, ODDSRATIO, OR, OUT, OUTCUM, OUTEXPECT, OUTPCT, PEARSONRES, PEARSONRESID,
PLCORR, PLOTS, PRINTKWTS, PRINTWTS, RELRISK, RISKDIFF, SCORE, SCORES, SCOROUT, SENSPEC, SPARSE, STDRES, STDRESID,
TABLE, TESTF, TESTP, TOTPCT, TREND, WARN.
ERROR 76-322: Syntax error, statement will be ignored. No idea why is not accepting the table name starting with underscore, as according to SAS documentation it should work Any tips to share?
... View more