Hi Louiss, I have tried your method but it's showing error see the log: FILENAME website URL 'http://www.energystar.gov/index.cfm?fuseaction=find_a_product.showProductGroup&pgw_code=FRZ/Freezers Product List.xls'; 28 29 FILENAME COPY "I:\Newfolder\abc.xls"; 30 data _NULL_; 31 n=-1; 32 infile website recfm=s nbyte=n length=len; 33 file copy recfm=n; 34 input; 35 put _infile_ $varying32767. len; 36 run; NOTE: Unable to connect to host www.energystar.gov. Check validity of host name. ERROR: Hostname www.energystar.gov not found. NOTE: UNBUFFERED is the default with RECFM=N. NOTE: The file COPY is: Filename=I:\Newfolder\abc.xls, RECFM=N,LRECL=256,File Size (bytes)=0, Last Modified=15Mar2013:11:35:32, Create Time=15Mar2013:11:34:31 NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 4.56 seconds cpu time 0.11 seconds 37 38 filename copy clear; NOTE: Fileref COPY has been deassigned. 39 40 libname Excel "I:\Newfolder\abc.xls" ; ERROR: Connect: External table is not in the expected format. ERROR: Error in the LIBNAME statement. 41 42 Data WORK.PROCtoNDC; 43 * Because the worksheet name is 44 the SAS Dataset Name and it has a non standard format you need it in quotes.; 45 SET Excel."Freezers Product List"n; ERROR: Libname EXCEL is not assigned. 46 run; NOTE: Compression was disabled for data set WORK.PROCTONDC because compression overhead would increase the size of the data set. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.PROCTONDC may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.PROCTONDC was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds
... View more