I'm working with a dataset where the records are births in a year - one birth per child born. I need to get counts of mothers - obviously one mother could have, say, up to 4 births records (in the case of quads). [Lets not worry about mothers who gave birth twice in one year - 9-12 months apart.] I can countthe mothers by using PROC FREQ on the variable that gives plurality of birth (coded as '1' for singletons, '2' for twins, 3 for triplets etc). By this method the number of mothers=(frequency count of singletons)+(frequency count of twins/2)+(frequency count of triplets/3)+etc. Ive been doing this on my calculator from the PROC FREQ output. But I'd love to be able to do this in SAS itself. Any ideas?
New, Used, Demo, Dealer or Private? Find it at CarPoint.com.au