topic proc tabulate: keep leading zeros in excel in ODS and Base Reporting

proc tabulate: keep leading zeros in excel

ciro — Thu, 22 Sep 2011 15:06:20 GMT

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 — Thu, 22 Sep 2011 15:19:08 GMT

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 — Thu, 22 Sep 2011 15:36:03 GMT

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 — Thu, 22 Sep 2011 15:40:09 GMT

ciro — Thu, 22 Sep 2011 16:11:17 GMT

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