BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi! I think this macro is extremely useful! It produces summary statistics (mean/median/min/max/counts) and p-values between two groups of a class variable.

My question for anyone who has used it is the following:

What if there is a subgroup analysis someone wants to do? I see this is awesome for getting descriptive statistics including p-values for a class variable with varying levels. How about if I want one main class variable (like Case and Control) and subgroups (like Old/Young)? Does this macro support this type of analysis?

Thank you so very much!
Monica

The macro can be found:
http://mayoresearch.mayo.edu/mayo/research/biostat/upload/summary.sas
1 REPLY 1
Doc_Duke
Rhodochrosite | Level 12
Not directly. The documentation specifies that you can only have a single class variable.

You can do it by creating a new class variable that concatenates the group and subgroup.

You may also be able to do it with two calls to the macro, using something like
DATA=mydata(WHERE=(main='Case'),

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register 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
  • 1 reply
  • 1889 views
  • 0 likes
  • 2 in conversation