Hello! MY QUESTION: Is there a user friendly way to have produce a table/form that a user can update, that can then be drawn in as a macro variable? My programs are currently set up in an EG project, with one process flow per analysis. The updateable table would need to be available and easily accessable within the flow, so that updates and peer reviews are easy. NOTE: Often times there are dozens of these judgement selections to be made, and much of the data in the top half of the analysis needs to be visible when selections are being made. Background and Attached example: I've come to a cross-roads regarding an application/report that I'm developing. In order for a user to complete the analysis being set-up by this applicaiton, the user needs to input a judgement selection at 1 and only 1 point in the anaylsis... about halfway through. This information is then used to produce the rest of the report. Up until now I've been trying to have EG create the tables I need, then stack them together in a nice user friendly excel from. I intended the excel form to already contain excel formulae needed to continure doing calculations after the selections have been made (using ODS EXCEL XP). Now I'm wondering, how difficult would it be to somehow have a form (or just a table) within SAS that pops up (or is just nicely saved and prefereably locked so there could be no accidental changes made to the wrong cells) for the user where they can enter these selections which I can then put into macro variables? With those variables, I could much more easily create the rest of the report In SAS and skip Excel entirely. Attached is a simplified example form I threw together in Excel. IF THAT'S TOO SPECIFIC: I could use any links/advice to either: A) User input into SAS tables. or B) Exporting to a Excel form, then bringing user input back into SAS (suited to a production enviroment where I could lock down the format in Excel as much as possible.) Thanks for reading! Kyle
... View more