So, that code didn't exactly work for me. I got an error message saying "NOTE: No variables to transpose." But it got me thinking! I added a var statement, which worked to give me the score data as values under the rate columns, but all the information I needed was in the first row per hospital with multiple duplicate rows per hospital_name that had blank rate columns, so I deduplicated rows by only keeping the first occurrence of each hospital. Ultimately, I used this code: proc transpose data=have out=hosp_wide (drop= _name_ ); by name; copy zip; id measure_id; var score; run; data wide_dedup; set hosp_wide; by name; if first.name; run; Thanks! ##- Please type your reply above this line. Simple formatting, no attachments. -## -- E-Mail to and from me, in connection with the transaction of public business, is subject to the Wyoming Public Records Act and may be disclosed to third parties.
... View more