BookmarkSubscribeRSS Feed
Sivan
Calcite | Level 5
Hi,
Is it possible to remove observations from an output created by a proc tabulate, by applying a condition on one of the aggrigative variables I've created during the proc tabulate?
for example, lets asy I am creating a variable that displays number of customers, and I want to remove all observations with less then 100 customers.

Thanks,
Sivan.
1 REPLY 1
Cynthia_sas
SAS Super FREQ
No, PROC TABULATE does not let you act on summarized statistics. You'll have to "pre-summarize" the data -- with PROC MEANS, PROC SQL, PROC REPORT, or even PROC TABULATE -- somehow to determine which rows are non-conforming. At that point, you can either eliminate the group to which the rows belong -- before your TABULATE -- or adjust the values for purposes of the report (like lump a bunch of small categories into an "OTHER" category). (If your elimination criteria is based on a simple count of obs for each group/category, you could even get that info out of PROC FREQ.)

cynthia

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 887 views
  • 0 likes
  • 2 in conversation