I am getting error on below codes unable to call macro , could you please help to fix this errors Data work.params; input qdbs$5. strgs$50.; datalines; JAN21 Mar9QF Strategy Dec20 FRB Base Strategy ; run; %macro NVPstg_Loop; %do i = 1 %to &datiq; data _null_; set work.params; if _n_ = &i then do; call symputx ('q', qdbs); call symputx ('s', strgs); %put &q &s; end; run; %Run_Pricing(&q,&s); %end; %mend; proc print; %cnts; %NVPstg_Loop; getting Error message WARNING: Apparent symbolic reference DATIQ not resolved. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: (&datiq) ERROR: The %TO value of the %DO I loop is invalid.   ... View more

Hi  I would like to select macro value along with ODBC data set columns   proc sql; connect to odbc(DSN=&DSN user=&user password=&pwds); create table TABLEY as select * from connection to odbc ( select &y as dates,* from TABLE X ; ); RUN;   ... View more

proc sql; select count(*) into :cntr from NVPLocal.NVP_DOD_Catch ; %put &cntr; select distinct qrm_db,strategy,moddate into :Var1,:Var2,:Var3 from NVPLocal.NVP_DOD_Catch ; %put &Var1; %put &Var2; %put &Var3; run; proc sql outobs=10; connect to odbc (DSN=&DSN user=&user password=&pwds); create table temp as select * from connection to odbc ( select * from [FASTControl].[dbo].[ALM_NVPData] where qrm_db=&Var1 ); disconnect from odbc; getting error message ERROR: CLI describe error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'Jan21'. : [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. ... View more