Hello, I have some data from groups of people spending money at a number of stores in a mall. I'm trying to calculate the percentage of people who spent at least 25 or more and at least 30 or more using proc report. I've attached the sas file and some of my code so far, but it is pretty basic. I assume I need to use sum and pctsum, but I don't how to incorporate them into the code correctly. Any help is much appreciated proc report data=mydata.house; column id spent; define id / display; define spent / display; title1 'Expenditure per group'; run;
... View more