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.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.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.

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
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
  • 250 views
  • 1 like
  • 3 in conversation