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
Content-Type: text/plain; charset="us-ascii"
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.
From: firstname.lastname@example.org [mailto:email@example.com]
On Behalf Of firstname.lastname@example.org
Sent: Monday, November 26, 2007 4:04 PM
Subject: attrib within proc sql
Is there something like an attrib statement within proc sql? I am
table from another table using proc sql, but want to strip all lables
formats and that crap from the input dataset before I write the output
I was using this outside of proc sql, but want to have something within
attrib _all_ label='';