Desktop productivity for business analysts and programmers

Manual Input - Avoiding Excel

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

Manual Input - Avoiding Excel

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


Accepted Solutions
Solution
‎08-25-2014 02:07 PM
Valued Guide
Posts: 3,206

Re: Manual Input - Avoiding Excel

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


.

---->-- ja karman --<-----

View solution in original post


All Replies
Valued Guide
Posts: 3,206

Re: Manual Input - Avoiding Excel

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?

---->-- ja karman --<-----
Occasional Contributor
Posts: 8

Re: Manual Input - Avoiding Excel

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.

Occasional Contributor
Posts: 8

Re: Manual Input - Avoiding Excel

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

Solution
‎08-25-2014 02:07 PM
Valued Guide
Posts: 3,206

Re: Manual Input - Avoiding Excel

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


.

---->-- ja karman --<-----
Occasional Contributor
Posts: 8

Re: Manual Input - Avoiding Excel

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 349 views
  • 0 likes
  • 2 in conversation