[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: multiple commands in one pass of data
From: |
la |
Subject: |
RE: multiple commands in one pass of data |
Date: |
Fri, 6 Aug 2010 09:24:07 -0400 |
After some more testing, here's what I found out.
The fields that I have defined as numeric [ N ] have a lot of records with
that field as blank.
So PSPP generates this warning:
warning: (columns 12-15,N field) All characters in field must be digits.
I knew that was the case so I was setting this parameter: SET MXWARNS=1
This is what causes pspp to stop executing after the first
procedure/command.
If I use a small test file and SET MXWARNS=1000, then it works.
But it will not work with the default of 200. I think as long as you get
less warnings than the MXWARNS, then it works.
Thoughts on a workaround?
I can probably re-code blanks to 0 but there are cases when I need to know
if an attribute was 0 or blank. I will try using null value for blanks and
see how that works.
Thanks
Luis
-----Original Message-----
From: Ben Pfaff [mailto:address@hidden
Sent: Thursday, August 05, 2010 4:28 PM
To: John Darrington
Cc: lavila; address@hidden
Subject: Re: multiple commands in one pass of data
John Darrington <address@hidden> writes:
> On Thu, Aug 05, 2010 at 11:25:34AM -0700, lavila wrote:
>
> Is there any way to run more than one set of statistics on a file in
one
> pass?
>
> For example, I need to get a MIN/MAX/MEAN on some variables and a
FREQUENCY
> and/or CROSSTAB on different variables as shown below.
>
> In my tests, only the first command is executed.
>
> GET DATA /TYPE=TXT /FILE='SAMPLE.txt' /ARRANGEMENT=FIXED /FIRSTCASE=1
> /VARIABLES = STATE 110-111 A
> INCOME_CODE 124-124 A
> ORDERS 1003-1008 N.
>
> DESCRIPTIVES ORDERS.
>
> CROSSTABS
> /TABLES = STATE BY INCOME_CODE.
>
>
> You need to terminate the syntax with:
>
> EXECUTE.
But DESCRIPTIVES and CROSSTABS are both procedures that should
run without EXECUTE.
--
Ben Pfaff
http://benpfaff.org
Re: multiple commands in one pass of data, Ben Pfaff, 2010/08/05