How to make vlabel return missing value when label is null

whymath — Mon, 21 Jul 2025 03:38:39 GMT

According to SAS Help Center, vlabel function returns the label that is associated with that variable name, or the variable name if no label exists.

Is it possible to make vlabel return missing value when no label exists?

Re: How to make vlabel return missing value when label is null

ballardw — Mon, 21 Jul 2025 04:11:18 GMT

Parse the result and if the same as the variable then set to missing would be the only approach I am aware of.

However, when you have a label like "Name" for a variable with the name of 'Name' you are going to cause problems.

You can get a missing value for the label by examining sashelp.vcolumn, or dictionary.columns or an output data set created with Proc Contents. If a label is not assigned the Label variable would be missing in the resulting data set.

Example looking at the SAS supplied data set SASHELP.CLASS that you should have installed:

Proc contents data=sashelp.class out=work.classinfo;
run;

data work.classinfo2;
   set sashelp.vcolumn (where=(libname='SASHELP' and memname='CLASS'));
run;

proc sql;
   create table work.classinfo3 as
   select *
   from dictionary.columns
        where libname='SASHELP' and memname='CLASS'
   ;
quit;

Note that the Proc Contents data set has a different structure and content than the the other two.

If using the SASHELP.VCOLUMN or dictionary table the Libname and Memname, library and data set names, must use upper case values from the source as that is how they are stored. The view holding, SASHELP.VCOLUMN holds information of every variable in every data set in your current session and if you don't provide the library and member name you will get a lot of unwanted stuff.

topic How to make vlabel return missing value when label is null in SAS Programming

How to make vlabel return missing value when label is null

Re: How to make vlabel return missing value when label is null