RE: Table formatting in NONMEM7- can I skip the "Table No." header row?
In SAS you can do the same thing by using infile statement with FIRSTOBS option
which specifies the row number that SAS uses to start reading data records.
Also, You have to specify names of the columns as part of the INPUT statement
which should match the column names of your output table file.
Hope it helps.
data test;
infile 'Location of datafile' FIRSTOBS=3 ;
INPUT ID TIME TAD DOSE DV PRED RES WRES;
RUN;
Regards
Nitin Mehrotra
Division of Pharmacometrics
Office of Clinical Pharmacology
US Food and Drug Administration
"The contents of this message are mine personally and do not necessarily
reflect any position of the Government or the Food and Drug Administration."
Quoted reply history
-----Original Message-----
From: [email protected] [mailto:[email protected]] On
Behalf Of Michael Fossler
Sent: Tuesday, May 17, 2011 9:37 AM
To: AVG (Andreas Velsing Groth); 'Sebastien Bihorel'; nmusers
Subject: RE: [NMusers] Table formatting in NONMEM7- can I skip the "Table No."
header row?
In R you don't need to worry about the "Table No. 1" if you use the "skip"
argument of the read.csv() command. For example
data<-data.frame(read.csv(paste(dir,run.name,".csv",sep=""),header=TRUE,sep=",",stringsAsFactors=F,skip=1))
using skip=1 as above will cause R to jump over the first line, which is
"Table No. 1". I suspect that SAS has a similar command.
-----Original Message-----
From: [email protected] [mailto:[email protected]] On
Behalf Of AVG (Andreas Velsing Groth)
Sent: Tuesday, May 17, 2011 9:09 AM
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