Dear SAS users! I am hoping to get some help with the following problem and any advice/help is much appreciated! I have retrieved price and return index data (so 2 variables) from datastream in excel format and I want to make it into a long form in SAS. As you can see from my attachement, my data currently looks like this (also attached) However, I want to make it into a long form with each row representing one firm date. So something like Company Date Price Return Index A 1 x x A 2 x x B 1 x x An additional problem that I encounter some of the excel cells are marked "NA", would this cause a problem as the "NA"s will cause SAS to recognize variables as character instead of numeric? As there a way to mark the "NA"s just as missing data? I think I can do it in excel but hoping if I can solve all the problems in SAS too. Any help or code is very much appreciated! Thank you!
... View more