LinusH Tracker

Re: Snowflake Queries

LinusH — Tue, 05 May 2026 13:08:50 GMT

Please provide the query (and log) so we can help analyze it, ideally with using the options in the link from @Tom.

Re: Export a dataset to csv inserting the delimiter at the end of each row

LinusH — Tue, 21 Apr 2026 10:39:36 GMT

Just to fix the output issue, you could use the of _all_ construct with catx:

data _null_;
	set &Lib..&Mem;
	length out $1000;
	out = cats(catx(';', of _all_),';');
	file "&outfile" mod lrecl=32767 encoding="utf-8";
	put out;
run;

Re: Lesson 7: Accessing DBMS Data with SAS/ACCESS

LinusH — Fri, 17 Apr 2026 06:31:20 GMT

It's pretty much in the message, you need to specify on which server your SAS PC Files Server is executing.
This information should be documented for your environment.

Re: Bulk loading

LinusH — Fri, 17 Apr 2026 06:24:56 GMT

I don't have the "Bulk Load" tab in my advanced settings, probably because we are using SAS/ACCESS to SQL Server, not ODBC. I'm on 9.4M8 Linux.
Not sure what you refer to when you say "advanced option in ODBC set up". Do you mean ODBC Manager (Ican't fins an advanced option here)?
I think it should be enough to set it on the libname, the important thing is to generate the BULKLOAD=YES when your LIBNAME statement is being generated.

Re: Daily SAS Problem?

LinusH — Fri, 27 Mar 2026 12:54:32 GMT

There are lot of coding challenges on internet. You can use those even if they aren't SAS specific, just use SAS to solve them.
One example I've couple of years is "Advent of Code".

Re: How to use SUBSTR to create another variable?

LinusH — Wed, 25 Mar 2026 07:56:12 GMT

As @MarkusWeick suggest, use a numerical date formatted column for this.

data news;
   val = '06May1998'd;
   new_val = intnx('YEAR',val, 1, 'SAME');
   format val new_val date9.;
run;

Re: SAS Enterprise Guide Error Message

LinusH — Mon, 23 Mar 2026 10:28:00 GMT

Could this be caused by VARIANT data types?

Check for lengths in all columns, do any of them exceed 32K?

Also, try implicit pass-through (your query should work with the same performance, explicit pass through shouldn't be necessary here).

Re: SCD Type 2 Loader Modification

LinusH — Fri, 20 Mar 2026 07:51:03 GMT

Another (and not ideal) work-around if you wish to use the existing transformation:
- specify %let etls_debug = 1; in your job(s), or perhaps in appserver_autoexec_usermods.
- Have program (macro preferably) in your postcode of your SCD2 transform (or as a separate transformation) that picks up work.etls_close, modify the end date (for records equal today - drop the rest), and re-apply it to you target table. Of course, if you are expecting a big amount of records to be closed out each batch, this is probably not acceptable from a performance standpoint.

Re: SCD Type 2 Loader Modification

LinusH — Wed, 18 Mar 2026 12:50:36 GMT

This is a outside my realm. I found this (old) paper:

https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://support.sas.com/resources/papers/proceedings/proceedings/forum2007/015-2007.pdf&ved=2ahUKEwi63Ma-vamTAxVDExAIHUkvPEkQFnoECB8QAQ&usg=AOvVaw02Ha3_unK5TGPkuKH_Td9S

May contact you SAS representative or open a SAS track to get better/more detailed guidelines.

One caveat, if you build you own java transformation, that will for not be eligible for migration to Viya 4 when that day comes (please verify with SAS).

Re: SCD Type 2 Loader Modification

LinusH — Wed, 18 Mar 2026 09:04:36 GMT

That is one flaw many have discovered.

Unfortunately, you cannot tweak the DI Studio native transformations, unless you a re a skilled Java developer.

What you can do is take the generated code from the standard transformation, and paste into a User Written Transformation.

It will not be as "nice" as the original one, and some adjustments/configuration to make it work.

Re: ERROR: Unable to establish a SAS Metadata Server connection. Proc Upload

LinusH — Mon, 02 Mar 2026 13:33:08 GMT

The transformation is available her:

Re: ERROR: Unable to establish a SAS Metadata Server connection. Proc Upload

LinusH — Fri, 27 Feb 2026 13:21:04 GMT

We have a slightly different setup, SAS Compute (corresponds to your DI Server I assume) is on the same host as LASR root (controller) node.

How is your LASR defined in metadata, when it comes to Logical Server, hosts etc?

Also, it doesn't look like you are using the SAS LASR Analytic Server Loader transformation?

Please share your Job diagram and the complete job code.

Re: ERROR: The SAS/ACCESS Interface to DB2 cannot be loaded. The SASDBU code appendage could not be

LinusH — Fri, 27 Feb 2026 10:11:51 GMT

As an addition to @Ksharp tips, also run PROC Product_Status. It will give details on what is actually installed.

Re: Creating temporary/Session specific tables in SingleStore

LinusH — Tue, 24 Feb 2026 15:12:22 GMT

Try the DBMSTEMP= libname option:

https://documentation.sas.com/doc/da/pgmsascdc/v_065/acreldb/p0he4t6yjfmkhpn16qrf0cdhllu6.htm

Re: How to improve performance copying a huge table while also creating additional indexes

LinusH — Mon, 16 Feb 2026 08:30:44 GMT

Generally speaking, SPDE does not usually speed up writing, because the data is still fed in single thread.

But it has a flip side when it comes to updating indexes, which is done in parallel while inserting data.

And of course, querying the data...

Re: Why doesn't the "contains "yes"" and select subquery produce the same result

LinusH — Thu, 05 Feb 2026 15:46:48 GMT

I did a simple test with sashelp.class and got expected result.

Can you post some test data (in form of a data step/datalines) so we can try your exact scenario?

Re: create seq number for each ownership structure

LinusH — Wed, 04 Feb 2026 07:15:19 GMT

Sorry, I don't understand how you wish calculate "order".
Can elaborate a bit more?

Re: Best way to move data from Path to ADLS2

LinusH — Wed, 04 Feb 2026 07:11:58 GMT

To be able to read sas7bdat from SAS compute, you need to mount it.

See the community post:

https://communities.sas.com/t5/SAS-Communities-Library/Using-Azure-Blob-Storage-for-sas7bdat-files-with-SAS-Viya-Part-1/ta-p/906563

Re: Best way to move data from Path to ADLS2

LinusH — Tue, 03 Feb 2026 11:46:43 GMT

Can you clarify what you mean by "data"?
ASFAIK ADLS2 is supported for CAS tables, Parquet and ORC libname and via filename.

Re: Migration- SAS 9.4 to SAS Viya - Spk file export

LinusH — Tue, 03 Feb 2026 11:39:26 GMT

.sas programs are just flat files, so from a movement perspective, it's "just" an copy operation of choice.
The tricky part is to make them compatible with your Viya environment. Most likely it comes down search paths to file and libraries. If you are migrating from 9.4 on Linux it is potentially easier than from a Windows Server. See Content Assessment Code Check for more details.
When it comes to EG, you may need to migrate, since EG is a supported client for Viya. If you migrate EG to SAS Studio you will lose some functionality, Content Assessment Profile should be able to tell you what.