topic Re: Removing user defined labels created in Proc SQL in SAS Procedures

Removing user defined labels created in Proc SQL

deleted_user — Fri, 19 Mar 2010 12:39:29 GMT

I have inherited a number of SAS datsets created in Proc SQL and need to delete the old user defined labels. I was wondering if there is a fast way to remove all of the old labels for each table without having to rerun all new queries and deleting them all manually.

Re: Removing user defined labels created in Proc SQL

sbb — Fri, 19 Mar 2010 13:04:42 GMT

Clarification: remove a SAS dataset label or remove one or more SAS variable label within a given dataset? Have you looked at PROC DATASETS - link below to example (found from SAS support http://support.sas.com/ website SEARCH):

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a003185567.htm

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument, this topic/post:

remove sas variable label site:sas.com

Message was edited by: sbb Message was edited by: sbb

Re: Removing user defined labels created in Proc SQL

deleted_user — Fri, 19 Mar 2010 14:02:59 GMT

Thanks Scott, this works perfectly. - Bob

Re: Removing user defined labels created in Proc SQL

FrankSong — Wed, 04 Dec 2019 15:35:00 GMT

if you want to get ride of a specific label for x inherited from an Olddata

proc sql;

create table Yourdata as select ...,...., oldX as x label =""

from Olddata;

if x has a label that you want to remove

Data Yourdata; set Yourdata;

label x =;

run;