tagsets ods and excel file creation

[vandhan]

Hi,

i have a varible in dataset named "name"

I'm listing name variable in excel file.

name

abc

bca

cbd

NOw I want to supress variable in excel file.

like 

(name) name should be supressd and values should be printed as same in dataset.

please help..

I have given black label in proc print. but im getting variable name in colum of excel file.

[Reeza]

You can use a format, but I don't understand your requirement for suppression. Can you show an example?

[vandhan]

dataset look like:


name

abc
cba
xyz




excel file


(blanck column name)
abc
cba
xyz



but currently I'm getting as it is in dataset.

name
abc
cba
xyz

when i apply black label for this 'name' variable .. im getting variable
name in column of excel.

##- Please type your reply above this line. Simple formatting, no
attachments. -##

[RW9]

Something like:

ods tagsets.excelxp file="s:\temp\rob\temp.xml";
data a;
  name="abc"; output;
  name="def"; output;
run;
proc report data=a nowd;
  columns name;
  define name / " ";
run;
ods tagsets.excelxp close;

[Cynthia_sas]

You can also use the NOHEADER option in PROC REPORT to do the same thing.
cynthia

proc report data=a nowd noheader;
columns name;
run;

[Ksharp · Accepted solution]

proc export data=sashelp.class outfile='/folders/myfolders/adae.xls' dbms=xls replace; putnames=no; run; If you are using PROC REPORT, you can use : proc report data=sashelp.class nowd noheader;