About Thoney

SASKiwi · ‎02-03-2018

I suspect the key to your problem is you appear to be using IWA (Integrated Windows Authentication) for your first SIGNON test as you are not supplying a user name. So you are relying on your client session delegating its authentication credentials to the server sessions. Then when you define a LIBNAME using the UNC convention \\ServerName\Folder, that is a second level of delegation. So it appears HADES_1 is set up correctly for two-level delegation of user credentials but HADES_2 is not. You appear to be using Windows servers so I suggest you check out the Kerberos SPN settings of both of your servers to see if anything is different: setspn -i HADES_1 or _2. See this link: https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc731241(v=ws.10

RW9 · ‎10-17-2014

Its not even that consistent unfortunately. If you have names from further afield there is different regional variations etc: http://en.wikipedia.org/wiki/Capitalization#Sentence_case_versus_title_case My suggestion, find out what is "required" at output and what is actually stored currently and see if there is a compromise to be had, e.g. all upcase or something. You might also want to remove identifiers completely e.g de-identification.

data_null__ · ‎04-18-2013

RTM %SYSFUNC has optional 2nd argument.:smileyinfo: 19 %let Yest = %sysfunc(intnx(DAY,%sysfunc(today()),-1),DDMMYYn.); 20 %put NOTE: &=yest; NOTE: YEST=17042013

Thoney · ‎01-11-2013

Hi Tom, Fantastic little section of code that did the job in 4 very short lines! Thanks a lot, and Linlin, ever helpful responses as usual as well, I'm sure your code works too but I tried Tom's to start with because it was a little shorter and I'm lazy (hehe) Again thanks a lot people, the help is appreciated beyond belief! Starting to become really glad I joined this forum! Kind Regards, Tom.

Thoney · ‎12-31-2012

Hi Tom This is something that I asked one of my colleagues when I first started, however it appears that the company I work for are not renewing the part of the license that covers Enterprise. Therefore I've been told I will only be able to use raw SAS code, so must learn the "in at the deep end" way lol. Thanks for the suggestion though Tom

Online Status	Offline
Date Last Visited	‎08-13-2020 08:03 PM

Remote submitting on Virtual Server - permissions issue for libraries

Proper Name Case

Re: Problem with variable names when batching SAS

Problem with variable names when batching SAS

Re: Compress rows as opposed to columns

Compress rows as opposed to columns

Re: Using proc SQL to keep obs based on multiple column criteria

Re: Using proc SQL to keep obs based on multiple column criteria

Using proc SQL to keep obs based on multiple column criteria

Re: Remote submitting on Virtual Server - permissions issue for librar...

Re: Proper Name Case

Re: Problem with variable names when batching SAS

Re: Compress rows as opposed to columns

Re: Using proc SQL to keep obs based on multiple column criteria