aaagghh crap Ignore that post i got it      proc sql noprint; select count(*) into :cnt1 from WORK.HRIR99991; quit; %LET _l1display = %SYSFUNC(TRANWRD("&l1." , %STR(|) , %STR(,))); %LET _l2display = %SYSFUNC(TRANWRD("&l2." , %STR(|) , %STR(,))); data _null_; file _webout; put '<b><h2><center><font color=red>' "&cnt1" '</font><font color=green> Records found filtering on <font color=red>' &_l1display '</font> and <font color=red>' &_l2display '</font></font></center></h2></b><br>'; run; ... View more

well not to get what metadata server I was using, however      D:\SASConfig\Lev1\Web\WebAppServer\SASServer1_1\sas_webapps\sas.svcs.logon.war\WEB-INF\view\jsp\default\ui     if you have custom logon and custom logout enabled    Application management>SAS Aplication Infrastructure>Properties>Settings    say yes to Display Custome logon message   then in logon_customer.jsp you can write some JSP code to spit out env vars   <% java.util.Enumeration e = System.getProperties().propertyNames(); while( e.hasMoreElements() ){ String prop = (String)e.nextElement(); out.print(prop); out.print(" = "); out.print( System.getProperty(prop) ); out.print("<br>"); } %>       you can t include stuff like  <%@ page import="java.util.*" %>     as well you can insert jQUERY to do things like in this case redirect a bad URL someone has cached: we have users that have links from 9.3ebi on there desktop instead of an error this redirects them to the login page and they can go find their new link     <%-- This JSP file is included as part of the logon.jsp if a site has enabled the custom logon page message policy. The tags below are provided as a simple convenience for those sites that want to simply provide an embedded text message. These tags can be modified or removed if additional customization is required. --%> <p> <%-- custom content goes here --%> <link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/themes/base/jquery-ui.css" type="text/css" media="all" /> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js" type="text/javascript"></script> <script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.16/jquery-ui.min.js" type="text/javascript"></script> <script type="text/javascript" language="javascript"> var theUrl = $(location).attr('href'); var isFound = theUrl.toLowerCase().indexOf("_sasapp=information+delivery+portal+4.3&"); if (isFound > 0) { var res = theUrl.split('?'); theUrl = res[0]; $('#custom-logon-message').append('<font color=red><h2>' + theUrl + ' </h2></font><br>' ) $('#fm1').attr('action', '/SASLogon/login'); $('#fm1').get(0).setAttribute('action', '/SASPortal'); var actionis = $( '#fm1' ).attr( 'action' ); $('#custom-logon-message').append('<br><font color=red><h2>' + actionis + ' </h2></font><br>' ) theUrl = theUrl.replace('/SASLogon/login','/SASPortal') window.location.replace(theUrl); } </script> </p> ... View more

Building upon what Bruno has mentioned ...   Once you follow his advice, you would need to change the way you refer to the macro variable X by adding an ampersand:   %if &X > 0 %then ...   Alternatively, just get rid of X entirely:   %if %index(&_srvname, uview) > 0 %then ... ... View more

Thanks Diane that's kind of what i suspected I seem to have a misconfiguration somewhere as all 3 metadata servers are up just not "connecting" or cluster aware. ... View more

Assuming your JMP can submit SAS code to a local/remote installation of SAS 9.3+, then yes. ... View more

OK. treat is as a stream file . data x; infile 'c:\temp\sample.txt' recfm=n  dlm='<>"';   input x : $100. @@ ;   if lag(x) = 'a href=' or lag2(x)='a href='; run; Xia Keshan ... View more

aaaghhh I am a dummy I was feeding the wrong data you had answered my question ... View more

As KurtBremser has stated you should have the data somewhere, and your proc export is incomplete: PROC export /* Missing */  data=... /* this statement would tell you where the dataset is, if you are using the functionality of processing a previous dataset (and I would still recommend putting the data= statement in regardless for clarity - then look at that datastep */ outfile="\\abccsrv1\dept\IM\Information and Service Requests\irsas14$dir\IR14006\Vers_1\Deliverables\ir14006.xls" dbms=XLS replace 2003; ; ... View more

one other thing how would I check each line looking for "index.html" line in this line <a href="allswell/index.html"> identify that it has index.html in it then strip out allswell/index.html  so that i can use that to build 'http://shakespeare.mit.edu/allswell/full.html' ... View more

cool thanks that will be more compact for sure ... View more