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

From Daniel Egan To Subject Re: st: How to read SAS data into Stata directly? Date Wed, 27 Oct 2004 22:27:13 -0400 Hi Dave, First, search the statalist archives 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.

One easy way to export data from Stata to SAS is using Stata's. Gear_ratio ->GEAR_RAT specify option rename to save.xpt file with suggested names. Stata DTA Files. DTA Files Essentials. Statement to save the formats catalog under a specified SAS library. Willow Nes Game Map there. When writing SAS data to a Stata file.

Mind Control Theatre Behind The Mirror. 2) Download -usesas- from SAS MASTER Dan Blanchette - see to get his uber-nifty package. Thus Spoke Dan: 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.

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 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: >* >* >* >* * For searches and help try: * * * • Follow-Ups: • • From: David Han • References: • • From: David Han • Prev by Date: • Next by Date: • Previous by thread: • Next by thread: • Index(es): • • © Copyright 1996–2017 StataCorp LLC .

File Format-Specific Reference for the IMPORT and EXPORT Procedures All versions of Stata under Microsoft Windows are supported. Stata files have a.dta file extension.

FILES Import of all Stata versions under Microsoft Windows and UNIX is supported. Export of Stata version 8 and later is supported. MISSING VALUES Stata supports missing values. SAS missing values are written as Stata missing values. VARIABLE NAMES When using importing, Stata variable names can be up to 32 characters in length. The first character in a variable name can be any lowercase letter (a-z) or uppercase letter (A-Z), or an underscore ( _ ). Subsequent characters can be any of these characters, plus numerals (0-9).

No other characters are permitted. Stata reserves these 19 words, which are not allowed to stand alone as variable names: _all long _N in _skip _weight _pred _cons float _b _n pi int using with _rc double if _coef If the program encounters any of these reserved words as variable names, it appends an underscore to the variable name to distinguish it from the reserved word. For example, _N becomes _N_. When exporting, variable names greater than 32 characters are truncated.

The first character in a variable name can be any lowercase letter (a-z) or uppercase letter (A-Z), or an underscore ( _ ). Subsequent characters can be any of these characters, plus numerals (0-9). No other characters are permitted. Invalid characters are converted to underscores ( _ ). VARIABLE LABELS Stata supports variable labels when using the IMPORT procedure. When exporting, if the variable name is not a valid Stata name and there is no label, the EXPORT procedure writes the variable name as the label.