Date:         Wed, 9 May 2012 15:54:28 +0000
Reply-To:     Randy Herbison <RandyHerbison@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Randy Herbison <RandyHerbison@WESTAT.COM>
Subject:      Re: What option causes this?
Comments: To: "Kirby, Ted" <ted.kirby@LEWIN.COM>
In-Reply-To:  <CDA433BB57DF5346A001F70B19E7755A46CDF5@USFCH-MAIL1.lewin.com>
Content-Type: text/plain; charset="us-ascii"

I think the log mess may have started when VIEWTABLE was modified to use long format names.  The generated code gets user-defined formats probably to include on the format selection list.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Kirby, Ted
Sent: Tuesday, May 08, 2012 6:16 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: What option causes this?

Every time I change the format of a variable in the "ViewTable" window (usually a SAS date number to a SAS date for easy viewing), a bunch of code suddenly shows up in the SAS Log.  The code starts with:



607 proc delete data=work._qwffmt;

608 run;

WARNING: File WORK._QWFFMT.DATA does not exist.

NOTE: PROCEDURE DELETE used (Total process time):

real time 0.03 seconds

cpu time 0.01 seconds

609 proc sql;

610 create table work._qwffmt as select fmtname,libname,memname from dictionary.formats where

610! source='C' and fmttype='F' order by libname,memname;

NOTE: Table WORK._QWFFMT created, with 8 rows and 3 columns.

611 quit;

NOTE: PROCEDURE SQL used (Total process time):

real time 0.07 seconds

cpu time 0.03 seconds



and goes on for over 100 lines (including notes, error messages and blank lines).



I think that I must have some sort of option checked to create this log entry.  Which option is it and how do I turn it off?



Ted Kirby

Consultant,

The Lewin Group, Inc.

3130 Fairview Park Drive, Suite 500

Falls Church, VA  22042

(703) 269-5507

Fax:  (703) 269-5501




************* IMPORTANT - PLEASE READ ********************

This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed.  If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.