Discussion:
Running SAS programs against sas7bdat vs. transport files
(too old to reply)
Bill
2004-07-15 18:21:52 UTC
Permalink
I'm curious if there are advantages/disadvantages to running SAS
reporting programs directly against transport files (xport engine) vs.
directly from the native sas7bdat data.

I believe that any format attachments I have would be lost if using
XPT files, and that XPT files cannot be indexed. Are there any other
drawbacks?

Thanks
Groeneveld, Jim
2004-07-16 07:17:21 UTC
Permalink
Hi Bill,

I really believe that before doing e.g. statistical PROCs you have to convert your transport files into SAS datasets, as only those are the types of files to be read.

Regards - Jim.
--
. . . . . . . . . . . . . . . .

Jim Groeneveld, MSc.
Biostatistician
Science Team
Vitatron B.V.
Meander 1051
6825 MJ Arnhem
Tel: +31/0 26 376 7365
Fax: +31/0 26 376 7305
***@Vitatron.com
www.vitatron.com

My statistics are quite predictable, but my computer may be quite unpredictable.

[common disclaimer]


-----Original Message-----
From: Bill [mailto:***@YAHOO.COM]
Sent: Thursday, July 15, 2004 20:22
To: SAS-***@LISTSERV.UGA.EDU
Subject: Running SAS programs against sas7bdat vs. transport files


I'm curious if there are advantages/disadvantages to running SAS
reporting programs directly against transport files (xport engine) vs.
directly from the native sas7bdat data.

I believe that any format attachments I have would be lost if using
XPT files, and that XPT files cannot be indexed. Are there any other
drawbacks?

Thanks
Bill
2004-07-16 18:08:57 UTC
Permalink
I was thinking if I only call in a couple datasets, I could easily do
a libname for each dataset, (e.g., libname indata xport
'filename.xpt';). This would allow the procs to work appropriately.

For US submissions to the FDA, we send in transport files. One goal
is to run the reports off of the same data you send to the FDA, so why
not try and do this against the transport files that are sent to them?
This is the question driving my madness!
Post by Groeneveld, Jim
Hi Bill,
I really believe that before doing e.g. statistical PROCs you have to convert your transport files into SAS datasets, as only those are the types of files to be read.
Regards - Jim.
--
. . . . . . . . . . . . . . . .
Jim Groeneveld, MSc.
Biostatistician
Science Team
Vitatron B.V.
Meander 1051
6825 MJ Arnhem
Tel: +31/0 26 376 7365
Fax: +31/0 26 376 7305
www.vitatron.com
My statistics are quite predictable, but my computer may be quite unpredictable.
[common disclaimer]
-----Original Message-----
Sent: Thursday, July 15, 2004 20:22
Subject: Running SAS programs against sas7bdat vs. transport files
I'm curious if there are advantages/disadvantages to running SAS
reporting programs directly against transport files (xport engine) vs.
directly from the native sas7bdat data.
I believe that any format attachments I have would be lost if using
XPT files, and that XPT files cannot be indexed. Are there any other
drawbacks?
Thanks
Sigurd Hermansen
2004-07-16 19:00:59 UTC
Permalink
Bill:
SAS does not support any process that requires direct access to a transport
file (for example, PROC FREQ). Most users of transport files simply convert
them to SAS WORK datasets. I'd bet that the FDA does just that. Mechanical
remapping of data from transport format to SAS dataset format does not make
data any less equivalent. Whether read from a transport file or a SAS
dataset, programs control displays of data, but equivalently formatted data
should yield the same statistical estimates and selections.
Sig

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-***@LISTSERV.UGA.EDU] On Behalf Of Bill
Sent: Friday, July 16, 2004 2:09 PM
To: SAS-***@LISTSERV.UGA.EDU
Subject: Re: Running SAS programs against sas7bdat vs. transport files


I was thinking if I only call in a couple datasets, I could easily do a
libname for each dataset, (e.g., libname indata xport 'filename.xpt';).
This would allow the procs to work appropriately.

For US submissions to the FDA, we send in transport files. One goal is to
run the reports off of the same data you send to the FDA, so why not try and
do this against the transport files that are sent to them?
This is the question driving my madness!


***@VITATRON.COM (Groeneveld, Jim) wrote in message news:<***@AMSM1BMSGM01.ent.core.medtron
ic.com>...
Post by Groeneveld, Jim
Hi Bill,
I really believe that before doing e.g. statistical PROCs you have to
convert your transport files into SAS datasets, as only those are the
types of files to be read.
Regards - Jim.
--
. . . . . . . . . . . . . . . .
Jim Groeneveld, MSc.
Biostatistician
Science Team
Vitatron B.V.
Meander 1051
6825 MJ Arnhem
Tel: +31/0 26 376 7365
Fax: +31/0 26 376 7305
www.vitatron.com
My statistics are quite predictable, but my computer may be quite
unpredictable.
[common disclaimer]
-----Original Message-----
Sent: Thursday, July 15, 2004 20:22
Subject: Running SAS programs against sas7bdat vs. transport files
I'm curious if there are advantages/disadvantages to running SAS
reporting programs directly against transport files (xport engine) vs.
directly from the native sas7bdat data.
I believe that any format attachments I have would be lost if using
XPT files, and that XPT files cannot be indexed. Are there any other
drawbacks?
Thanks
Howard Schreier
2004-07-16 19:10:14 UTC
Permalink
That's true of transport files as created by PROC CPORT.

Here it's an engine (no conversion proc). It should work.

On Fri, 16 Jul 2004 09:17:21 +0200, Groeneveld, Jim
Post by Groeneveld, Jim
Hi Bill,
I really believe that before doing e.g. statistical PROCs you have to
convert your transport files into SAS datasets, as only those are the types
of files to be read.
Post by Groeneveld, Jim
Regards - Jim.
--
. . . . . . . . . . . . . . . .
Jim Groeneveld, MSc.
Biostatistician
Science Team
Vitatron B.V.
Meander 1051
6825 MJ Arnhem
Tel: +31/0 26 376 7365
Fax: +31/0 26 376 7305
www.vitatron.com
My statistics are quite predictable, but my computer may be quite
unpredictable.
Post by Groeneveld, Jim
[common disclaimer]
-----Original Message-----
Sent: Thursday, July 15, 2004 20:22
Subject: Running SAS programs against sas7bdat vs. transport files
I'm curious if there are advantages/disadvantages to running SAS
reporting programs directly against transport files (xport engine) vs.
directly from the native sas7bdat data.
I believe that any format attachments I have would be lost if using
XPT files, and that XPT files cannot be indexed. Are there any other
drawbacks?
Thanks
Loading...