Hello!
I would like to create a drop down for data validation in Excel with Proc Report , something like the picture below, how do I do that?
SAS 9.4, ODS Excel,
The paper is by Chevell Parker. Page 31 mentions that he's using a modification of the ExcelXP tagset, and that an example of the tagset is available in the Resources section of the paper. I assume that's the downloadable file. I haven't used the ExcelXP tagset in a while, so I didn't read all the way through his paper. But now I'm curious about this, so I'll try it out.
That's not ODS Excel - you'll get an XML file instead, you can convert it to XLSX after.
Have you gotten his sample to run? That's where I'd probably start, the code is there to test it.
There is no support for creating "Data Validation" cells in Excel but there are the wishes of many users.
There are, however, alternatives, just as complicated.
Det finns inget support för att skapa "Data Validation" celler i Excel men det finns som önskemål av många användare.
Det finns däremot alternativ, rätt så krångliga.
A modified version of EXCELXP
https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf
Use VBA code and call SAS within Excel.
http://support.sas.com/resources/papers/proceedings13/203-2013.pdf
Det finns inget support för att skapa "Data Validation" celler i Excel men det finns som önskemål av många användare.
Det finns däremot alternativ, rätt så krångliga.
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.