I apologize in advance if this area is not the right one.
We have a project where the customer want to see a report by selecting a choice through combo-box or data input.
The question is: is it necessairy to develop a mask of multiple choice/data input in Java server pages, or SAS (which solution?) has a native function that implement the needed functionality?
Waiting for a kind feedback,
i'm available for clarification or further question
So many choices for ways to do what you want. The answer really depends on the software that is available to you.
In Base SAS, you could develop a SAS Macro program with parameters and the user would only have to change the parameters to run and submit the program. (This would fall more into the category of the user supplying data input, in the form of a program call...something like:
At any rate, without knowing what SAS software you have available to use, it's very hard to point you to starting information. The simple answer to your question is ... yes, it's possible to give a user a report based on choices they make through some kind of combo-box or data input. Your choices run from the very simple code-based methods to much more complex methods. Perhaps your best bet is to work with your SAS Sales Representative or SAS Consulting for a design based on what software and programming expertise you or the customer has available.
Hi Cynthia, and thanks very much for the quick and detailed answer.
Regarding the software SAS available for the above project, the products in use are:
SAS Enterprise BI Server, including:
• SAS Table Server
SAS Enterprise Guide
SAS/ACCESS Interface to ODBC
SAS/ACCESS Interface to Oracle
I can add further information and question:
- the reports/OLAP cube we need to develop are supposed to be published on a web link (at the moment, not the SAS Portal)
- do you think the customized filters for a multiple choice, after which a static/dynamic report has to be visualized , need a Java develop on the custom mask to be realized, or combo-box and button choice can also be developed in EG for example?
I have trouble importing Box () delimited text file from mainframe into SAS. The Problem here is DSD is not recognizing the Box delimiters and all the variables are going into wrong containers. I can not use pointers or fixed length or mixed input to read the file. This is very large flat file and I have enclosed the flat file sample data to look at and import into SAS, some reason Box delimiters are not appearing in the email test, in that case you replace the '+' into box delimiters.
I have also given the sample code to import the file.
Best to start a NEW POST rather than piggyback on someone else's post in the future.
And, as I replied on sas-l @ ittoolbox: you will be best served by sharing the SAS-generated (expanded) log information (COPY/PASTE in a post reply) with a PUTLOG _ALL_; to show the SAS-generated variable values as well as the input record.
Also, there is possibly a translation performed between the EBCDIC mainframe and the ASCII-based OS platform, contributing to this issue.
Suggestion: start out by capturing the SAS-generated DATA step code (from PROC IMPORT), make a change to add the PUTLOG _ALL_;, rerun the SAS program code, and inspect the output, and then post to a new thread with your challenge
A Scott said, it is bad to piggyback on someone else's post. If this reply doesn't suit, please start a new post.
"Square box" delimiters don't exist, or rather could be anything. Find out the character code(s) on the platform reading the data. The hex code I got from your post is 1C. So replace
DELIMITER = ''
DELIMITER = '1C'x