Thanks in advance for your help. (Using SAS 9.2 ) I'm a fairly new user to SAS and I'm having issues with when exporting my data to excel, the dates which are in the iDATE column do not label in excel, instead the just have a header of _C2_ _C3__C4__C5_ etc. My code is below:
data work.variance (keep = Variance Cust_ID iDATE);
set CUSTIM.AREC;
if Variance < 250;
run;
proc report data=work.variance out = newdata;
column Cust_ID iDATE Variance;
define Cust_ID / group;
define iDATE / across;
define Variance / sum;
run;
Below is what excel shows Thanks FastEddie
... View more
