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.
You can use a format, but I don't understand your requirement for suppression. Can you show an example?
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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.