Hi, This is a sas data set so the data is in SAS format. I've put formats over the top of it. The picture in the message is just an example rather than the exact format. My dates show in sas as 13W14 for example. Ages are characters strings. I would ideally like to have a list that I can lookup into so that long form that you describe would be ideal (there will be many variables included). However, I don't know how to get sas to generate this % of the first variable. I've been playing around with proc freq and the outpct but once I get to 4 variables, it stops working. The overall percent figure generated is inaccurate. My variables are A, B C, D, E, I need to know what percentage each element of E is of element A. A in this instance is the week number
... View more