I want to use proc tabluate to make a cross tab of bad rates using a variable bad that is 1 if the observation is bad and 0 otherwise. My sample code is attached. As I see the main issue, I want to treat bad as a class and analysis variable in order to get the sum of the bads and divide by the number of observations. I know I can't do that. I'm sure there is a very elegant way to do this. Many thanks for people's time!
Teresa
You are not the first person trying to do this the hard way. With a 0/1 variable, make it an analysis variable and calculate the mean. That's the same as the sum of the "bads" divided by the number of observations.
Good luck.
Adding to Astounding note, and N gives number of records considered and Sum yields number of bad. I use this approach a lot as my customers will almost always ask something like "How many bad?" or "How many records?" when seeing 0 or 100 percent, or some value above/below a theshold of interest, for some group. It heads off follow-up request to provide all 3 up front.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.