Hi everyone,    I am trying to transform data into panel data to perform an analysis.  I have data as "Have" and need to have "Want"   how would I do this in easy step?   "Have" Date amazon walmart 1/1/2018          1,376             854 2/1/2018          1,283          7,496 3/1/2018             792          2,258   "Want" Date Client value 1/1/2018 amazon          1,376 2/1/2018 amazon          1,283 3/1/2018 amazon             792 1/1/2018 walmart             854 2/1/2018 walmart          7,496 3/1/2018 walmart          2,258 ... View more

Hi everyone,    I have dataset in excel I would like to feed into SAS.  in order to perform analysis, I need to transpose data.    I have attached sample data with "Have" and "Want" tab.   Question #1, so I have Date in header in "Have" sheet, that I want to transpose and get something like "Want". its simple transpose in Excel, but got confused since Date in "Have" are considered as header when imported into SAS.   thank you ladies and gentlemen in advance... ... View more