topic Stored Procs w/JQuery in Developers

Stored Procs w/JQuery

milts — Thu, 06 Jan 2011 11:00:53 GMT

Hi,

I'll be creating a web application using stored processes. Is it safe to use Jquery on my streaming html outputs?

Many thanks!
Milton

Re: Stored Procs w/JQuery

Vince_SAS — Thu, 06 Jan 2011 20:41:44 GMT

If your intended use is to stream HTML containing jQuery code back to the browser, then you should be OK. I don't think it is any different than streaming HTML + JavaScript. A small test should confirm.

Vince DelGobbo
SAS R& D

Re: Stored Procs w/JQuery

milts — Mon, 24 Jan 2011 04:53:41 GMT

Thanks Vince, will give this one a try.

Regards,
Milton

Re: Stored Procs w/JQuery

Filipvdr — Tue, 17 May 2011 15:17:42 GMT

what did you created?

Im thinking about creating proc report which use a fixed header,sorting,.. actually something like the table-editor but better

Re: Stored Procs w/JQuery

milts — Tue, 14 Jun 2011 00:29:38 GMT

Hi,

I haven't tried anything fancy yet. Just tested if I can use the jquery ui components with the streaming stored process.

Regards,
Milton

Stored Procs w/JQuery

AngelaHall — Thu, 22 Sep 2011 00:11:40 GMT

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

Re: Stored Procs w/JQuery

milts — Thu, 22 Sep 2011 07:11:33 GMT

Hi Angela,

Thanks! Will check on your blog. I might get some more creative stuffs out there.

I'm currently implementing and testing stp + jquery right now. I have 6 portlets, the values of the different fields on the 1st portlet controls all the results of the other 5 portlets. The submit button on the 1st portlet calls an ajax request which prepares the data for the other portlets before the content portion of the current page gets refreshed.

So far I'm getting what I am expecting. It's cool that sas could work in combination of html. Coding is just a little messy because of the put statements. :smileylaugh:

Milton

Stored Procs w/JQuery

AngelaHall — Thu, 22 Sep 2011 23:47:07 GMT

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

Re: Stored Procs w/JQuery

milts — Fri, 23 Sep 2011 00:47:12 GMT

WOW! I didn't know this! This surely will make the code more readable and neat!

Thanks again Angela for this great info.

Milton

Stored Procs w/JQuery

Filipvdr — Fri, 23 Sep 2011 08:54:39 GMT

Sounds very interesting, I would love to see the result and howto?

Stored Procs w/JQuery

milts — Wed, 28 Sep 2011 04:42:12 GMT

Hi,

Will try to show the result after implementing this one.

Stored Procs w/JQuery

Filipvdr — Thu, 13 Oct 2011 12:18:08 GMT

Hi there, i started with something basic. I was trying to get an autocomplete textbox but it does not work.

This is my code, when running the html as test.html it works...

data _null_;

format infile $char1000.;

input;

infile = resolve(_infile_);

file _webout;

put infile;

cards4;

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

$(document).ready(function(){

var data = "Core Selectors Attributes Traversing Manipulation CSS Events Effects Ajax Utilities".split(" ");

$("#example").autocomplete(data);

});

</script>

<title> Test </title

</head>

<body>

API Reference: <input id="example" /> (try "C" or "E")

</body>

</html>

thanks!!!!

;;;;

run;

Stored Procs w/JQuery

milts — Thu, 13 Oct 2011 15:39:29 GMT

Hi,

I actually tried your code above and got the same result.

So instead of referencing the js file on their site like this...

Try downloading the js and css files and put it somewhere your server so you can access it like this...

or even create a different war file to place your jquery files

Hope this helps.

Milton

Re: Stored Procs w/JQuery

Filipvdr — Fri, 14 Oct 2011 06:36:12 GMT

Milts

Thanks but i dont have any idea how i can put files on my sasserver like that? Is it via management console?

Im really waiting for your examples with Jquery

greets

Stored Procs w/JQuery

milts — Wed, 19 Oct 2011 09:35:18 GMT

Hi Filip

Sorry for the late reply.

If you are using Tomcat here's an example of steps you can do:

1. on your tomcat webapps directory (ex. C:\<tomcat version>\webapps), copy SASTheme_default(since it's the simplest out there) and rename it whichever name you like (ex. SASCustom)

2. Delete the contents of SASCustom except for the META-INF and WEB-INF folders.

3. Add new folders on SASCustom (ex. scripts, styles).

4. Add files that you'll want to be accessed by your stored procs (ex. put your jquery scripts inside SASCustom\scripts-)

5. Restart Tomcat

6. Open a browser and try to check if you can access http://<servername>:8080/SASCustom/scripts/jquery.js. If it prompts you to open or download the file, then you've correctly done the steps above.

7. Try your jquery explorations. Actually I only used jquery to simplify access(instead of using getelementbyid most of the time because it's so looooong) and for the ajax function(i'm not confident using ajax if I'll be coding the function myself haha!). What you're trying to actually explore like your testing above is more advanced. Enjoy!

However, if you're using Weblogic or WebSphere, there are a few more steps and I'm not much familiar about it but it's still similar to the example I gave above.

Hope this helps.

Milton

Re: Stored Procs w/JQuery

Filipvdr — Mon, 13 Aug 2012 13:06:01 GMT

Hi Milts, i did not check this anymore. But recently I had some extra time and I managed to get it working!

In this example I am building 3 autocomplete textboxes and a datetime picker to let the user filter his data.

data _null_;

file _webout;

set lots end=lastobs;

if _N_ = 1 then do;

put '<!DOCTYPE html>

<html>

<head>

put '

$(function() {

$( "#datepicker" ).datepicker({ dateFormat: "dd/mm/yy",maxDate: "+0D" });

});

$(document).ready(function() {

$("input#lot").autocomplete({source: [';

end;

temp = '"' || strip(LotId) || '",';

put temp;

if lastobs then do;

put ']

});});';

end;

run;

Re: Stored Procs w/JQuery

SGB — Wed, 15 Aug 2012 02:36:49 GMT

Hi Filipvdr

I need to create similar thing for our UI. FriedEgg, an user in this community suggested to use Jquery for a datepicker.

I tried it, but I see only the textbox but I dont see a pop-up calender to pick the date. I will post the code that I used in the morning.

I will appreciate your inputs in this regard, as I am working on a time sensitive deliverable.

Thanks

SGB

Re: Stored Procs w/JQuery

milts — Wed, 15 Aug 2012 12:12:44 GMT

Wow that's great! Good for you.

For me unfortunately I haven't been involved on such projects yet which involves exploring JQuery.

But we have another project which I'm hoping to use Jquery for form validation.

Milton

Re: Stored Procs w/JQuery

SGB — Wed, 15 Aug 2012 14:18:42 GMT

Hi Filipvdr

I have tried your code..

I am getting a warning for 'unbalance quotation marks' although everything seems to be balanced. And output with all the put statement values.

Could you able to run the exact same code without warnings?!

I need to finish this task by friday. Any input is highly appreciated.

Thanks

SGB

Re: Stored Procs w/JQuery

Filipvdr — Wed, 15 Aug 2012 14:33:09 GMT

HI Bhuvana. I'm at home today. I will try to answer tomorrow.