We are attempting to achieve the following and would appreciate it if anyone has any insight into how to implement it. A user can run a list containing several columns, but click on a static email to another in-house email application (I'm assuming pl/sql or something on the back-end of Oracle Web Reports. This application reads the emails out to a .csv file from the report location and sends an email. The email piece is completed. We only need SAS piece. Please see below:
So, the two major points we are needing information about are:
1. Does SAS have a stored procedure to extract certain columns as a .csv file from Web Report Studio as the report is run by the user and to
place the extracted .csv file into the user’s “My Folder?”
2. Is there a stored process that would assist us in using a static link in the report headers, so every report would have this static link
functionality. Below is an example URL:
As far as the static link, we have been able to work that out using a text box and will suffice vs. in the headers. And, yes, we know that you can export to excel and save to .csv; however, the above functionality is used in one of our campuses with Oracle Web Reports, and we would really like to be able to provide this to our SAS users at our site.
Any ideas are most appreciated!
fsu1fan. I have to respond because my son just graduated from FSU. I do not believe I have your solution as I am just a beginner with WRS. I do know that if you can code what you need in BASE SAS, you can 'paste' the code into an Enterprise Guide project. Once you have the BASE code working in EG, you can create a Stored Process from the EG project. WRS can then use your Stored Process. You can code prompts for your Stored Process that will work in WRS.
Go Noles!! So glad to hear from a fellow FSU fan! Small world.
You are right, I will probably need to code something in BASE SAS and then create the stored process, I just need a little guidance as to how to go about it. I have created stored processes, but this one is a little tricky for me since they want this functionality on all of the WRS reports. Not sure if we can pull it off, but I thought maybe someone here might have some insight.
Thanks so much for your help!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.