Dears By using ODS Excel, the below code is giving 2 different results for year5. date format. Proc print is giving the right results , while for proc tabulate is not the case. To simplify the example, I have used a data set with 1 observation only. Any Idea how it can be resolved without creating new variable for year. ALi
data x;
datex='12jun18'd;
run;
ods EXCEL file="d:\temp\ODSExcel.XLSX" options(sheet_interval="NONE"
EMBEDDED_TITLES='ON');
proc print data=x noobs;
format datex year5.;
title "Proc Print";
run;
proc tabulate data=x;
table datex, n;
class datex;
format datex year5.;
Title "Proc Tabulate";
run;
ods excel close;
... View more