Help using Base SAS procedures

SAS 9.2 Import Excel

Reply
N/A
Posts: 0

SAS 9.2 Import Excel

I just switched over to SAS 9.2, I didn't have any problems with this same code in SAS 9.1.3
I'm trying to import a few Excel files and I have no problem getting through the first file with multiple ranges, but then SAS just hangs when it gets to the second Excel file. Any suggestions or ideas to fix this? Here is a piece of the code I'm using:

%Macro Import_ref(xlsfile,sasfile);
proc import
out = ref.&sasfile.
datafile = "&xlsfile"
dbms = excel2000 replace;
range = &sasfile.;
getnames = YES;
mixed = YES;
run;
%mend;

%Import_ref(xls1_file,ref_Family);
%Import_ref(xls1_file,ref_MA_Line);
%Import_ref(xls2_file,ref_ZIPtoMSA);
Ask a Question
Discussion stats
  • 0 replies
  • 113 views
  • 0 likes
  • 1 in conversation