Re: ACCEPT question

From: Jia Ji Date: July 07, 2011 technical Source: mail-archive.com
Hi Jill and Manisha, Thank you very much for your replies! My problem is probably not due to (a), because it gave the same results if I remove all rows with "#" in front. By looking at FDATA file and output file, I found actually it reads the correct number of data records, but total number of obs records is a bit less (shown as below). So what could cause the difference between these two numbers? NO. OF DATA RECS IN DATA SET: 1493 TOT. NO. OF OBS RECS: 1378 Many thanks! Jackie
Quoted reply history
On Wed, Jul 6, 2011 at 3:34 PM, Jill Fiedler-Kelly < [email protected]> wrote: > ** > Hi Jackie and Manisha, > > IF multiple conditions are specified in either the ACCEPT=(list) or > IGNORE=(list) option on $DATA, they are connected by an implied ".OR." > operator regardless of whether they are listed within parentheses with a > comma between the conditions or in separate statements. So, the original > specification Jackie gives below should, in fact, keep only those records > where DVID=1 OR CYC=1, as intended. > > I suspect that the difference between what was expected and what actually > happened has to do with either: (a) the presence of the IGNORE=# option or > (b) the layout of the dataset. > For case (a), the records with '#" in the first column will be excluded > given the presence of the IGNORE=# option. In the sample you provided, they > correspond with two of records where DVID=1 (which may have been counted in > the records you expected to keep). > For case (b), the '.' values in the sample dataset provided in the DV and > MDV columns line up right next to the value in the column to the left > without a space between and therefore, may not be being read as the next > column as intended. This would result in all of the columns after the '.' > being off by 1. For example, in row 2 of the sample dataset, it may be that > NONMEM is reading DAY= 1., DV=0, TIME=3, and DVID=1. This would throw off > your counts and can be confirmed by examining the FDATA file. > > Kind regards, > Jill > > -- > Jill Fiedler-Kelly > VP, Pharmacometric Services & CSO > Cognigen Corporation > 395 Youngs Road > Buffalo, NY 14221 > (v) 716.633.3463, ext. 228 > (f) 716.633.7404 > (e) [email protected] http://www.cognigencorp.com/ > > > > Manisha Lamba wrote: > > Hi Jackie: You are correct that the comma (',') in ACCEPT command works as > an "AND" so in your case it includes only those records which satisfy both > conditions i.e where DVID=1 *and* CYC=1. If you want to evaluate 'OR' > instead, the only way I can think of is it give multiple ACCEPT commands. > ACCEPT = (CYC.EQ.1) > ACCEPT = (DVID.EQ.1). > > This should include all those records where either condition is true. > > Cheers, > Manisha > > > On Wed, Jul 6, 2011 at 6:59 AM, Jia Ji <[email protected]> wrote: > >> Hi, >> >> I encounted a problem when using ACCEPT in NONMEM. In my dataset, I want >> to extract observations with DVID=1 *or* CYC=1. When I used >> ACCEPT=(DVID.EQ.1,CYC.EQ.1), it gave a total number of obs as the number of >> obs with CYC=1 only, but much less than the number of obs with either DVID=1 >> or CYC=1. But if I want to extract observations with DVID=1 *and* CYC=1, >> it works fine using IGNORE=(DVID.NE.1,CYC.NE.1). So I don't understand why >> ACCEPT is not working here. I attached a sample of my dataset and control >> stream. I would highly appreciate any feedback/advice on my question. Thank >> you very much! >> >> Jackie >> >> **************************** >> Dataset >> >> #READ ID CYC DAY DV TIME DVID MDV >> . 49102 1 1 0 0 1 0 . 49102 1 1 . 0 3 1 . 49102 1 8 1 7 1 0 . 49102 1 >> 15 0 14 1 0 . 49102 1 22 0 21 1 0 . 49102 2 1 0 42 1 0 # 49102 2 8 . 49 1 >> . . 49102 2 8 1 49 3 0 # 49102 2 15 . 56 1 . >> >> Control stream >> >> $PROBLEM RUN101 >> $INPUT READ ID CYC DAY DV TIME DVID MDV >> $DATA ***.csv IGNORE=# ACCEPT=(DVID.EQ.1,CYC.EQ.1) >> $PRED >> ... >> > > > -- > Jill Fiedler-Kelly > VP, Pharmacometric Services & CSO > Cognigen Corporation > 395 Youngs Road > Buffalo, NY 14221 > (v) 716.633.3463, ext. 228 > (f) 716.633.7404 > (e) [email protected] http://www.cognigencorp.com/ > >
Jul 06, 2011 Jia Ji ACCEPT question
Jul 06, 2011 Manisha Lamba Re: ACCEPT question
Jul 06, 2011 Jill Fiedler-Kelly Re: ACCEPT question
Jul 07, 2011 Jia Ji Re: ACCEPT question
Jul 07, 2011 Jill . Fiedler-Kelly Re: ACCEPT question