Statalist


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

st: RE: RE: outfix2 and outfixt


From   "Prashant Shukla" <[email protected]>
To   <[email protected]>
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: [email protected]
[mailto:[email protected]] On Behalf Of Prashant
Shukla
Sent: Wednesday, December 17, 2008 5:22 PM
To: [email protected]
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: [email protected]
[mailto:[email protected]] On Behalf Of Prashant
Shukla
Sent: Wednesday, December 17, 2008 3:13 PM
To: [email protected]
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/



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