Though I have shown an identical portfolio for the two IDs, it is generally different for different individuals. I have about 23 asset classes and over 72,000 observations. Another thing is that the IDs are not continuous numbers. So I have IDs that go 1,2,6,14 etc.
Any suggestions? I have been struggling with this.
SAS PROC TRANSPOSE can address this data transposing (vertical to horizontal) requirement. Have a look at the SAS documentation and also there are technical/conference papers on the topic at the SAS support http://support.sas.com/ website.