Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down on April 23, and its replacement, **statalist.org** is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
Andrzej Niemierko <aniemierko@PARTNERS.ORG> |

To |
Stata <statalist@hsphsun2.harvard.edu> |

Subject |
Re: st: using infile dictionary |

Date |
Sun, 25 Jul 2010 13:27:48 -0400 |

Jon, Yes, it is easy to do what I want manually. The reason I wanted to "automate" it is that I have to repeat it for a few thousands of files. I guess I will try to do splitting my text files using PEARL. Thanks for your help. Andrzej On 7/24/10 4:29 PM, "Jon Gettman" <jgettman@hughes.net> wrote: > Andrzej, > > Jeph Herrin earlier wrote that "Sometimes the best solution isn't a > Stata solution; for this kind of problem I usually invoke some other > software." That might be a useful approach here. If I understand > you correctly you have 6 blocks of data in a vertical sequence and > you want them horizontal. Open the file in Excel. Block 1 is line > A1 through 123. Block 2 is line A124 through B247. Cut out block 2 > and paste it into C1:D123 . Do the same for blocks 3,4,5 and 6 into > columns E&F, G&H, I&J, and K&L respectively. If the text line is > unnecessary on Stata, delete row 1. Insert a blank row at the top, > enter some var names, save it as a text file, and import to Stata via > the insheet command. Sometimes brute force is easier than > elegance. It's often better to solve the problem in an elegant way > because you learn something that becomes useful later. But sometimes > utility is premium. > > Jon > > > > > At 10:06 AM 7/23/2010, you wrote: >> Thank you, Jon. This is helpful but not exactly what I need. In fact, after >> each line of text I have 122 pairs of numbers so it is _lines(123) >> structure, and the number of structures is six. However, the real issue is >> that those 122 pairs of numbers represent only two variables with 122 >> observations each. And this repeats six times. The final data structure >> should be 6x2=12 columns (variables) with 122 observations each. Any idea >> how can this be accomplished? >> Andrzej >> >> >> >> >> On 7/22/10 11:22 PM, "Jon Gettman" <jgettman@hughes.net> wrote: >> >>> The test data file I set up literally uses "one line of text" as the >>> string of text on the first,fifth, and ninth lines. It gets >>> truncated, and if the line of text is not needed in the dataset, this >>> might work. Look at Example 7 in the manual on page 294. Treat the >>> structure as a 4 line data entry. Then delete the first variable >>> when you get the data loaded into Stata. >>> >>> dictionary using "C:\DATA\test.txt" { >>> _lines(4) >>> _line(1) >>> str13 xxx "onelineoftext" >>> _line(2) >>> int a1 "a1" >>> int a2 "a2" >>> _line(3 >>> int b1 "b1" >>> int b2 "b2" >>> _line(4) >>> int c1 "c1" >>> int c2 "c2" >>> } >>> >>> .infile using "C:\Data\test.dct" >>> >>> xxx a1 a2 b1 b2 c1 c2 >>> one 2 4 3 5 5 6 >>> one 1 3 2 7 7 6 >>> one 4 6 2 1 3 5 >>> >>> I hope this helps. Does this get you what you want? >>> Jon >>> >>> >>> >>> >>> At 11:38 AM 7/22/2010, you wrote: >>>> I would appreciate help with -infile dictionary-. >>>> >>>> My data files have the following structure: >>>> >>>> One line of text >>>> 2 4 >>>> 3 5 >>>> 5 6 >>>> One line of text >>>> 1 3 >>>> 2 7 >>>> 7 6 >>>> One line of text >>>> 4 6 >>>> 2 1 >>>> 3 5 >>>> >>>> I want to read this file and create six numerical variables (three pairs) >>>> corresponding to the three sections of numbers below each line of text. >>>> Thank you. >>>> Andrzej >>>> >>>> >>>> >>>> >>>> >>>> The information in this e-mail is intended only for the person >> to whom it is >>>> addressed. If you believe this e-mail was sent to you in error >> and the e-mail >>>> contains patient information, please contact the Partners Compliance >>>> HelpLine at >>>> http://www.partners.org/complianceline . If the e-mail was sent to >>>> you in error >>>> but does not contain patient information, please contact the sender >>>> and properly >>>> dispose of the e-mail. >>>> >>>> * >>>> * 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/ >>> >>> >>> * >>> * 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/ >> >> * >> * 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/ > > > * > * 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/ * * 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/

**Follow-Ups**:**Re: st: using infile dictionary***From:*"Joseph Coveney" <jcoveney@bigplanet.com>

**References**:**Re: st: using infile dictionary***From:*Jon Gettman <jgettman@hughes.net>

- Prev by Date:
**Re: st: Using 9 figure numbers in Stata** - Next by Date:
**st: smearing and bootstrapping** - Previous by thread:
**Re: st: using infile dictionary** - Next by thread:
**Re: st: using infile dictionary** - Index(es):