Classic problem with proc transpose and mutiple variables seven solutions https://stackoverflow.com/questions/53664307/is-there-a-better-way-to-spread-a-long-table ...

Transposing multiple variables using transpose macro sql arrays proc report. Transposing muliple variables using transpose macro sql arrays proc report Two Solutions 1. SQL arrays 2. proc report 3.

Restriction: You cannot use PROC TRANSPOSE with an ID statement or a BY statement with an engine that supports concurrent access if another user is updating the data set at the same time. Typically, ...