Date:         Mon, 26 Nov 2007 16:57:35 -0500
Reply-To:     Mike Rhoads <RHOADSM1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mike Rhoads <RHOADSM1@WESTAT.COM>
Subject:      Re: attrib within proc sql
Comments: To: toby989@hotpop.com
In-Reply-To:  <fifca7$ra4$1@news.Stanford.EDU>
Content-Type: text/plain; charset="us-ascii"

Toby,

As far as I know, there is no ATTRIB statement or equivalent in PROC
SQL.  You would have to strip labels and formats variable by variable,
which would be a royal pain.

I would probably run PROC DATASETS following the PROC SQL to strip the
attributes, using the MODIFY, LABEL, and FORMAT statements.

Mike Rhoads
Westat
RhoadsM1@Westat.com

-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of toby989@hotpop.com
Sent: Monday, November 26, 2007 4:04 PM
To: sas-l@uga.edu
Subject: attrib within proc sql


Hi All

Is there something like an attrib statement within proc sql? I am
creating a
table from another table using proc sql, but want to strip all lables
and
formats and that crap from the input dataset before I write the output
dataset.

I was using this outside of proc sql, but want to have something within
proc sql:
attrib _all_ label='';

Thanks Toby