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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.