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

From: Kim Kristensen Date: May 18, 2011 technical Source: mail-archive.com
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.
Quoted reply history
-----Original Message----- From: [email protected] [mailto:[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] [mailto:[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