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
The only name is by supporting is dynamic prompts. I see that available with eguide 5.1. And is part using SAS metadata (9.3). http://support.sas.com/resources/papers/proceedings10/041-2010.pdf
.
Even without sas-metadata you can use promtps. They are stored in the egp project. In fact popping up and using them create a sas-macro.
You can use Eguide tor create/edit data/ Unlock the table for editing and change/add colmuns. You can put constraints and formats on it.
With splitting it in several nodes you should reach a lot. Where are exactly the problems wiht prpmpts and table-edits?
The tutorials I've read on prompts are geared toward setting them up to use arbitrary values - values independent of the rest of the form like "year" or "gender" or something.
I need a user to be able to select multiple values from a series of lists that change with every analysis. In the attached example, there will often by 40 or so columns in the "Ratio Choices" table, with 10 or so choices in each column. I need a user to be able to select 1 choice from the 10 for each column, when all 10 choices are always different.
In excel, this would simply mean copying and pasting a selected value down from the row above it, or potentially having a drop-down of the names of the ratio selction types, then using a vlookup to find that associated numeric value. I can't figure out any of this functionality in SAS
The only name is by supporting is dynamic prompts. I see that available with eguide 5.1. And is part using SAS metadata (9.3). http://support.sas.com/resources/papers/proceedings10/041-2010.pdf
.
Thanks! I still am not sure how I'm going to display enough data within the prompt to give users enough information to perform the analysis, but I'll give it a shot.
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.