Tom, No luck this is my code:   %macro test(DSN):   proc sql; create connection to ORACLE ,,,,,,,    create table employee_&DSN. as      select * from .&DSN. a    left join employee e    on a.id = e.id;  run; %mend test; %test(FILE1,FILE2) quit;   getting errors:   more positional parameters found than defined   please advise and let me know the issue. Thank     ... View more

Tom, I have a code like this: Proc sql; connect to database create table test.&outputfile. as select * from work.&file1. a Left join oracletable b On a.id =b.id I need to run same sql with File1,,,File10 and create 10 output datasets for each file I will be running this code 100 times with multiple databases That’s why I need to use macro Hope you understand the logic now ... View more

No resolution for my problem All I need one sql read two files one at a time and create output and reruns sql with file2 and create 2nd output. All I need macro to run the logic ... View more

Tom thanks for your response. Just need to run my code using %macro with two data sets like in the loop ... View more

Thanks Tom. This is not what I want all I want one proc sql execute first with  file1 and then file2 and create two separate output for file 1 and file 2 is kind of loop using macro in one sql     ... View more

I want to create separate datasets each file ... View more

sql is very simple: :   create table out.file1; select * from file1; run;   create table out.file2 select * from file2; run;   how I write a %macro for file 1 and file 2 as well out.file 1 and out.file2? %MACRO FILE (FILE1, FILE2); %MEND (FILE1,FILE2)   ... View more

I'm using SAS® OnDemand for Academics ... View more

this is the code and error. I'm trying to export in xlsx.     proc export data=work.import DBMS=xlsx    outfile="/folders/myfolders/thesis.xlsx"; run;   ERROR: Temporary file for XLSX file can not be created -> /folders/myfolders//thesis.$$1. Make sure the path name is correct and that you have write permission.   sx ... View more

this is my export code still getting errors: proc export data=work.import DBMS=xlsx outfile= "/Program Files/SASUniversityEdition/myfolders/wf.xlsx"; run;   error; 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 70 71 proc export data=work.import DBMS=xlsx 72 73 outfile= "/Program Files/SASUniversityEdition/myfolders/wf.xlsx"; 74 75 run;   ERROR: Temporary file for XLSX file can not be created -> /Program Files/SASUniversityEdition/myfolders//wf.$$1. Make sure the path name is correct and that you have write permission.   ... View more

right click on the data set and export but I don't see any code for export ... View more

no luck ... View more