topic Re: tagsets ods and excel file creation in ODS and Base Reporting

tagsets ods and excel file creation

vandhan — Wed, 02 Mar 2016 11:47:19 GMT

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.

(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.

Re: tagsets ods and excel file creation

Reeza — Wed, 02 Mar 2016 11:48:38 GMT

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

Re: tagsets ods and excel file creation

vandhan — Wed, 02 Mar 2016 11:51:34 GMT

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. -##

Re: tagsets ods and excel file creation

RW9 — Wed, 02 Mar 2016 12:51:28 GMT

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;

Re: tagsets ods and excel file creation

Cynthia_sas — Thu, 03 Mar 2016 02:59:52 GMT

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;

Re: tagsets ods and excel file creation

Ksharp — Thu, 03 Mar 2016 03:07:15 GMT

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;