Prev: turn off proc export writing code to log ?
Next: Reading Data From a Specific Excel Worksheet
From: rjf2 on 4 Feb 2010 15:29
options nonotes;
proc export;
run;
options notes;

> -----Original Message-----
> From: owner-sas-l(a)listserv.uga.edu [mailto:owner-sas-
> l(a)listserv.uga.edu] On Behalf Of Tom Smith
> Sent: Thursday, February 04, 2010 3:06 PM
> To: SAS-L(a)LISTSERV.UGA.EDU
> Subject: turn off proc export writing code to log ?
>
> When proc export is used, it writes code to the log as follows. Is
> there
> any option to turn off this code exporting ?
>
> Thanks a lot.
>
> 954
> /*******************************************************************
> ***
> 955 * PRODUCT: SAS
> 956 * VERSION: 9.2
> 957 * CREATOR: External File Interface
> 958 * DATE: 04FEB10
> 959 * DESC: Generated SAS Datastep Code
> 960 * TEMPLATE SOURCE: (None Specified.)
> 961
>
***********************************************************************
> /
> 962 data _null_;
> 963 set mydata end=EFIEOD;
> 964 %let _EFIERR_ = 0; /* set the ERROR detection macro variable
> */
> 965 %let _EFIREC_ = 0; /* clear export record count macro
> variable */
> 966 file 'C:\Mydoc\
> ...
> ...
From: Jim Groeneveld on 4 Feb 2010 15:48
Hi Tom,

You already got your answer. Yet the code written to the log may be quite
useful for building your own exporting code, departing from the code that
PROC EXPORT (and IMPORT as well) generate. Instead of the PROC you can
insert the data step code in your program and fine tune it to your needs.

Regards - Jim.
--
Jim Groeneveld, Netherlands
Statistician, SAS consultant
http://jim.groeneveld.eu.tf


On Thu, 4 Feb 2010 15:05:52 -0500, Tom Smith <tomquin99(a)GMAIL.COM> wrote:

>When proc export is used, it writes code to the log as follows. Is there
>any option to turn off this code exporting ?
>
>Thanks a lot.
>
>954 /*******************************************************************
>***
>955 * PRODUCT: SAS
>956 * VERSION: 9.2
>957 * CREATOR: External File Interface
>958 * DATE: 04FEB10
>959 * DESC: Generated SAS Datastep Code
>960 * TEMPLATE SOURCE: (None Specified.)
>961
>***********************************************************************/
>962 data _null_;
>963 set mydata end=EFIEOD;
>964 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
>965 %let _EFIREC_ = 0; /* clear export record count macro
>variable */
>966 file 'C:\Mydoc\
> ...
> ...
From: Tom Smith on 4 Feb 2010 16:33
options nonotes does not work for this issue.

Jim's suggestion may be a choice. But since the table structures may
danamically change, it may not be good to use this method for an automatic
SAS task.

Thank you.
 | 
Pages: 1
Prev: turn off proc export writing code to log ?
Next: Reading Data From a Specific Excel Worksheet