i would like to create a spreadsheet that has a column that acts as a drop down selection value (for example: States). Users would be able to click on the drop down menu, select the state they want and that would populate the cell in the spreadsheet.
Currently I use autofilter which does give the dropdown capability, but also requires that each row of my spreadsheet already have a value (one of the states)...
has anyone done this? is it possible to have autofilter variable contain a list of states but not actually fill the cell until the user selects one of the values?
here is my code (using a format to try to blank out values for state in each row--doesn't work)
proc format ;
value $vickie
low - high = '';
run;
**This is from SAS NOTE 38195: Apply filters to columns in the output created with the ExcelXP destination";
ods listing close;
*ods tagsets.excelxp file='filters.xls' style=statistical
options(autofilter='all');
ods tagsets.excelxp file='filters.xls' style=statistical
options(autofilter='4' sheet_name='Visit 1' absolute_column_width='15' Frozen_rowheaders='1' FROZEN_HEADERS='1' );
proc print data=&xlsname noobs;
var Name type length state;
format state $vickie.;
run;
ods tagsets.excelxp close;
ods listing;
run;
... View more