RE: Table formatting in NONMEM7- can I skip the "Table No." header row?
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