Date: Tue, 29 Aug 2006 11:15:04 -0400
Reply-To: Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Subject: Re: Label
if you have a look at the table SASHELP.VCOLUMN. There is a column named
LABEL. If label is empty, there is no label associated, if there is
something, there is one.
So if you want to check it for a dataset:
(not tested)
proc sql;
create table nolabel as
select name,label from sashelp.vcolumn
where libname="your-library" and memname="the-dataset" and label=" ";
quit;
will give you all nolabeled variables. If it is empty, there are all
variables associated with labels.
On Tue, 29 Aug 2006 10:39:55 -0400, Fehd, Ronald J. (CDC/CCHIS/NCHM)
<rjf2@CDC.GOV> wrote:
>> From: yom
>> Do you know if there a way to check if a label is associated
>> to each variable in a table?
>
>and then you want to fix those that are missing, right?
>
>check our most excellent archives:
>http://www.listserv.uga.edu/archives/sas-l.html
> search for:
>subject contains: write
>author's address: RJF2
> since: 1 May 2000
> until:
>
>Ron Fehd the macro maven CDC Atlanta GA USA RJF2 ata cdc d0t g0v
>
>
>
>Date: Mon, 1 May 2006 15:46:41 -0400
>Subject: tip: Write Attribute
>http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0605A&L=sas-l&P=R6739
|