About AshleyM

Ksharp · ‎05-14-2013

or merge it to make it complete. proc freq data = test noprint; tables wsb6 / out = test1(drop = percent); run; data test2; retain count 0; do wsb6 = 1 to 9; output; end; run; data want; merge test2 test1 ; by wsb6; run; Ksharp

bwasicak · ‎02-28-2013

Ashley, it would be helpful to know how you are reading in the text file. Can you do a simple length statement on both 1A and 1B then compare the lengths? data short(keep=1A) long(keep=1B); set beginning; a=length(1A); b=length(1B); if (a < b) or (a<200) then output short; if (b > a) or (b>200) then output long; run;

AshleyM · ‎02-27-2013

Perfect. Thank you!

Linlin · ‎02-14-2013

data temp; set testing.cr96to2004(where=(tapeyear>2002)) testing.cr2005on; run;

Haikuo · ‎03-29-2012

DOW seems pretty handy for this case: data dataset1; input var1 var2 var3 var4 var5; datalines; 1 3 65 63 77 1 2 65 63 66 2 2 2 2 2 2 2 2 2 2 ; proc sort data=dataset1; by var1 var2 var3 var4 var5; run; data want; do sum=1 by 1 until (last.var5); set dataset1; by var1-var5; end; run; proc print;run; Regards, Haikuo

NN · ‎03-09-2012

Hi, I think currently when defining your prompt for VAR1 you are selecting your promt type as TEXT i.e why you are unable yo view this variable in your dropdown list. Try chaging the PROMPT TYPE to NUMERIC . you should be able to view your VAR1..

AshleyM · ‎03-01-2012

Thank you Barry. I'm still not sure what APPLY does, but I found out that Management Console 9.3 does not default to include that on the prompt page, whereas 9.2 does default to that APPLY button.

Cynthia_sas · ‎03-01-2012

Hi: I'm just curious. Where are you actually running the example? I would expect this to work in an interactive session of SAS, but fail in a batch submission or remote submit. Since your stored process code is submitted in batch mode and since your EG code is submitted in batch mode, I would expect eventual issues with the use of %window once you get done testing in interactive SAS: http://support.sas.com/kb/10/201.html cynthia

Cynthia_sas · ‎02-27-2012

Hi: This is really best posted in the Stored Process forum, which I see that you've done. cynthia

AshleyM · ‎02-27-2012

Thought I'd share the answer with you all. You can determine the URL by using the following approach. (1) Invoke the SAS Stored Process Web Application using "_action=tree" http://your.server:8080/SASStoredProcess/do?_action=tree (2) Drill down and run a specific stored process. Then, note the URL at the Top of your Web browser. For example: http://your.server:8080/SASStoredProcess/do?_program=/Teststp/Test1_stp&_action=form%2Cproperties%2Cexecute%2Cnobanner (3) If you want to run the stored process using the Guest account, then change the URL to specify "/guest?" intead of "/do?". http://your.server:8080/SASStoredProcess/guest?_program=/Teststp/Test1_stp&_action=form%2Cproperties%2Cexecute%2Cnobanner

Cynthia_sas · ‎02-27-2012

Hi: There have been many previous forum postings on using TAGSETS.EXCELXP in a stored process. Once you use this destination, then you can only submit your stored process from the Stored Process Web App, via direct URL (assuming that you know the URL to invoke a stored process) or in the Information Delivery Portal or in a custom HTML front end that you write (such as an HTML form).This all goes back to the "not every client app can "receive" every kind of destination output" explanation. TAGSETS.EXCELXP creates Microsoft Office 2003 "flavor" of XML and not all the BI client applications can "receive" that kind of output. I'd suggest searching for some of those prior posts. cynthia

Cynthia_sas · ‎02-24-2012

Hi: If you are going to allow your users to select a destination, then you will have to double check what they select. For example, if the client application is Excel, then you can't let them select PDF. If they are in EG or the Stored Process Web App then you can let them select PDF. If they are in Web Report Studio, then no matter WHAT they select, the WRS interface will change ANYTHING they select to SASReport XML, same thing for PowerPoint. So, it is not as easy as it sounds. The only client apps that will accept or receive PDF output are EG, the Information Delivery Portal or the Stored Process Web App. If you are going to use any client other than EG, you will have to send an STPSRV_HEADER. If you are using EG or your users will be submitting the stored process from EG, then you can, I think use the simple %STPBEGIN override method. At this point, you might want to go over to the Stored Process forum discussion and look for references to the Information Delivery Portal, PDF and/or STPSRV_HEADER. You might also want to look at the Stored Process Developer's guide or some of the Tech Support notes on the subject about returning results other than the default to the various client applications. cynthia

TriciaA · ‎04-13-2012

1 - Not that I am aware of. Sounds like a feature request. 2 - This very example is covered in the Building Business Intelligence with SAS book on pages 93 and 115. Based on the questions you have been asking - I think you would find the book a tremendous asset on your learning path.

art297 · ‎02-22-2012

Ashley, This looks like a stored process of which I have absolutely 0 expertise. However, that said, it looks like you are able to pass macro variables that users can select, namely &VAR1_MIN, &VAR1_MAX, &VAR2_MIN and &VAR2_MAX Couldn't you default the two min macro variables to a date lower than any filedate or termdate, and default the two max variables to a date greater than any filedate or termdate, and only replace those if entered as criteria by the user? If so, then your where statement could be reduced to: where (filedate between "&VAR1_MIN"d and "&VAR1_MAX"d) and (termdate between "&VAR2_MIN"d and "&VAR2_MAX"d)

AshleyM · ‎01-31-2012

Thank you! This worked

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Proc freq and zeros

Load .txt file and reclen

Re: If then statement

If then statement

SAS equivalent of SQL outer union corresponding

Proc SQL and similar SAS Code

Re: cascading_prompt_test

Re: cascading_prompt_test

Re: Apply button

cascading_prompt_test

Re: Proc freq and zeros

Re: SAS equivalent of SQL outer union corresponding

Re: If then statement

Macro variable "where_clause"

Re: Invoking stored process with direct URL

Re: Proc freq and zeros

Re: Load .txt file and reclen

Re: If then statement

Re: SAS equivalent of SQL outer union corresponding

Proc SQL and similar SAS Code

cascading_prompt_test

Re: Apply button

Customized data entry form

Customized data entry form

Re: Invoking stored process with direct URL

streaming output

Macro variable "where_clause"

Re: Selection Group Prompt and Management Console

OR operator and where clause

Processing multi-value input parameters in a stored process