topic Re: Keeping all variables in sas session in SAS Programming

Keeping all variables in sas session

LineMoon — Sat, 30 May 2015 11:47:49 GMT

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

Thank you

Re: Keeping all variables in sas session

Quentin — Sat, 30 May 2015 12:56:21 GMT

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;

Re: Keeping all variables in sas session

LineMoon — Sat, 30 May 2015 13:13:18 GMT

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

Re: Keeping all variables in sas session

Astounding — Sat, 30 May 2015 20:24:05 GMT

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.

Re: Keeping all variables in sas session

LineMoon — Sun, 31 May 2015 00:32:05 GMT

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

Re: Keeping all variables in sas session

Ksharp — Sun, 31 May 2015 04:01:56 GMT

Check this :