Hi sasdavo! You have asked and you shall receive. Included is a snippet of the paper which corresponds to your request to map by county. Once these changes have been made, you can use county name or FIPS code with the 'Geography' data type.   Included are examples:   Subdivision (State, Province Names)* County Name Prince William Subdivision (State, Province) SAS Map ID Values* FIPS Code US-51153   Be sure to stop by the SAS Solutions OnDemand booth in Vegas and say Hi! Angela Hall Director, Analytic Integration Consulting ... View more

Hi Scott! Tricia and I have an example in our 'The 50 Keys to Learning SAS Stored Processes" of using the Data Targets so that an excel spreadsheet can be forwarded into the Stored Process to run custom code. (via SAS Add-in to MS Office) Also, new in 9.3 is Proc STP. The data targets definitions in metadata are used directly by SAS to generate the correct Proc STP statements. We have an example of that in the book as well. Hope you find other interesting uses for it! Angela ... View more

You can also purchase the book "The 50 Keys to Learning SAS Stored Processes" at 20% discount. Use code: FFZPHEHM At site: The 50 Keys to Learning SAS Stored Processes ~ Angela ... View more

Great news Girish. I was just getting ready to respond! My tip is always to test the stored process code from the SAS Stored Process Web Application first to ensure that it works as expected without bringing other components (such as BI Dashboard) into the mix. ~ Angela http://blogs.sas.com/content/bi ... View more

Hi there! Just came across your question. Have you seen this sample from SAS?  "Creating a case-insensitive, single selection prompt in SAS Information Map Studio" http://support.sas.com/kb/46/715.html ~ Angela Hall http://blogs.sas.com/content/bi ... View more

Tom, You could also grab the %_eg_whereparam macro code from Enterprise Guide and leverage that in stored processes. Angela ... View more

I was able to duplicate this in eg5.1. I guess that the macro was built with the thought that the user was only applying it when they wanted to use it? If you look at the code construction in the 'Preview' pain, if the eg_whereparam returns no values at all the 'AND <blank>' would also cause the SQL code to fail for other reasons.       FROM CANDY.SALESDETAIL2011 t1       WHERE %_eg_WhereParam( t1.Product, product, EQ, TYPE=S, IS_EXPLICIT=0 ) AND %_eg_WhereParam( t1.Date, daterange,            BETWEEN, TYPE=D, IS_EXPLICIT=0 ); QUIT; Wondering if you could set up a conditional processing step before this query task to fill with the date prompt values with beginning/end of time dates if nothing is entered. Then in the query task itself, use the &daterange_min and &daterange_max values instead of the _eg_whereparam macro. ~ Angela ... View more

Hi DonH, The _eg_whereParam should be able to cover date ranges. The issue might be the type of condition that you are selecting. When using a date range prompt, choose the operator 'In a range'. Then the value field should only contain the prompt name. Included is a screenshot of this from my SASGF11 presentation last year. Angela Hall http://blogs.sas.com/content/bi ... View more

Ah the put statements. I would actually recommend moving toward the cards4; input data lines capability. Here is a great example - this avoids the quoting around java/js/etc and put statements. http://support.sas.com/kb/37/050.html Good luck! ~ Angela ... View more

Hi Milton, Not sure if you have gotten this to work but wanted to chime in that I have built several examples using JavaScript within SAS Stored Processes. Recent examples are a custom html form (built within the stp) that includes javascript functions to clear out special characters before submitting the process, another is a custom drop down box on the left side of a proc gchart. Run it on the stored process server and be sure to leave the %STPBEGIN/%STPEND macros turned off. ~ Angela Hall http://blogs.sas.com/content/bi ... View more

I've written a blog post about this as well. http://blogs.sas.com/content/bi/2010/07/20/combining-graphsprocs-with-custom-html-in-a-sas-stored-process/ You can simply add the STYLE macro inside the ODS HTML statement as follows: ods html body=_webout (no_bottom_matter) style=sasweb path=&_tmpcat  (url=&_replay); ~ Angela Hall ... View more

BASE SAS actually automatically ends a PROC or DATA process when it encounters a RUN statement or the next PROC or DATA statement. So the second data _null_ statement actually reinitializes the variable a to missing, and when you add anything to a missing value you still get missing as the result. If you remove this second data _null_ statement, the process works correctly. Included is a brief test that I completed in BASE SAS. Code: filename out 'c:\temp\test.html'; data _null_; file out; length  a 4; a=0;     put 'Value: ' a+(-1) ' <br>';     a = a+1;     put 'Value: ' a +(-1) '<br>'; run; Output: ~ Angela Hall http://blogs.sas.com/content/bi ... View more

So are you looking to only display a certain number of rows at a time? If the stored process is mainly needed for a custom query, you could change the design slightly. Have the stored process added to an information map and the web report point to that information map. Then the # records per view would be honored. Included is one sample on how to add a stored process to your information map. http://support.sas.com/kb/26/175.html ~ Angela Hall http://blogs.sas.com/content/bi ... View more

You could add an optional prompt for email addresses to the stored process. Then if this is entered, then an additional couple lines of code are added to the program to output to EMAIL. Essentially: filename outbox email 'ron@acme.com'; goptions device=PNG; ods pdf file=pdfout; <your sas procs here> ods pdf close; The results still appear on the users browser screen and the stored process report is immediately sent to ron@acme.com. Hope this provides you another option. ~ Angela Hall http://blogs.sas.com/content/bi ... View more