Hi, I have a column with subjects (called record_id) and a list of variables (called lead_1, lead_2, lead_3 and soforth). For the variable lead_x, its only possible to have the values: 1, 2, 99 or none present. I would like to make groups of subjects and count these groups, according to - how many is presented with a value "1" in all lead_types (from left to right), - how many with the value 2 in all lead_types, - how many is starting with 1 in som lead_types and then changes to lead_2 and vice verca - how many is starting in group 99, changing to 1 and later 2 - and so on for possible variation outcomes In summary I would like the number of subjects in all possible variations. Its only interesting for me, WHEN they change group I tried this (first part to extract the needed information in one set called gr and then proc freq to see the outcomes and number in each group): data gr;
set lead_c;
group = cat(lead_1,lead_2,lead_3,lead_4,lead_5,lead_6,lead_7,lead_8,lead_9,lead_10,lead_11,lead_12,lead_13,lead_14,lead_15);
run;
proc freq data=gr;
tables group;
run; which gives me (part is shown below): Here I would like SAS to read the previous number and only classify the ID when they change number. I think I need som retain statement and a way to imply to ignore, if empty to get free of all those "...." Anyone who can help how to get closer to the solution ?
... View more