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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.