Data Summary

[ruffers]

I am trying to produce a list of information on all variables in a data set, including the name of each variable, it's variable label, and any value labels associated with it.

PROC CONTENTS appears to take care of the variable labels, but I cannot figure out how to include the value labels in this list.

Is there any way to do this?

 

[kdt82]

Hi Ruffers,

By value labels, I think you are referring to formats. This information is provided by the defualt proc contents under "formats".

proc contents data=have;
run;


output:
 Variable    Type    Len    Format
  text        Char      8
  val         Num       8    TEST.

HTH

 

[ruffers]

Thanks kdt82,

By value labels I mean, for example, with a variable called COUNTRY I would have:

1. France
2. Germany
3. Italy
4. Spain
5. UK

I need to find a way to have these options included in my summary list of variables.

 

[kdt82]

Ok so you want to see the formats associated with a variable.

To see the contents of the formats catalog you can use the following

proc format fmtlib;
run;

To see this in a table form.

proc format fmtlib out=tformats;
run;

Or use the following to code to create a table displaying all variables, and displaying variables with formats unformatted and formatted (prefixed with _). I have included a dummy dataset to show how it works

proc format;
    value test 1='one'
               2='two'
               3='three'
    ;
run;

data have;
format val test.;
input val text$;
cards;
1 this
2 is a
3 test
;
run;

proc sql noprint;
select compress(name|| "= _" || name) 
into :l_value
from dictionary.columns 
where memname="HAVE" and format;
quit;

data want;
set have;
format _all_;
set have(rename=(&l_value));
run;

HTH