Date:         Tue, 17 Apr 2007 14:56:21 -0400
Reply-To:     "Presley, Rodney (CDC/CCHP/NCBDDD)" <rpa9@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Presley, Rodney (CDC/CCHP/NCBDDD)" <rpa9@CDC.GOV>
Subject:      FW: ERROR: Invalid sequence of commands for file
              WORK._FACTOTH_.DATA.
Content-Type: text/plain; charset="us-ascii"

> This is a stumper for me.  The data set _FACTOTH_ can be opened and
> printed.  The data view FACTOTH can be opened in the explorer window
> and by visual inspection appears to be correctly sorted.  
> 
> Any suggestions are welcome.
> 
> Thanks,
> 
> Rodney
> 
> 
> 607  *** program:  RARE_FACTOTH    ************** ;
> 608  *** investigate FACTOTH -- rare disorders  **** ;
> 609
> 610  proc sql;
> 611     create view factoth as
> 612     select distinct factdefvii, factdefix, vwb, baseperc, factoth,
> '' as exclude
> 613     from &sql..v_reg
> 614     where (/*factdefvii^=1 and factdefix^=1 and upcase(vwb)^='Y'
> and */factoth^='')
> 615     order by factoth
> 616     ;
> NOTE: SQL view WORK.FACTOTH has been defined.
> 617  quit;
> NOTE: PROCEDURE SQL used (Total process time):
>       real time           0.00 seconds
>       cpu time            0.00 seconds
> 
> 
> 617!       run;
> 618  proc sort data=factoth out=_factoth_;
> 619     by factoth;
> 620  run;
> 
> NOTE: There were 570 observations read from the data set WORK.FACTOTH.
> NOTE: The data set WORK._FACTOTH_ has 570 observations and 6
> variables.
> NOTE: PROCEDURE SORT used (Total process time):
>       real time           0.90 seconds
>       cpu time            0.04 seconds
> 
> 
> 621  proc print data=_factoth_ (obs=10);
> 622  run;
> 
> NOTE: There were 10 observations read from the data set
> WORK._FACTOTH_.
> NOTE: PROCEDURE PRINT used (Total process time):
>       real time           0.00 seconds
>       cpu time            0.00 seconds
> 
> 
> 623  data test1;
> 624     set _factoth_ ;
> 625  run;
> 
> ERROR: Invalid sequence of commands for file WORK._FACTOTH_.DATA.
> NOTE: The SAS System stopped processing this step because of errors.
> WARNING: The data set WORK.TEST1 may be incomplete.  When this step
> was stopped there were 0
>          observations and 6 variables.
> WARNING: Data set WORK.TEST1 was not replaced because this step was
> stopped.
> NOTE: DATA statement used (Total process time):
>       real time           0.00 seconds
>       cpu time            0.00 seconds
> 
> 
> 626  data test2;
> 627     set factoth;
> 628     by factoth;
> 629  run;
> 
> ERROR: BY variables are not properly sorted on data set WORK.FACTOTH.
> factdefvii=1 factdefix=0 vwb=  baseperc=3 factoth=? VWD exclude=
> FIRST.factoth=1 LAST.factoth=1
> _ERROR_=1 _N_=7
> NOTE: The SAS System stopped processing this step because of errors.
> NOTE: There were 8 observations read from the data set WORK.FACTOTH.
> WARNING: The data set WORK.TEST2 may be incomplete.  When this step
> was stopped there were 6
>          observations and 6 variables.
> NOTE: DATA statement used (Total process time):
>       real time           0.84 seconds
>       cpu time            0.03 seconds
> 
> 
> 
> Rodney J. Presley, PhD
> Division of Hereditary Blood Disorders
> National Center on Birth Defects and Developmental Disabilities
> Centers for Disease Control and Prevention
> 1600 Clifton Road, MS E 64
> Atlanta, GA 30333
> Work Phone: 404-718-8630
> Main Number: 404-718-8600
> Fax: 404-718-8650
> Email: RPresley@cdc.gov
> 
>