proc tabulate: keep leading zeros in excel

[ciro]

xcen > it

Hello everybody,

I have to send some output to excel with a string with leading zeros through ods tagsets.excelxp.

In Proc print I just use

proc print data=x ;

var stringwithzeros /style=[tagattr="000000000000"];

run;

but I cannot find a way to do it in a proc freq or proc tabulate.

for instance how can I do it in code like this;

proc tabulate data=x ;

class stringwithzeros ;

tables stringwithzeros all, colpctn;

run;

thank you very much in advance

ciro

[art297]

Can you accomplish what you want by adding a format statement using the z format?  e.g.,

proc tabulate data=sashelp.class ;

  keylabel n='No.' all='Total' ;

  class age sex ;

  format age z10.;

  table (age all)*f=3. , sex* pctn<age all>*f=4. ;

run;

[ciro]

xcen > it

thank you for the quick reply. the problem is the variable I'm tryng to export is character with all the leading zeros.

It is just the passage to excel that drop them down

[art297]

Take a look at: http://support.sas.com/rnd/papers/sugi29/ExcelXML.pdf

[ciro · Accepted solution]

xcen > it

thank you again art for the reference.

the solution should be this:

proc tabulate data=x ;

class stringwithzeros ;

classlev stringwithzeros /style=[tagattr="000000000000"];

tables stringwithzeros all, colpctn;

run;

thanks to cinthia for the "colorful" post at

http://communities.sas.com/message/36683#36683