About jklaverstijn

jklaverstijn · ‎01-31-2023

In my 35 years of datastep programming I never considered an infile option for alternative missing characters. But now I see a need for that. But there is none. Why would you have two sets of code? You can use your code for dataset TWO for ONE as well. Much easier. I gues the computing overhead would be minimal and not outweigh the ease of having one piece of code. and no need for going over your data twice. data one_two; length id 8 a_char $12 a 8; input id a_char $; drop a_char; if a_char = '*' then a = .; else a = input(a_char, best12.); datalines; ... run;

jklaverstijn · ‎01-31-2023

Hi, Most environment settings are done in the casconfig_usermods.lua file. I would expect that for umask as well. For Linux that file is in /opt/sas/viya/config/etc/cas/default. Hope this helps, - Jan.

jklaverstijn · ‎01-13-2023

Hi all, We run Viya 3.5 in both RHEL 7 and 8. We have always configured KRB5 and SSSD on our systems for file based ticket caches as a matter of routine. Now our security guidelines indicate we should use the kernel keyring as the files can theoretically be stolen. After reconfiguring krb5.conf and sssd.conf to meet this requirement things worked as before. However we still see file based caches appear whenever someone logs on. These are transient, living only for a few seconds. We also see one for every active CAS session, living for the duration of it. Consulting tech support and the docs shows that in act there is only support for file based ticket caches. So that would be the end of it. Keyring is the RHEL default since v7 and we can imagine that many shops have that configured that. Since we see no apparent issue maybe it can work. Such a support statement from SAS often means "we haven't tested it" rather that "it doesn't work". That still leaves the CAS related cache files that Viya itself creates beyond our control but our exposure would still be less. Does anyone of you have keyring configured and not have any issues? Could we gamble this? Thanks in advance and kind regards, - Jan.

jklaverstijn · ‎10-26-2022

A macro solution could be obtained by marrying the wonderful %sysfunc() and prx*() functions. This works for me: %let string=20040; %let regex=/012$|040$/; %let regid=%sysfunc(prxparse(&regex)); %put &=regid; %let valid = %sysfunc(prxmatch(&regid, &string)); %put &=valid; The code could be further condensed but this is the most descriptive. %let string=20040; %let valid = %sysfunc(prxmatch(/012$|040$/, &string)); %put &=valid; The macro variable "valid" has a value of 0 (zero) if there is no match or a positive integer indicating startposition of the pattern searched for. Needless to say I am a fan of the prx functions and highly recommend them in these situations. Hope this helps, - Jan.

jklaverstijn · ‎10-25-2022

There are some gotcha's involved when running a datastep in Viya. You can refer to this blog post for some pointers. Otherwise please share more details and the log of what is not working. Merely stating that does not give many clues as to what might go wrong. Regards Jan,

jklaverstijn · ‎10-25-2022

Hi @AlexMonod, are you looking to change the font size or the panel size? From your annotated picture I would think the font size. That can be changed by following the advise in this blog post. Judging by the picture you have a high resolution display. Maybe setting the font scaling in Windows will also help albeit in a way that affects the entire Windows GUI. Hope this helps, - Jan.

jklaverstijn · ‎10-21-2022

There are a few reasons why one cannot edit authorizations on a table. They are documented in the paragraph "Inability to Modify Access" in the SAS Viya 3.5 Administration documentation. Have a look and let us know if the suggestions were applicable to your case. Hope this helps, - Jan.

jklaverstijn · ‎09-27-2022

Please be cautious when killing database processes. Especially when using "kill -9" will yank the process and leave no room for an orderly shutdown. Your data may become damaged. Before anything else ask yourself why Postgres is still running. Did something go wrong when stopping the services? Did you forget a step somewhere? Is postgres the only service that is still running? Maybe the metadata server or some spawners are also still there. A thorough review of your routines may prevent this from happening again. Then try again stopping the environment using the sas.servers script. If that does not help (eg. pid files me already point to the wrong processes) use the scripting of postgres itself. Or use kill on the postrgres processes but not with -9 but with -TERM. That usually signals Postgres to initiate an orderly shutdown instead of brutally killing it. A kill -9 should always be your last resort.

jklaverstijn · ‎09-27-2022

Not in a position to test right away, but what about enclosing the alphanumerical values in quotes? cas mySession sessopts=( caslib="casuser" timeout=1800 locale="en_US" MAXTABLemem="8G"); regards, - Jan.

jklaverstijn · ‎09-12-2022

@gwootton wrote: When you stop the object spawner, any processes spawned by that object spawner will be terminated, so end users would be impacted. My 2 cents on this: I know this to be true for workspace severs (WSS's) launched directly by the spawner. But it is different for grid launched workspace servers. We routinely restart object spawners and never have WSS's terminating. I would expect many more calls from users if we would pull the rug from underneath them every now and then. The spawner asks LSF to launch the WSS on its behalf and there is no process parent-child relationship between them at the OS level.

jklaverstijn · ‎08-30-2022

Raiseerror() is part of the Dataflux datamanagement software. That may not be the proper context for this question. If this is datastep, do something like this: ... if value=0 then do; putlog "ERROR: Something went wrong and value is 0." abort abend 4; end; ... This will write a message to the log and terminate the program, returning a return code of 4 to the operating system. Other variants may apply. See the SAS doc for details. Hope this helps, - Jan.

jklaverstijn · ‎08-29-2022

SAS does not really have a character NULL value as compared to any RDBMS. An empty string or missing value is its nearest cousin and often obeys NULL comparison, but often it does not. It is a common trap for young players. If you rewrite IS NULL to = "" you will see it works. proc sql; create table RTS_Sunfire as select distinct *, case when Product_Categories1 = "" then "MA; MAPD; DSNP" end as Product_Categories from RTS2023 ;quit; Alternatively you could use the coalesce function here: proc sql; create table RTS_Sunfire as select distinct *, coalesce(Product_Categories1, "MA; MAPD; DSNP") as Product_Categories from RTS2023 ;quit; Hope this helps, - Jan.

jklaverstijn · ‎08-29-2022

If there is some logic behind these values (that smell of Excel formula's 😉 )? I would rather implement that logic instead of going through many predictable rows in tables. That said, If there is not, I would code a data step that reads B_Have, loads A_Have in a hash table and perform lookups on that hash table that would map A2 to B$1 etc. I can provide a code example but would have to know first what you mean by "long"? Thousands of rows, milions, ...? Hope this helps, - Jan

jklaverstijn · ‎08-26-2022

It may not always be in the environment variables. Many system values are stored in macro var as well. So this in your code and read the log: %put _all_; You will see all the macro variables and their values defined for your session. Hope this helps, - Jan.

jklaverstijn · ‎08-26-2022

Hi, Please have a look at the SAS doc on ISO 8601 (in)formats. Your code would look something like this: data _null_; format dt datetime21.; string = '2022-06-10T09:23:45+05:30'; dt = input(string, e8601dz25.); put string= dt=; cards; run; In my haste I could not get it to work without 0-prefixing the time zone. This may very well be the way ISO wants it. If I read the wiki on ISO 8601 I think I am right and it should be "+05:30". Hope this helps, - Jan.

Online Status	Offline
Date Last Visited	‎09-22-2025 12:07 PM

Re: Why does SAS randomly report "Library WORK does not exist" during ...

Empty Web App Servers

Re: Email notifications from subflows

Re: Email notifications from subflows

Re: Automating SAS Package deployment using Import/Export Batch Tool

Re: Automating SAS Package deployment using Import/Export Batch Tool

Email notifications from subflows

Re: Wolfensäs: The FPS game that was written in SAS

Re: SAS Upgrade from 9.4 M7 to 9.4 M8 failing

Re: How to attach a file from a server in SAS Email

Re: Before you update to RHEL 8.8, please read.....

Re: Reference column type in data step OR suppress invalid numeric dat...

Re: How to set the umask for CAS?

Re: Convert Character ISO datetime into datatime

Re: SAS EG Stored Process wont update table

Re: Email notifications from subflows

Re: SAS Enterprise Guide to point to Unicode SAS

Re: SAS Upgrade from 9.4 M7 to 9.4 M8 failing

Re: Which element of the architecture effectively sends an e-mail when...

Re: How to set the umask for CAS?

Re: Reference column type in data step OR suppress invalid numeric dat...

Re: How to set the umask for CAS?

Kerberos ticket cache in file or keyring in Viya 3.5

Re: Selecting character strings whose last 3 characters ends with cert...

Re: Filter data

Re: Change Size SAS panels

Re: Cant Edit Authorization due to access controls for table blocked b...

Re: SAS WIP not starting

Re: increasing memory block size in session option in SAS Viya

Re: SAS Grid object spawner restart

Re: Put the ERROR message to the log

Re: Why is my case statement returning null values?

Re: How to create a table compsed out of 2 translating tables

Re: Get all op system variables from EG

Re: Convert Character ISO datetime into datatime

SAS Global Forum 2017

SAS Global Forum 2018

SAS Global Forum 2016