In the below example, value of the macro variable etls_jobName resolves to   %let etls_jobName = %nrquote(IF_04_J_PRT_TRA_INSURANCE_RECORD_DELIVERY);   I've no clue why I got this error and am I doing something wrong while calling macro variable in proc SQL?   5001 +create table dis_entity_id as select distinct ENTITY_ID format=$ENTITY. from scan(&etls_jobName.,6,'_'); _ 76 ERROR 76-322: Syntax error, statement will be ignored. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. NOTE: The SAS System stopped processing this step because of Errors.       ... View more

I'm unable to copy the user defined Format of one SAS variable to the SQL table. In the below example, 'metadata_final' is a SAS dataset where it holds the formatted value for the variable STAT_CD. However when I tried copy the SAS table which has that formatted variable in SQL table it is not copying the formatted values instead it is copying the actual value.   Log is given below and even if I apply the Format Statement before creating the SQL table, it is not taking the Format. No WARNING or ERROR message in the log as well.   May I know how can I copy the formatted value in SQL table?   27 data SQLLIB.SQL_table; 28 Format STAT_CD $STAT_CD.; 29 set metadata_final; 30 run_id=sum(n,1); 31 output; 32 stop; 33 set SQLLIB.SQL_table nobs=n; 34 modify SQLLIB.SQL_table; 35 run; NOTE: There were 1 observations read from the data set WORK.METADATA_FINAL. NOTE: The data set SQLLIB..SQL_TABLE has been updated. There were 0 observations rewritten, 1 observations added and 0 observations deleted. ... View more