many thanks, I needed that pointer.
After downloading and running that proc template with the "Excel XP tagset (SAS 9.1.3, v1.37, 05/31/06)", the 16-digit character value successfully surfaces in excel.
How about 16 numeric digits?
I tried this code :
ods tagsets.excelxp file="temp2.xls" ;
proc print data= two;
var x / style(data)={tagattr="format:@"};
var n / style(data)={tagattr="Format:0"} ;
format n z16. ;
run;
ods tagsets.excelxp close;
%sysexec "temp2.xls";
and excel shows
Obs x n
1 12345678912345678 12345678912300000
Clearly somewhere, 12 sig. digits is assumed.
With no more success, I also tried
ods tagsets.excelxp file="temp4.xls" options(Numeric_Test_Format='16.' );
I know there are many things I'm missing here.
What's the magic that allows all 16 digits through ?
Peter