Thank you, I did try renaming the catalog, as suggested below, but a new error message kept saying that Catalog arguments are bad. proc fedsql libs=(mba); WHen I used libs= option, it seems to work. My new issue is that I am having difficulty resolving Macro variables in Prod FedSQl; proc fedsql libs=(mba mbadsa);
SELECT count(*) from mba.dsa.equifax_das_scr where mba_run_dtm > &equifax_data_date;
quit;
run; Above gives me following error: 37 proc fedsql libs=(mba mbadsa);
NOTE: WARNING: [DataDirect][ODBC lib] Application's WCHAR type must be UTF16, because odbc driver's unicode type is UTF16
NOTE: WARNING: [DataDirect][ODBC lib] Application's WCHAR type must be UTF16, because odbc driver's unicode type is UTF16
38 SELECT count(*) from mba.dsa.equifax_das_scr where mba_run_dtm > &equifax_data_date;
ERROR: Error occurred building the Execution Tree.
ERROR: Error occurred initiating Filter.
ERROR: General error
NOTE: PROC FEDSQL has set option NOEXEC and will continue to prepare statements.
39 quit; When I surround macro variable with double quotes, it resolves, but I don't need the double quotes to stay in the output... Also, sas thinks it is a column name... 37 proc fedsql libs=(mba mbadsa);
NOTE: WARNING: [DataDirect][ODBC lib] Application's WCHAR type must be UTF16, because odbc driver's unicode type is UTF16
NOTE: WARNING: [DataDirect][ODBC lib] Application's WCHAR type must be UTF16, because odbc driver's unicode type is UTF16
38 SELECT count(*) from mba.dsa.equifax_das_scr where mba_run_dtm > "&equifax_data_date";
ERROR: Column "'2018-05-11 19:51:09.744'" not found or cannot be accessed
NOTE: PROC FEDSQL has set option NOEXEC and will continue to prepare statements.
39 quit;
... View more