proc transpose data=PrdSummary out=wide_proc(drop=_Name_ _label_) prefix=Act_; by Product; id Date; format Date yymm7.; var Actual; run; proc print data=wide_proc; id Product; title1 "Rotated results for all years"; run;