Keeping all variables in sas session

Reply
Super Contributor
Posts: 371

Keeping all variables in sas session

Please, we want to keep all sas variables attibutes in sas session by library in one file (or data).

Thank you

PROC Star
Posts: 1,237

Re: Keeping all variables in sas session

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

proc sql;

create table AllVars as

select * from dictionary.columns

  ;

quit;

proc print data=AllVars;

run;

Super Contributor
Posts: 371

Re: Keeping all variables in sas session

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.

Thank you

Super User
Posts: 5,099

Re: Keeping all variables in sas session

PROC CONTENTS does this pretty easily:

proc contents data=lib._all_ out=lib._contents_;

run;

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.

Good luck.

Super Contributor
Posts: 371

Re: Keeping all variables in sas session

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

Super User
Posts: 9,691

Re: Keeping all variables in sas session

Check this :

Ask a Question
Discussion stats
  • 5 replies
  • 231 views
  • 0 likes
  • 4 in conversation