05-30-2015 08:56 AM
Can you describe what you want a bit more? You have a SAS session, that has libraries defined, and datasets in those libraries, and variables in those datatsets. That's a lot of variables. You want a list of all those variables?? And what attributes?
You might start by looking at dictionary.columns
create table AllVars as
select * from dictionary.columns
proc print data=AllVars;
05-30-2015 09:13 AM
Thank you for your message.
Yes , I want to see all variables and thier attributes( name, type, length, ....)
It is great, if i can see if the variable is missing or not.
05-30-2015 04:24 PM
PROC CONTENTS does this pretty easily:
proc contents data=lib._all_ out=lib._contents_;
You have the option of adding the word NOPRINT if you want the data set only but not a printed report. Of course, you don't have to run this right away. It can be run later, as long as you don't delete any data sets.
This stores the attributes. That has nothing to do with missing values, which you will have to analyze separately.
05-30-2015 08:32 PM
Yes, that's right, but I need also to know the missing variables.
If I have a data with some of the missing variables and i want to see the missing variables and the non missing variables for all the libraries
Lib Table vaiable type length Missing
lb1 t11 v11 1 5 yes
lb2 t21 v21 2 $8 no
lbn tn1 vn1 1 3$ yes