Data Validation Lists in SAS ODS tagsets.excelxp / proc report / proc template
Am hoping that someone might point me in the right direction.
I am creating a spreadsheet using some elements of proc template and outputting it with a proc report within an ods tagsets.excelxp. This spreadsheet will be sent out in order to collect some data. I would like to limited the data collection entries to Yes or No.
Is it possible to create a data validation list just like Excel as per the image below (a drop down menu with limited values)?
I have checked the ods tagsets.excelxp options but nothing points to this. Would I need to create this using Proc Template? If so, is there any code I could look at ?
Thanks
Rbrt
TAGSETS.EXCELXP does not support data validation directly, as far as I know; see for example this question over on SAS Communities.
Chevelle Parker's paper for SUGI 28, Generating Custom Excel Spreadsheets Using ODS, provides a way to do it - but not using tagsets.excelxp, rather by writing a new tagset. I don't know why this option wasn't included in tagsets.excelxp; perhaps it has some issues, or the method shown here isn't consistent with how tagsets.excelxp was written. It might be worth considering customizing tagsets.excelxp to include this, though if that's your first tagset it's a very difficult one to wrap your head around as it has a lot of parts.
- Run string as query through macro - error parameters must precede keyword
- SAS connecting to another server is randomly blocked with an error. Can I tell SAS to repeat until successful?
- SAS calling external process with network path
- Adding Comparison Annotations to Boxplots
- Retrieving deleted observations in SAS
- Flag duplicate observations in SAS
- How to transpose in SAS EG when there are multiple columns of differing data types (numeric, alphanumeric, & character)?
- Update an Index variable based of the values it takes
- SAS Rename External Files
- Convert yyyymm into sas date9 and split
- Combine multiple observations into one SAS
- SAS read table with special character in name passed through macro parameter
- How to create a column with quantiles ranked groups in SAS using weight?
- How to read JMP *.jmp file with Python Pandas into Pandas dataframe
- SAS EG: Scheduled job CLIENTUSERID not resolved
- Creating a Vertical Calendar
- Trying to calculate time between subsequent appointments in SAS
- SAS ODS Powerpoint - Forcing proc sql label text to stay on one line
- Using and Creating SAS Macro in the same step
- DROP TABLE IF EXISTS equivalent for TERADATA from SAS
- Compare two variables between two datasets and create a new variable based on the comparison
- How to calculate difference between dates by group in SAS
- Update actual records of a variable based on the date before
- How to convert Oracle/Java datetime in long type
- Exporting SAS dataset to CSV, introducing blank lines in next row, which makes as if record is missing
- How to create a swimmer plot with two independent axises which the primary one representing follow-up length, while the secondary being calendar time
- how to separate names into 2 parts?
- SAS - Modifying key-value pairs in a macro variable
- SAS proc sql: select for each value the right interval
- SAS largest correlation not equal to 1