I have attached the log. I dont have any single quotes in filename.   %let local_Filename = File1 File2 'File3 File4'n; %let Excel_table = Sheet1 Sheet2 'Third Sheet'n; %let SAS_DATASET = Data1 data2 data3; options SYMBOLGEN MPRINT; %macro file_process; %let word_cnt = %sysfunc(countW(&local_Filename)); %do i = 1 %to &word_cnt; %let file_name=%qscan(%bquote(&local_Filename),&i); %let dataset=%qscan(%bquote(&SAS_DATASET),&i); %let table=%qscan(%bquote(&Excel_table),&i); libname xlsFile XLSX "/user/&file_name only.xlsm"; PROC SQL; create table work.&dataset as (select * from xlsFile.'&table'n); run; %end; %mend file_process; %file_process; ... View more

Gvien below is the code. Multiple words parameter(highlighted) are not getting resolved it is passed differently.   1. Excel_table parameters reolves lik below which is throwing an error as well. ERROR: File XLSFILE.'&table'n.DATA does not exist.   2. File_name is also resolved incorrectly like this - /user/2016 July 'File3.xlsm   CODE:   %let local_Filename = File1 File2 'File3 File4'n %let Excel_table = Sheet1 Sheet2 'Third Sheet'n %let SAS_DATASET = Data1 data2 data3 %macro file_process; %let file_name=%qscan(%bquote(&local_Filename),&i); %let dataset=%qscan(%bquote(&SAS_DATASET),&i); %let table=%qscan(%bquote(&Excel_table),&i); libname xlsFile XLSX "/user/(&file_name only).xlsm"; PROC SQL; create table work.&dataset as (select * from xlsFile.'&table'n); run; %end; %mend file_process; ... View more

Issue is fixed now after concatenating the teradata table separately in a variable. ... View more

Thank you for your repsonse. I have libname but I missed it while sharing. Error is thrown in this line (dbcreate_table_opts='primary index(col1,col2)' fastload=yes sleep=1 tenacity=2 sessions=10);   Error message:   22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-7: Invalid option name DBCREATE_TABLE_OPTS. 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-7: Invalid option name FASTLOAD. 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-7: Invalid option name SLEEP. 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-7: Invalid option name TENACITY. 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-7: Invalid option name SESSIONS.         ... View more

Thank you for sharing the link. I am able proceed now expect the below logic. Variables are not getting replaced with respective values.i.e. &dataset and &dataset_tera while creating teradata table with SAS dataset Error message: data schema.Table1_&dataset ( dbcreate_table_opts='primary index(col1,col2)' ___________________ 22 ! fastload=yes sleep=1 tenacity=2 sessions=10 ); set WORK.&dataset_tera; run; ERROR 22-7: Invalid option name DBCREATE_TABLE_OPTS.   %let Filename1 = FILE1 FILE2; %let SAS_DATASET = DATA1 DATA2; %let Excel_table = TABLE1 TABLE2; %let SAS_DATASET_TERA = TERA1 TERA1; options validvarname=v7; %macro file_process_tera; %let word_cnt = %sysfunc(countW(&Filename1)); %do i = 1 %to &word_cnt; %let file_name=%qscan(%bquote(&Filename1),&i); %let dataset=%qscan(%bquote(&SAS_DATASET),&i); %let table=%qscan(%bquote(&Excel_table),&i); %let dataset_tera=%qscan(%bquote(&SAS_DATASET_TERA),&i); data Schema.TABLE1_&dataset ( dbcreate_table_opts='primary index(col1,col2)' fastload=yes sleep=1 tenacity=2 sessions=10 ); set WORK.&dataset_tera; run; %end; %mend file_process_tera; %file_process_tera;   ... View more