About chris_lampron

chris_lampron · ‎01-12-2016

I am currently working on developing a stored process in SAS Enterprise Guide 5.1 on Windows 7 Operating System that allows users to select multiple items from a listbox. Once the values are selected I would like the form to chain to another stored process that will use the values that were selected in the listbox. I am having difficulty creating a variable that contains the values selected by the user. I have used the following code and can get the multiple select to work, but when I print the results, only the first value selected is printed. The code is written in HTML and I am wondering if there is some Javascript that I would need to add in order for the selected values to be brought together into a single variable. <select size=3 id=multilistbox multiple="multiple"> <option value="1">Option 1</option> <option value="2">Option 2</option> <option value="3">Option 3</option> </select> Any help would be appreciated. Thank you.

chris_lampron · ‎01-05-2016

Good morning, I am currently using SAS Enterprise Guide 5.1 on a Windows 7 operating system and I am currently dealing with floating point overflow errors. I am working on a stored process and occassionally encounter floating point overflow errors. I have been looking for a way to end the stored process, or call another stored process, if a floating point overflow error is thrown and display a message that the program failed to complete. I am looking to have something other than the Stored Process Error Log being shown because other people will be using this program in the future. The floating point overflow error is appearing during an iteration of PROC NLIN. proc nlin data=&dataset nohalve maxiter=20000; parms b1=&B1_x b2=&B2_x J=&J_x; model var=b1*(b2+mean)**J; resid=model.var; _weight_=(n-1)/(resid**2); ods exclude all; ods output ParameterEstimates=FINAL_&dataset; run;quit; I'm wondering if there is a way to have the program stop and either print a message on the screen, or call another stored process which, in turn, would display a message the program failed to complete. I have tried using the macro variable &SYSERR, but that doesn't work because the NLIN fails to complete so the &SYSERR can't be checked to see if there were errors. Are there any other methods of error trapping that I could use with NLIN to catch the floating point overflow error and have control on how the error is expressed? Thank you.

chris_lampron · ‎08-26-2015

Good afternoon, I am currently using SAS 9.3 and I have a question about PROC SGPLOT. I am trying to have the yaxis display values from 0 to 10 be increments of 2, followed by a value of 20 and finally a value of 100. I am using the following code: proc sgplot data=test; scatter x=mean y=cv/markerattrs=(symbol=circlefilled); series x=mean y=cv2; yaxis values=(0 to 10 by 2 20 100); run; The output shows 0 to 10, and the 20, but then the 100 is not being displayed on the axis. The rest of the yaxis is blank. To me, it seems that the 100 tick mark is there, it is just off the graph. What I would like to do is compress everything between 10 and 20, then again between 20 and 100 so that I can see the values between 0 and 10 and then the values at 20 and 100 on the yaxis. Using PROC GPLOT, I can use the axis order option and make the changes that I want. However, for this particular program, I am using SGPLOT. The image below shows what a yaxis would look like when I use GPLOT. I saw that in SAS 9.4 there is a yaxis option of RANGES that could be used, but I can't seem to find anything in SAS 9.3. Are there any suggestions on what I could do to resolve this?

chris_lampron · ‎06-29-2015

Good morning forum, I am currently working on a set of chained stored processes (3 in total) in which the first stored process prompts the user to select a file that will be uploaded. The stored process is using HTML forms to display the page and create the buttons and browser to select a file. The form looks like this: data form; format infile $char256.; input; infile=resolve(_infile_); cards; <HTML> <BODY bgcolor="#CAD6DA"> <FORM ACTION="&_URL" method="post" enctype="multipart/form-data"> <INPUT TYPE="HIDDEN" NAME="_program" VALUE="Path to Second Stored Process"> <INPUT TYPE="HIDDEN" NAME="submit" VALUE="submitted"> <table border="0" cellpadding="5"> <tr> <td colspan="2"> <INPUT TYPE="file" NAME="Attach1" /> </td></tr> <tr> <td colspan="2"> <INPUT TYPE="submit" value="Upload"> </td></tr> </table> </FORM> </BODY> </HTML> ; run; data _null_; file _webout; set form; put infile; run; Once the 'Upload' button is selected, a second stored process is called and the selected file (a .xlsx file) is uploaded and proc sgplot is used to plot the data for visual representation of the uploaded file. What I would like to happen is have 2 buttons on the second stored process. One will be a 'Go Back' button if the data doesn't look right (maybe the wrong file was uploaded, format of file is incorrect, etc.) and allow the user to either fix the file or upload a different one. The second button would be a 'Continue' button where a third stored process would be called. The 'Go Back' button works fine to send the user back to the first stored process and allow for them to upload the file again. The 'Continue' button, bringing the user to the third stored process is where my problem is. In the third stored process, I would like the same uploaded file from the second stored process to be called and used in data steps. Right now on the third stored process, I am having some difficulties If i try to upload the file again, I get the following error: ERROR: Unable to import, please specify a DATAFILE. If I don't try to upload the file and just call the data set, I get the following error: ERROR: WORK.XXXX.DATA does not exist. The import code I am using is: proc import out=excel file="%sysfunc(pathname(&_webin_fileref))" dbms=xlsx replace; run; Does anyone have any suggestions on how to either bring them dataset from the second stored process into the third, or be able to upload the file selected in the first stored process? Thank you. --Chris.

chris_lampron · ‎03-26-2015

I am currently using SAS Enterprise Guide 5.1 where I have a stored process that is being executed through Internet Explorer 10. I have multiple datasets being created and I was wondering if it is possible to have the user choose where to download two datasets. The code below is what I am using to have the user select a directory and save an .xls copy of the dataset. This code works fine for selecting one dataset and saving it on the users local machine. %global _ODSDEST _ODSSTYLE _ODSOPTIONS; *ProcessBody; %macro print; %local OLD_HEADER OUTPUT_FORMAT; %let OUTPUT_FORMAT = &_ODSDEST; %let _ODSDEST = tagsets.ExcelXP; %let OUTPUT_FORMAT = HTML; %let OLD_HEADER = %sysfunc(stpsrv_header(Content-type,application/vnd.ms-excel)); %STPBEGIN; proc print data=wr_stat;run; %STPEND; %mend print; %print; I tried using a sleep function and then printing another dataset within the %STPBEGIN/END, but I'm not sure if what I'm doing is incorrect or if it is even possible to do. The program runs and allows the user to select where to save the file, but it will only do it for the second dataset in the second proc print. %global _ODSDEST _ODSSTYLE _ODSOPTIONS; *ProcessBody; %macro print; %local OLD_HEADER OUTPUT_FORMAT; %let OUTPUT_FORMAT = &_ODSDEST; %let _ODSDEST = tagsets.ExcelXP; %let OUTPUT_FORMAT = HTML; %let OLD_HEADER = %sysfunc(stpsrv_header(Content-type,application/vnd.ms-excel)); %STPBEGIN; proc print data=wr_stat;run; data _null_; slept =sleep(20); run; proc print wr_stat2;run; %STPEND; %mend print; %print; Do I need to edit my syntax or is there a completely different method to doing this?

chris_lampron · ‎03-24-2015

Thank you for the suggestion. I was missing the <tr>. That seemed to get the %put &opt1; to work correctly. I have been running this stored process in IE 10. I tried to build on the simple stored process and check to see if the checkboxes were checked of not. I did some conditional if/then statements that if the variable did not equal 'x' then call it something else. If it was checked, and did have a value of 'x', use it in the %put statement. This works fine when the box is checked, if the box is unchecked, I get the error message: WARNING: Apparent symbolic reference Opt2 not resolved. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &Opt2 ^='x' I have tried putting the single quotes around the 'x' as well as trying to use %bquote, but I can't seem to perform a check to see if the check box was checked by the user or not. Any suggestions?

chris_lampron · ‎03-23-2015

I am building a stored process which begins with a custom HTML form where the user will select options with check boxes. After the check boxes are selected, or not selected, the user will hit "Submit" and the program will continue onto another program called "TestingFile." The HTML code for the check boxes is: <FORM ACTION="&_URL" method="post" enctype="multipart/form-data"> <INPUT TYPE="HIDDEN" NAME="_program" VALUE="/Shared Data/SAS Testing/TestingFile"> <INPUT TYPE="HIDDEN" NAME="submit" VALUE="submitted"> <td><p class="new2"><u><i>Sample Selection:</u></i></td> <td><p class="portal">Option1</p></td> <td><INPUT TYPE=CheckBox name="Opt1" Value="x"></td> <td><p class="portal">Option2</p></td> <td><INPUT TYPE=CheckBox name="Opt2" Value="x"></td> <td><p class="portal">Option3</p></td> <td><INPUT TYPE=CheckBox name="Opt3" Value="x"></td> <td><p class="portal">Options4</p></td> <td><INPUT TYPE=CheckBox name="Opt4" Value="x"></td> </tr> What I want to do is have the selections made by the user carry over to the program being called when the user selects "Submit". Do I need any other code to have the values of the options carried over, or will they carry over automatically? In my TestingFile program, which is called after the HTML form, I try to display what the values of the options are (whether or not they selected the options) but I can't seem to get any results. I tried to put the variables into a table and print the table, but the table comes out empty. I'm just wondering if what I am doing is correct or if I am missing any information. Thank you.

chris_lampron · ‎03-17-2015

Thank you Cyntia. I will look into that documentation. I am running the stored process using a web client (sorry for leaving that part out). I will see if I can get in touch with the admin and see if its possible to give me a folder on the server and try that method to download the file.

chris_lampron · ‎03-16-2015

The error message that I receive when I use my local machine pathway is: ERROR: Insufficient authorization to access /sas/sas93/compute_config/Lev1/SASApp/C:\users\username\desktop\test.pdf. I've come across some articles about some customs tasks that can be installed to export data to your local machine, but this stored process is going to eventually be used by many people and I do not want to have each user install the .dll files in order to run the custom task.

chris_lampron · ‎03-16-2015

Would the logic of the export be in any way similar to that of the export wizard in enterprise guide? If I am connected to the SAS server and I export a dataset in my process flow, not within a stored process, I can easily export the file to my desktop.

chris_lampron · ‎03-16-2015

I am running on a SAS server. I was thinking that it had to be something that server could see. I was able to upload files to server from my desktop using a custom HTML form, so I have been trying to see if it is possible to export a file to my desktop. When I'm using the CSVALL, the output is being opened in Excel automatically at the end of the stored process.

chris_lampron · ‎03-16-2015

The problem that I have when using the data step method is that I get an error message that I can't access the output pathway. I was setting my pathway to "C:\users\username\desktop\testing.txt" and that is what seemed to trigger the error.

chris_lampron · ‎03-16-2015

Hello All. I am currently working SAS Enterprise Guide 5.1 and I am trying to have my stored process automatically download a dataset to my local hard drive (just trying to set the pathway to my desktop to see if it will work). I have been trying all formats (.xls, .rtf, .pdf) and haven't been able to find a way to get it to work. I have been able to use ODS TAGSETS to have my dataset export to Excel and open up in Excel. However, I would ideally like it if the file would be exported to my computer and then I could open it whenever I chose to. %let _ODSDEST=TAGSETS.csvall; %stpbegin; ods tagsets.csvall options(sheet_name="Testing"); Proc Print data=work.testing; run; ods tagsets.csvall close; %stpend; In SAS 9.3 I have exported datasets to .txt files using the following code: Data _null_; set work.testing; File "pathway\file.txt"; run; Is there anyway in SAS EG 5.1 to export my dataset to my local hard drive and not automatically open it? Thank you. --Chris.

chris_lampron · ‎03-06-2015

Thank you gergely.batho, I was able to use the selection groups to get the prompt window to function properly.

chris_lampron · ‎03-02-2015

I wasn't thinking cascading prompts. Those require dependency's on previous prompts. Also, they require a dynamic list. The prompts that I currently have in my stored process are all static. What I was wondering is, when you run the stored process, the prompt window appears. The user will then fill in all of the prompts and click 'Run' at the bottom. Based on the choices here, a second prompt window would appear with additional prompts for the user to input before the program runs. The reason I am asking about this is because there are a few prompts that I was looking to suppress or have on a second window based on the first and second prompt selection. Depending on what the user chooses, a few prompts may not be required. I have been looking around online for some time now, and the only option that I have to go with is make certain prompts not required to run the program. So instead of not suppressing the prompt, the user could leave it blank. But it would look cleaner if the prompt was just hidden or grayed out.

Online Status	Offline
Date Last Visited	‎09-14-2018 10:28 AM

Determine Values Selected In Multiple Listbox

End Program After Floating Point Overflow Error

SAS 9.3 PROC SGPLOT yaxis values

Uploading .XLSX File In Multiple Stored Processes

Is It Possible To Export 2 Datasets Using Tagsets.ExcelXP?

Re: Using Custom HTML Form In Stored Process

Using Custom HTML Form In Stored Process

Re: SAS EG 5.1 Stored Process To Export/Download Dataset to .TXT Forma...

Re: SAS EG 5.1 Stored Process To Export/Download Dataset to .TXT Forma...

Re: SAS EG 5.1 Stored Process To Export/Download Dataset to .TXT Forma...

Re: End Program After Floating Point Overflow Error

Re: End Program After Floating Point Overflow Error

Re: Using Custom HTML Form In Stored Process

Determine Values Selected In Multiple Listbox

End Program After Floating Point Overflow Error

SAS 9.3 PROC SGPLOT yaxis values

Uploading .XLSX File In Multiple Stored Processes

Is It Possible To Export 2 Datasets Using Tagsets.ExcelXP?

Re: Using Custom HTML Form In Stored Process

Using Custom HTML Form In Stored Process

Re: SAS EG 5.1 Stored Process To Export/Download Dataset to .TXT Forma...

Re: SAS EG 5.1 Stored Process To Export/Download Dataset to .TXT Forma...

Re: SAS EG 5.1 Stored Process To Export/Download Dataset to .TXT Forma...

Re: SAS EG 5.1 Stored Process To Export/Download Dataset to .TXT Forma...

Re: SAS EG 5.1 Stored Process To Export/Download Dataset to .TXT Forma...

SAS EG 5.1 Stored Process To Export/Download Dataset to .TXT Format

Re: "Daisy Chain" Prompt Windows??

Re: "Daisy Chain" Prompt Windows??