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

From |
"Prashant Shukla" <PShukla@globalshares.com> |

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

Subject |
st: RE: RE: outfix2 and outfixt |

Date |
Thu, 18 Dec 2008 23:02:57 -0000 |

Hi Again, I am having trouble using -outfixt- to export files that go beyond 400 positions. Maybe there is a limit I am supposed to reset somewhere but what is happening is that -outfixt- works perfectly when the start positions in cols are below 400 but when they go beyond 400 it gives me a "invalid syntax, r(198) error". I kept everything else in the command exactly the same, just adding an extra variable and its start position, larger than 400, triggers the invalid syntax error. For example: quiet outfixt a b c d e f g h i j k l m n o p q r s t u v w x y using filename, replace cols ( 1 4 12 20 28 36 46 56 68 83 93 123 138 146 151 153 159 168 176 181 192 200 211 331 339) format flist ( ) Works perfectly, but, quiet outfixt a b c d e f g h i j k l m n o p q r s t u v w x y z using filename, replace cols ( 1 4 12 20 28 36 46 56 68 83 93 123 138 146 151 153 159 168 176 181 192 200 211 331 339 413) format flist ( ) Gives the "ivalid syntax" error. I have checked the command many times and everything else is identical. Can anyone who has used these before, or Austin Nichols who wrote it, help me out? I just can't figure out what I am doing wrong. 400 seems rather small to be a limit, and the file I am using has up to 300 columns with width close to 4000. How can I overcome this issue. Thanks a bunch, -Prash. -----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Prashant Shukla Sent: Wednesday, December 17, 2008 5:22 PM To: statalist@hsphsun2.harvard.edu Subject: st: RE: outfix2 and outfixt Please ignore my previous post, the following command with -outfixt- gives perfect results, i.e, correct formatting copied from the Stat data file and correct starting positions for all columns. quiet outfixt a b c d e f g h i j k l m n o p using filename, replace cols ( 1 4 12 20 28 36 46 56 68 83 93 123 138 146 151 153) format flist ( ) Thanks, -Prash. -----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Prashant Shukla Sent: Wednesday, December 17, 2008 3:13 PM To: statalist@hsphsun2.harvard.edu Subject: st: outfix2 and outfixt Hi All, If any one has used -outfix2- and -outfixt- please provide some guidance. I need to produce fixed width files with the columns formatted a certain way; and I already have all the columns in the right format. I have been trying to use both these routines but have been unsuccessful. While using -outfix2- the following command gives me "option format () incorrectly specified" error. quiet outfix2 a b c d e f g h i j k l m n o p using filename, cols (1 4 12 20 28 36 46 56 68 83 93 123 138 146 151 153) format (%3s %8.0g %8.0g %8s %8.0g %10s %010.6f %09.0f %015.6f %10s %30s %015.6f %8s %5s %2s %8.0g ) On -outfixt-, when used without the -format- option it gives perfect results, i.e., all the columns are at their respective places but the formats are not the way I want them so I have to use the -format- option. Below is a sample statement: quiet outfixt a b c d e f g h i j k l m n o p using "filename", replace cols (1 4 12 20 28 36 46 56 68 83 93 123 138 146 151 153 ) However, when I introduce the -format- and -flist- option, the resulting columns are not where I want. For instance, the second column does not start at position 4 instead there is a gap of 4 spaces between the first and the second columns and the after that none of the columns are in their respective positions. Below is a sample statement again: quiet outfixt a b c d e f g h i j k l m n o p using "filename", replace cols (1 4 12 20 28 36 46 56 68 83 93 123 138 146 151 153 ) format flist (%3s %8.0g %8.0g %8s %8.0g %10s %010.6f %09.0f %015.6f %10s %30s %015.6f %8s %5s %2s %8.0g ) Also, FYI, there are columns which are prescribed to be longer than the elements that they actually contain, i.e. column with a width of 30 does not necessarily have an element that long. And there are some blank columns too. But this did not matter when not using -format- option. Why is the introduction of -format- changing things now? Is it not possible to just use the formats from Stata without having to list the format for each of the variables in the -outfixt- command? Please shed some light on this if you can. Thanks you all very much, -Prash. * * 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**:**st: RE: RE: RE: outfix2 and outfixt***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

**References**:**st: outfix2 and outfixt***From:*"Prashant Shukla" <PShukla@globalshares.com>

**st: RE: outfix2 and outfixt***From:*"Prashant Shukla" <PShukla@globalshares.com>

- Prev by Date:
**Re: st: Constant terms in AR1 error regressions** - Next by Date:
**st: RE: RE: RE: outfix2 and outfixt** - Previous by thread:
**st: RE: outfix2 and outfixt** - Next by thread:
**st: RE: RE: RE: outfix2 and outfixt** - Index(es):

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