Analyze table in SAS Studio

[Sarra-Matri]

 Which Sas procedure we use to analyze the content of  table sas  : contents , freq , univariate or print ?

Any help please 

[sbxkoenk]

That's a strange question. [ The answer is in your question🙂. ]

What do you mean by 'content'? 

You can of course use PROC CONTENTS; but the other procedures you mention are also viable options.

What version of SAS are you using?

Find out by submitting:

%PUT &=sysvlong;

If you have SAS VIYA, you can additionally use PROC CARDINALITY:

proc cardinality data=mycas.XYZ outcard=mycas.card
                 outdetails=mycas.details maxlevels=5;
run;

 Cheers,

Koen

[Sarra-Matri]

sas studio

[sbxkoenk]

Hello,

SAS Studio is not a SAS version.

SAS Studio can be used as a browser-based (front-end) editor for SAS 9.4 and SAS VIYA!

Please submit: 

%PUT &=sysvlong;

and look in the log window for the result!

My LOG says:

SYSVLONG=V.03.05M0P111119

when I am in VIYA and says

SYSVLONG=9.04.01M4P110916

when I am in SAS 9.4 Maintenance Level 4

**** But please elaborate on what you want to find out with your 'content' query. I still don't have a clue on what you want to achieve. ****

Cheers,

Koen

[sbxkoenk]

Submit this and you will find out what each of these procedures could mean to you.

I have put the PROC PRINT in comment as it just displays the big table in the OUTPUT.

It's better to view the entire table by giving the 'VT SASHELP.SHOES' command in the command line, where 'VT' is for ViewTable.

*PROC PRINT data=sashelp.shoes; *run;
PROC CONTENTS data=sashelp.shoes; run;
PROC UNIVARIATE data=sashelp.shoes PLOT; var _numeric_; run;
PROC FREQ data=sashelp.shoes; tables _character_; run;
/* end of program */

As said, in VIYA you can additionally use a PROC CARDINALITY!!

Good luck,

Koen

[Sarra-Matri]

Thank you for your help

[Reeza]

Depends on what you mean by "analyze".

Variables Names and types/formats of variables? Then use Contents.

To explore categorical variables, use PROC FREQ.
To explore numerical variables, use PROC UNIVARIATE/MEANS/SUMMARY

Print will display the results.

Fastest way to answer the question - try each one.