[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: converting xls files to ascii
From:       "Nessle-Buck, Wren" <WNBuck () ITR-INC ! COM>
Date:       1997-08-29 19:32:11
[Download RAW message or body]

If you have SAS/ACCESS I highly recommend using proc access to get xls
data.  It is much much faster and less error prone, and saves storage
space too, than creating an ascii text file and reading that in.

basic syntax:
proc access dbms=xls;
  create {libref}.{dataset name}.access;
  path={path to your file, in quotes, or variable name containing path};
   assign=yes;

   create {libref}.{dataset name}.view;
   select all;
   list all;

run;

You can subset in the creation of the access and view descriptors, there
are just lots of powerful tools to ease import and export foreign file
formats.

If you don't have SAS/ACCESS, you can save it as tab delimited text,
read it in and spend a while making sure you've got it right. ACCESS is
great!! (and it works on lotus worksheets, dbf files, most everything
I've run into except _Microsoft_ Access data bases.)

International Trade Resources

Wren Nessle Buck
Consultant

[prev in list] [next in list] [prev in thread] [next in thread]