st: RE: Household Budget Surveys

["David Radwin" <dradwin@mprinc.com>]

For #2, try Sergiy Radyakin's -usespss-, available from SSC.

. ssc describe usespss

For #3, try Ian Watson's excellent -tabout-, also available at SSC, to
create formatted tables as tab-separated text files that can be easily
opened in Excel and then pasted or otherwise transferred to Word. There is
a learning curve, but it will pay off if you have to produce a lot of
tables.

. ssc describe tabout

Be sure to download the helpful PDF documentation as well as the program.

A trick I use for importing tab-separated text is to name the file with an
.xls extension, like Table1.xls, so that I can double-click the file to
open it. Excel will still complain that the format does not match the
extension, but at least this saves the tedious multi-step task of
converting text to columns.

David

--
David Radwin
Research Associate
MPR Associates, Inc.
2150 Shattuck Ave., Suite 800
Berkeley, CA 94704
Phone: 510-849-4942
Fax: 510-849-0794

www.mprinc.com


> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
> statalist@hsphsun2.harvard.edu] On Behalf Of Kirama, Stephen L.
> Sent: Thursday, March 04, 2010 3:11 AM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: Household Budget Surveys
>
> 1) Is it possible to cross tab more than two variables in Stata?
> 2) I have data set in SPSS how can i directly transfer it to stata
without
> loosing description of the variables. I know with excel file you can
save
> it in tiff format and insheet it in stata. what about spss files?
> 3) What is the good format to save the log file in stata so that it can
be
> easily transfered to Ms word with the tables intact?
>
>
> Please preliminary questions but i would like assistance. thanks
>
> Stephen L. Kirama
> University Post Hill
> University of Dar es Salaam - DOE

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/