The reason it works for year is that if you have two dates with the same year you then have two objects for the year so it takes the last.... if you have unique dates each date will be first and last so selects all of them... fund_id firm_id report_date YEAR A 4545 30/6/1998 1998 A 6688 30/12/1998 1998 B 4545 30/3/2000 2000 (First and Last Date)(First Year) B 4545 30/9/2000 2000 (First and Last Date)(Last Year) B 9535 30/3/2001 2001 C 4656 .... D 7586 D 8965 what you want to do is have Last.Firm_ID rather Last.Report_Date which will give you the latest date for each Clear as Mud Barry Message was edited by: twocanbazza Message was edited by: twocanbazza Message was edited by: twocanbazza ... View more

Fully Agree... EG Adhoc analysis etc, DIS ETL automation.... Bring on the day that we can open EG project in DIS and convert, or be able to deploy eg jobs to DIS.... Barry ... View more

Are you talking programmatically or interactive... If you are 9.2 and have an unrestricted login, you can click on the advanced button for on the authorisation tab for the Storedprocess in SMC. You can then see what the applied permissions are for that object for any person/group Barry ... View more

If the users search (Using the search top right) for the page, can they find it? ... View more

Doing the above will "Connect" you to the metadata but will not run the script on the metadata server. What sort of script are you trying to run, as if the metadata server is just that, you shouldn't be running sas jobs on the server unless they are metadata maintenance jobs such as backup etc. To achieve what you want you'll probably use SAS/connect, have you local session execute and connect to the remote server. Barry ... View more

I think Tom is on the right track so will leave you two to it. Hopefully works Barry ... View more

RSB What version are you using? Also Is it a straight table listing or does the table/report perform some summarisation? Barry ... View more

Jose. How did you get on with this as, (guess what) I encountered the same error message Yesterday after changing my permissions in SMC. Still wtrying to work out the exact conditions that cause this. There are some pretty interesting errors in the WRS Log that I am looking into. We are using, Jboss, SAS9.2M2, WRS 4.2 M1 (Build Number: 902200.24.1.20091125111200_v920m2f Build Date: 25/11/2009 ) Cheers Barry ... View more

I agree Scott, the more information the higher the chance of getting a positive outcome. But we need to understand that a) The person sending these questions may not have a solid technical background like you. b) English may be a second (or third Language) My comments were just stating that you are paying (many believe it is free and hence have different expectations) for the service, now if you make it hard for yourself not supplying the right information to them then that is another story. Responses to US customers may be different to the response times in other parts of the world, we have a least a 24hr turn around if our local office has to esculate the question. Barry ... View more

Hmmm. Is the export code generated by EG or did you write it in a code blob? I think I have seen another thread like this somewhere in these forums but not sure what the outcome was. Barry ... View more

BTW Tech Support is not FREE, that is what one of the things you pay Renewals for... So you should expect a level of timelyness... ... View more

Are you using EG to connect to the SAS server or Base SAS? That aside looking at your error... ERROR: Insufficient authorization to access /sas/SAS_9.2/EntBIServer/Lev1/SASApp/S:\CH\Fin\SYSTEMS\DI\Systems\SAS_EBI\Exports\OUTFILE.txt. It has concatinated your default path with the path you have tried to define. Is "S" drive known on the SAS server ? I suspect not. Try a UNC path ie \\ComputerName\ShareName\CH\Fin\SYSTEMS\DI\Systems\SAS_EBI\Exports\OUTFILE.txt. Barry Message was edited by: twocanbazza ... View more

Have you tried not sorting the vars in the information map/WRS and use the dataset order.... if only a listing... Barry ... View more

Have you accessed WRS before? Have you or the admin's made any changes to WRS config's, have you restarted the WRS / Web app containers? What Version of WRS/SAS? Tomcat,Websphere, Jboss, or Weblogic? What are the errors in the server log? Pretty hard to help with out more details Barry ... View more

Have you got an example of one of the differences? Hard to give you help, with so litle information.... Barry ... View more