BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
SASdevAnneMarie
Rhodochrosite | Level 12

Hello Experts,

 

Is it possible to create the report with proc tabulate only with _numeric_ variables ? I would like have a list of variables at the right.

I would like to use the proc tabulate because I would like to display the formatted statistics values. 

My code is :

proc tabulate data=bdd;
	var _numeric_;
	table var,_numeric_*(N mean std var cv median max min q1 q3);
run;
1 ACCEPTED SOLUTION

Accepted Solutions
yabwon
Amethyst | Level 16

Use Maxim 4.

 

 

proc tabulate data=sashelp.class;
	var _numeric_;
	table _numeric_,(N mean std var cv median max min q1 q3);
run;

yabwon_0-1771323671300.pngyabwon_0-1771323671300.png

Bart

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



View solution in original post

3 REPLIES 3
yabwon
Amethyst | Level 16

Use Maxim 4.

 

 

proc tabulate data=sashelp.class;
	var _numeric_;
	table _numeric_,(N mean std var cv median max min q1 q3);
run;

yabwon_0-1771323671300.pngyabwon_0-1771323671300.png

Bart

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



SASdevAnneMarie
Rhodochrosite | Level 12
Thank you, Bart!
ballardw
Super User

Beware of _numeric_ with data sets containing date, time or datetime values as many statistics won't be very useful for them.

CFC_SAS_Communities_400x225.jpgCFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 568 views
  • 1 like
  • 3 in conversation