Wednesday, January 04, 2006

st: RE: Reading a tab-delimited text file; version 8.2

Joe McCrary writes: > I've got a number of tab-delimited text files that I'm reading into > STATA 8.2 using insheet. The problem I'm having is that the first 3 > variables need to be read is as text, not numeric. Here is one line of > data: > > 86309 0060 010051000229 0 84 69 66 > 48 69 75 84 78 87 81 75 > 63 69 > > In looking over the infile/dictionary commands, it appears that I > cannot specify a delimeter in the dictionary file. > > Could someone please tell me how to read those first 3 in as strings?

You can use a dictionary with tab delimiters... For example, create: dictionary using test.raw { str5 v1 str4 v2 str12 v3 int v4 int v5 int v6 int v7 int v8 int v9 int v10 int v11 int v12 int v13 int v14 int v15 int v16 int v17 }

and save as test.dct. Then:

. infile using test.dct

dictionary using test.raw { str5 v1 str4 v2 str12 v3 int v4 int v5 int v6 int v7 int v8 int v9 int v10 int v11 int v12 int v13 int v14 int v15 int v16 int v17 }

(3 observations read)

. list

+-----------------------------------------------------------------------------------------------------------+ | v1 v2 v3 v4 v5 v6 v7 v8 v9 v10 v11 v12 v13 v14 v15 v16 v17 | |-----------------------------------------------------------------------------------------------------------| 1. | 86309 0060 010051000229 0 84 69 66 48 69 75 84 78 87 81 75 63 69 | 2. | 86309 0060 010051000229 0 84 69 66 48 69 75 84 78 87 81 75 63 69 | 3. | 86309 0060 010051000229 0 84 69 66 48 69 75 84 78 87 81 75 63 69 | +-----------------------------------------------------------------------------------------------------------+

----------------------------------------- CONFIDENTIALITY NOTE: This e-mail message, including any attachment(s), contains information that may be confidential, protected by the attorney-client or other legal privileges, and/or proprietary non- public information. If you are not an intended recipient of this message or an authorized assistant to an intended recipient, please notify the sender by replying to this message and then delete it from your system. Use, dissemination, distribution, or reproduction of this message and/or any of its attachments (if any) by unintended recipients is not authorized and may be unlawful.

* * 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/


Tag:


Links to this post:

Create a Link



<< Home

This page is powered by Blogger. Isn't yours?