The SAS Output Delivery System and reporting techniques

tagsets ods and excel file creation

Accepted Solution Solved
Reply
Contributor
Posts: 31
Accepted Solution

tagsets ods and excel file creation

[ Edited ]

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.


Accepted Solutions
Solution
‎03-08-2016 04:36 AM
Grand Advisor
Posts: 9,315

Re: tagsets ods and excel file creation

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;

View solution in original post


All Replies
Grand Advisor
Posts: 16,304

Re: tagsets ods and excel file creation

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

Contributor
Posts: 31

Re: tagsets ods and excel file creation

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. -##
Esteemed Advisor
Esteemed Advisor
Posts: 6,685

Re: tagsets ods and excel file creation

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;
SAS Super FREQ
Posts: 8,642

Re: tagsets ods and excel file creation

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;
Solution
‎03-08-2016 04:36 AM
Grand Advisor
Posts: 9,315

Re: tagsets ods and excel file creation

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;
Post a Question
Discussion Stats
  • 5 replies
  • 452 views
  • 2 likes
  • 5 in conversation