Re: Table formatting in NONMEM7- can I skip the "Table No." header row?

On Wed, May 18, 2011 at 7:39 AM, Xiao Hu <[email protected]> wrote: > > Hi, > I second what Nick said. > > When I run either NONMEM 6 or NONMEM 7 with ONEHEADER and FILE with > multiple tables (e.g. $SIM with NSUB>1) in the output then I get a TABLE NO. > record followed by the header record with every table. > > What I did was to generate one simulation table with header, and multiple > simulation table (subprobs>1) without header. Then the header of the first > data file is transferred to the second data file in R. It would be nice if > NONMEM can provide option with just one header per table with subprobs>1. > > Best regards, > Shelley > > ======================================== > Xiao Hu (Shelley), Ph.D. > Senior Scientist, > Clinical Pharmacology and Pharmacometrics > Biogen Idec, Inc. > 14 Cambridge Center > Cambridge, MA 02142 > > > > *Nick Holford <[email protected]>* > Sent by: [email protected] > > 18-May-2011 05:22 AM > > Message Size: *16.7 KB* > To > nmusers <[email protected]> > cc > Subject > Re: [NMusers] Table formatting in NONMEM7- can I skip the "Table No." > header row? > > > > > Hi, > > The ONEHEADER option was introduced some time ago (NONMEM V?) to get rid of > the repeat of the TABLE and header record after every 900 records within the > same table (I think this was a 'feature' in the days of actual printing > files on paper). It would be nice if this was the default because I cannot > image anybody who wants those extra records in the file today. > > When I run either NONMEM 6 or NONMEM 7 with ONEHEADER and FILE with > multiple tables (e.g. $SIM with NSUB>1) in the output then I get a TABLE NO. > record followed by the header record with every table. > > I can't discern any difference between NONMEM 6 and NONMEM 7 in their table > behaviour despite the change in the HELP description. > > If you use R or SAS to skip the first TABLE and header records you still > need to figure out how to process the subsequent TABLE and header records if > you your table file has multiple tables as it often does when it is created > by simulation. > > It would be nice if NONMEM had the option to just print the TABLE and/or > header info just once per table file. > > Nick > > On 18/05/2011 10:06 a.m., Kristensen, Kim wrote: > Andreas, > NONMEM7 seems to have improved regarding $TABLES and the use of the > ONEHEADER statement in $TABLE (see the help below), thus, you should > able to use the content of the previous 4 mails. > However, for those still using NOMMEM6 a work around would be to use > the NOHEADER statement in $TABLE and then import the table file in to > R- and using the colnames command to insert the column name from $TABLE > in " " this should give you a table file without a new column name row > in row 901,1801.. etc. when using ONEHEADER (See example below). > > > NONMEM7 help $TABLE > > NOHEADER > Used only with the FILE option. No header lines are included in > the table file. > > ONEHEADER > Used only with the FILE option. Only the first line of the table > is a header line. > > NONMEM6 help $TABLE > > NOHEADER > Used only with the FILE option. No header lines are included in > the table file. > > ONEHEADER > Used only with the FILE option. Only the first 900-record seg- > ment of the table is preceded by header lines. > > > Ex. NONMEM6 > > $TABLE ID TIME DOSE NOPRINT NOHEADER FILE=sdtab1 > > R- command > > DATA<- read.delim("sdtab1", header=F, > sep="", as.is=T) # Read the NM6 > table into R- > colnames(DATA) <- c("ID","TIME","DOSE", > "DV,"PRED","RES","WRES") # Insert Column Names > write.table(DATA, "sdtab1.csv", col.names=T, row.names=F, > quote=F, sep=",",eol='\n') # Create a new .csv > table file > > > NB. The last 4 columns are automatically added if NOAPPAND is not used > in $TABLE > > NOAPPEND > Requests that items DV, PRED, RES, WRES not appear automatically. > > > Regards, > > > Kim Kristensen > Senior Pharmacokinetisist, > M.Sc.(pharm), PhD > _____________________________________________________________________ > AstraZeneca > Clinical Pharmacology & DMPK > AstraZeneca R&D Lund, > SE-221 87, Lund, Sweden, > > > > > -------------------------------------------------------------------------- > Confidentiality Notice: This message is private and may contain > confidential and proprietary information. If you have received this message > in error, please notify us and remove it from your system and note that you > must not copy, distribute or take any action in reliance on it. Any > unauthorized use or disclosure of the contents of this message is not > permitted and may be unlawful. > > -----Original Message----- > From: *[email protected]* <[email protected]> [* > mailto:[email protected]* <[email protected]>] > On Behalf Of AVG (Andreas Velsing Groth) > Sent: 17. maj 2011 15:09 > To: 'Sebastien Bihorel'; nmusers > Subject: [NMusers] Table formatting in NONMEM7- can I skip the "Table > No." header row? > > Dear fellow Nmus, > > Does anyone know whether I can make an output table with $TABLE skipping > the "Table No. 1" row and going straight to the row with the actual > column headers? The purpose is to ease import of the output table to > other applications, particularly SAS. > > I think that should be possible, but maybe some dirty tricks are > required? > > I consider this somewhat related to Sebastiens Q below. > > Thanks in advance, > Andreas > > Andreas Velsing Groth > Modelling Scientist > Quantitative Clinical Pharmacology > Novo Nordisk A/S > Denmark > > -----Original Message----- > From: *[email protected]* <[email protected]> [* > mailto:[email protected]* <[email protected]>] > On Behalf Of Sebastien Bihorel > Sent: 2. december 2010 15:58 > To: nmusers > Subject: [NMusers] Table formatting in NONMEM7 > > Dear NMusers, > > I was wondering if there is a way to change the default format of output > tables in NONMEM7. I know that the FORMAT option allows the user to > override the default format at each $TABLE statement, but adding this > option in every control stream can become a very burdensome task. I'd > like to change the default format globally... maybe by changing an > installation setting file? > I have tried to look in the manual and on the web but did not find > anything relevant (wrong keywords???) > > I would appreciate any feedback for the group. > > Thank you > > Sebastien > > > > > -- > Nick Holford, Professor Clinical Pharmacology > Dept Pharmacology & Clinical Pharmacology > University of Auckland,85 Park Rd,Private Bag 92019,Auckland,New Zealand > tel:+64(9)923-6730 fax:+64(9)373-7090 mobile:+64(21)46 23 53 > email: *[email protected]* <[email protected]> > http://www.fmhs.auckland.ac.nz/sms/pharmacology/holford > -- Navin Goyal