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: 
verleger
‎09-01-2015
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: reading .xls into SAS

by Calcite | Level 5 in SAS Procedures
‎02-16-2015 06:35 PM
‎02-16-2015 06:35 PM
Thanks Tom for your Input.  But unfortunately those methods do not work with SAS 9.3 version and also I have Office 2010 which I am not sure if it contributes to the failure as being compatible or not. I believe those method such as namerow or endnamerow will be only useful with earlier version of SAS. IF there was a way that I could  skip the first row and only read the second row as my column names and third row as start of data , then that will do it also for me. but for now SAS 9.3 refuses to accept my second row as column names and my data starting at third row.  Just trying to tell SAS that my first row is garbage ! do not read it. ... View more

reading .xls into SAS

by Calcite | Level 5 in SAS Procedures
‎02-16-2015 02:30 PM
‎02-16-2015 02:30 PM
Does anyone knows how to read the .XLS file using proc import method when the excel file has two headers and not one.  If the file contain only one header SAS 9.3 is perfectly able to read it, but unfortunately with two Headers it fails every time.  example: This works if the excel sheet has only one header, %macro inp(dat,dsn); proc import datafile="/project/myfiles/data/&dat"   out=&dsn   dbms=xls replace;   DATAROW=2;   getnames=yes; run; I tried everything(below) that I knew for two headers file,but SAS 9.3 can not read it. First failedTrial, %macro inp(dat,dsn); proc import datafile="/project/myfiles/data/&dat"   out=&dsn   dbms=xls replace;   DATAROW=3;   getnames=yes; run; Second failed Trial, %macro inp(dat,dsn); proc import datafile="/project/myfiles/data/&dat"   out=&dsn   dbms=xls replace;   startrow=2;   DATAROW=3;   getnames=yes; run; Second failed Trial, %macro inp(dat,dsn); proc import datafile="/project/myfiles/data/&dat"   out=&dsn   dbms=xls replace;   startrow=2;   DATAROW=3;   getnames=NO; run; if Anyone can share their experience with this , if had one, it will be definitely appreciated. Verleger ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links