The SAS Output Delivery System and reporting techniques

tagsets.excelxp - Excel data validation rule

Reply
New Contributor
Posts: 2

tagsets.excelxp - Excel data validation rule


Hello,

We use SAS 9.3,

A stored process created in SAS Management Console written  in Base SAS generates an xml file using proc report and options listed below:

%let
_odsdest = tagsets.excelxp
options( autofilter='all'

embedded_titles='yes'

embedded_footnotes='yes'
auto_subtotals='yes'
                 
sheet_label="&FILENAME1"

orientation='landscape'                 
pages_fitWidth='1'

pages_fitHeight='50'

frozen_headers  ='3' );

        

Is it possible to add an option /additional code to create an equivalent of the Excel data validation rule to make sure that users enter
certain values into a cell e.g. A,B,C from a lookup table or a hardcoded list ?

    

Thank you for any help you can provide,

Ask a Question
Discussion stats
  • 0 replies
  • 436 views
  • 0 likes
  • 1 in conversation