Re: how to transpose data to get output

You appear to have the code nearly there, what is it you cannot do? You will just need a datastep which process the means output into the format you want, note that variables a b and c in teh output dataset would need to be character and the numerics from means put to character values as min, max is not a numeric value. As for actually doing this for you, this is not a contract board just a Q&A.

Re: how to transpose data to get output

You have a number of issues with this code, starting with typos (e.g. "visi" for "visit,", etc.). Once you resolve those, the main complication is really your creation of the range value, which will likely result in mixed types in your transpose. How strict is your requirement to have the range rather than the min and max fields in the output?