BookmarkSubscribeRSS Feed
the_fabs
Calcite | Level 5

I have a series of 58 monthly survey data sets in sas7bdat format. When I open the data I see that categorical variables (columns) are coded with numeric values (e.g., male = 0, female = 1, etc.). I was wondering if sas7bdat files contain metadata where I could see things such a description of the data set, a description of the variables, or the coding of categorical variables. If that metadata exists, how can I see it? How can I export it? From my work with Stata and R, I know data sets can have this metadata. My main concerns is that the coding of any of the variables might change throughout the 58 data sets. So, I would prefer to have this variable coding in the metadata where I can work with it more easily than if I have to check for coding changes in the documentation.

1 REPLY 1
Patrick
Opal | Level 21

The only metadata available are the variable attributes like type, length, format,.... and constraints (if any).

You can easily report on this metadata using SAS

proc contents data=<libref>.<table name>;
run;quit;

or for all tables under a libref:
proc contents data=<libref>._all_;
run;quit;

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1113 views
  • 0 likes
  • 2 in conversation