cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
apolace1
‎09-01-2015
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Odd macro error

by Calcite | Level 5 in SAS Programming
‎10-03-2011 11:53 AM
‎10-03-2011 11:53 AM
No, I get a SAS error similar to this: Requested Sheet Name not found on Excel -> C:\Users\g1axp03\Documents\My SAS Files\My SAS Files/2000_2010LifeSchDpt5.xls Requested Input File Is Invalid ERROR: Import unsuccessful.  See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time):       real time           8.31 seconds       cpu time            4.91 seconds SAS can't recognize the file, because the forward slash is not in the filename. I've tried some basic troubleshooting. Resetting SAS, changing the file location and changing the file name. ... View more

Odd macro error

by Calcite | Level 5 in SAS Programming
‎10-03-2011 11:20 AM
1 Like
‎10-03-2011 11:20 AM
1 Like
I'm running a fairly simple macro to import multiple sheets from an excel file into SAS. The problem is that in the DATA STEP the datafile ends up with a reverse slash, so that the DATAFiLE line reads: DATAFILE= "O:\PROJ_LIB\Insurance\Schedule D Part34/2007_2009 Life SchDpt3.xls" %MACRO LIFE1;      %DO i = 1 %to 6;     PROC IMPORT OUT=schd.LIFE_SchDpt4_2007_2009sheet&i.            DATAFILE= "O:\PROJ_LIB\Insurance\Schedule D Part34\2007_2009 Life SchDpt3.xls"             DBMS=XLS REPLACE;             sheet="Sheet&i.";             GETNAMES=YES; RUN;      %END;     %MEND;     %LIFE1; Does anyone have any idea why I keep getting a forward slash instead of the backslash that I put into my code? Thanks, Andy ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes from
View All
Quick links