Sorry for the confusion it was error in my part. let's start fresh. The sample data have 4 variables type, score, A and B. Score is standard score. A and B are raw scores. Am trying to create raw score to standard conversion table by type. I have attached a picture for reference of exactly how I want my report look like. Let's say for example, am required to only report standard scores between 10-20. Scores below 10 will collapsed into a category of "<10" and scores above 20 will collapsed into a category of ">30". Any values associated with these categories will become " x-y" as show in first row of table 1 as "1-3". data sample; input type score A B; cards; 1 0 . . 1 1 . 1 1 2 . 2 1 3 1 . 1 4 . 3 1 5 2 4 1 6 . 5 1 7 . 6 1 8 . . 1 9 3 . 1 10 4 . 1 11 5 . 1 12 6 7 1 13 . 8 1 14 . 9 1 15 . 10 1 16 . . 1 17 . 11 1 18 8 . 1 19 . . 1 20 9 12 1 21 10 13 1 22 . . 1 23 . 15 1 24 . 16 1 25 . . 1 26 11 . 1 27 12 . 1 28 . . 1 29 13 . 1 30 14 . 2 0 . . 2 1 . . 2 2 . 1 2 3 1 2 2 4 . . 2 5 2 . 2 6 . . 2 7 . 3 2 8 3 4 2 9 . 5 2 10 4 . 2 11 5 6 2 12 . 7 2 13 . . 2 14 . 8 2 15 6 . 2 16 7 9 2 17 8 10 2 18 9 11 2 19 . 12 2 20 10 . 2 21 11 . 2 22 . 13 2 23 12 14 2 24 13 15 2 25 14 . 2 26 . . 2 27 . 16 2 28 . . 2 29 . . 2 30 . . ;run;
... View more
