Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: How to read SAS data into Stata directly?


From   David Han <zhaohui.han@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: How to read SAS data into Stata directly?
Date   Wed, 27 Oct 2004 21:42:59 -0500

Hi, Dan,

Thank you so much. It helps a lot.

Dave


On Wed, 27 Oct 2004 22:27:13 -0400, Daniel Egan <dp.egan@gmail.com> wrote:
> Hi Dave,
> First, search the statalist archives
> <http://www.stata.com/statalist/archive/> using these strings:
> SAS
> StatTransfer
> Blanchette
> and you should get a nice discussion that has run the past couple of days.
> 
> Among your options:
> 1) Export into CSV file from SAS, then insheet/infile into Stata.
> 2) Download -usesas- from SAS MASTER Dan Blanchette - see
> http://www.cpc.unc.edu/services/computer/presentations/sas_to_stata/
> to get his uber-nifty package.
> 
> Thus Spoke Dan:<quote>
> It uses a SAS macro I wrote called SAVASTATA that writes out your
> SAS data as a flat ASCII columnar file and then writes the Stata dictionary
> file to input that file.  You could read in the SAS data file in parts if you
> want using the _in_ option:
> 
> . usesas using "d:\project\MyBigHonkingFile.sas7bdat", in(1/1000000)
> 
> This would read only the first million obs.
> 
> The SAVASTATA macro figures out the minimum data type required to store your
> Stata variables so it will be as compressed as the -compress- command
> would make it. Unfortunately, it takes time for SAVASTATA to figure
> out what the minimum storage type would be for such a large dataset.
> 
> -usesas- also figures out how much memory would be required for Stata
> to load the dataset if the memory setting is lower than needed.
> <end quote>
> 
> That package makes the load of transfering  between SAS and Stata
> unbearably light. I don't have any advice if you don't have SAS on
> your machine.
> 
> Good luck,
> 
> Dan
> 
> On Wed, 27 Oct 2004 20:51:46 -0500, David Han <zhaohui.han@gmail.com> wrote:
> > Hi, all,
> > Does anyone know whether there is some command to read SAS data into
> > Stata directly without bothering to use file format conversion
> > program, such as Stat/Transfer or DBMS/Copy?
> >
> > Thanks
> >
> > Dave
> > *
> > *   For searches and help try:
> > *   http://www.stata.com/support/faqs/res/findit.html
> > *   http://www.stata.com/support/statalist/faq
> > *   http://www.ats.ucla.edu/stat/stata/
> >
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index