Why am I getting SAS ERROR 22-322 syntax error

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65872840/why-am-i-getting-sas-error-22-322-syntax-error

Answer 1

Your updated information shows that you have observations in your input dataset Testwyf.Varlst with empty values of LIBNAME and MEMBER. Also having a period in the value of MEMBER is probably indication that it is either a numeric variable (or does not even exist in that dataset) or was generated from a numeric variable that had a missing value. So fix your input dataset.

Sometimes the macro processor interferes with SAS's ability to parse your code into tokens for evaluation and a single token that it being built with macro code is seen as two tokens instead of one. One simple solution is to build the token into another macro variable and then use that macro variable to generate the code.

In your case make macro variables to hold the full dataset names and then use those to generate the SAS code.

%let indsn = &inLibref..&inMember.;
%let outdsn = &outLibref..&inMember.;
data &outdsn.(drop=TradingTime);
  set &indsn.(keep=Symbol ShortName TradingTime LastPrice OpenPrice);

Also protect yourself from non-standard member names.

call symputx("inMember",nliteral(memname));