Tag dataset to SAS share server, how to browse that dataset, SQL distinct identifier

This code run both on windows and Mainframe servers.


Attach a dataset to SAS Share server, (Run this after starting the share server)
ALLOCATE LIBRARY Orgdata 'BWZ0.LA.SASDATA.ORGDATA' SERVER=SHARE01;
DATALIBS Orgdata;


Read data set tagged to a SAS share server
LIBNAME dates 'BWZ0.LA.DATE.STORAGE' server=share01 DISP=SHR



SQl query for finding non-unique values:

proc sql;
create table repeat as
SELECT DISTINCT year,week_nr , teamid from La130.Wdata
group by year,week_nr, teamid
HAVING count(*) > 1 ;
quit;


Ways to remove duplicates in SAS SQL :

proc sort data=LA130.WATA out=nodups5
nodupKEY;
by TEAMID DATENUM;
RUN;

Funtion to trigger SAS job from javascript / html (SMART work):

function gotohome()
{
open("/tst-bin/broker?_service=tstnorm&_program=tstsrc.llastart.sas&_debug=0",target="lla_main");
}

NOTE: Broker must be installed on the SAS server
NOTE: Change the service name accordig to your project
NOTE: program name is like: Servicename.programname.sas
NOTE: Target is the HTML page lable/name.
NOTE: Give debug=131 for getting the SAS log


I have few more examples to call SAS broker with various parameters.
/*--------------------------------------------------------------+
| go to Next page |
+--------------------------------------------------------------*/

function next()
{
var _flag;
var year_nr =yearnr[0];
var week_nr =weeknr[0];
_flag = 'N';
alert(year_nr);
alert(week_nr);
open("/tst-bin/broker?_service=tstnorm&_program=tstsrc.lla500.sas&_debug=0&_flag="+_flag+
"&_year="+year_nr+
"&_week_nr="+week_nr+"",
target="lla_main");
}


/*--------------------------------------------------------------+
| go to Previous page |
+--------------------------------------------------------------*/

function previous()
{
var _flag;
var year_nr =yearnr[4];
var week_nr =weeknr[4];
_flag = 'P';

alert(year_nr);
alert(week_nr);


open("/tst-bin/broker?_service=tstnorm&_program=tstsrc.lla500.sas&_debug=0&_flag="+_flag+
"&_year="+year_nr+
"&_week_nr="+week_nr+"",
target="lla_main");
}



This post is mostly for myself , but if you find few pieces useful here do post comments.