Dear All Could someone help me with the following problem? It is urgent! Thanks a lot! I have retrieved data about singapore equities from 1990 to 2012 from datastream, which is exported into excel files. The format of the data, however, is not compatible with SAS. For instance, from datastream, date1 date2 date3 comA p p p comB p p p comC p p p However, i understand that for sas, it need to be transformed to Company Date Price A 1 p A 2 p . . . C 3 p How could i reshape the data? As I have large number of companeis and dates in my dataset, I cant really mannually change the format. Is there any function in SAS that could help the reshaping? Or could someone help with an excel marco that could fulfill the purpose? Thank you so much! Best regards Chloe
... View more