topic I want to transfer DI Studio code to SAS Viya and remove the DI wrapper code in Developers

I want to transfer DI Studio code to SAS Viya and remove the DI wrapper code

Hiandbye — Wed, 01 Oct 2025 10:48:06 GMT

Hello, Is it possible to prepare a cleaner SAS code from DI studio that will exclude a lot of the autogenerated wrapper code

e.g.

%let etls_startTime = %sysfunc(datetime(),datetime.);
%let etls_recordsBefore = 0;
%let etls_recordsAfter = 0;

Re: I want to transfer DI Studio code to SAS Viya and remove the DI wrapper code

Hiandbye — Wed, 01 Oct 2025 10:51:28 GMT

I tried the following but it didn't work:

if prxmatch('/^%let\\s+etls_.*;/i', strip(line)) then delete;

Re: I want to transfer DI Studio code to SAS Viya and remove the DI wrapper code

MrSantos — Wed, 01 Oct 2025 11:58:04 GMT

Hi,

Doing the migration of SAS DI jobs to SAS Viya manually the way you seem to be doing may not be the best option. Using the SAS Content Assessment Tool to help manage the migration may save some time and help identify jobs that will migrate easily and jobs that will present difficulties. Here's a demo of a job migration using the Content Assessment Tool: https://youtu.be/IIxyUbdmZoM

Regards,

Re: I want to transfer DI Studio code to SAS Viya and remove the DI wrapper code

Patrick — Sun, 05 Oct 2025 08:30:55 GMT

Your RegEx needs some amendment. Below should work.

data test;
	infile datalines4 truncover;
	input line $256.;
	if prxmatch('/^\%let etls_\w+.+;$/i', strip(line)) then delete;
	datalines4;
%let etls_startTime = %sysfunc(datetime(),datetime.);
%let etls_recordsBefore = 0;
%let etls_recordsAfter = 0;
;;;;

But as @MrSantos already advised, you should use the SAS Content Assessment Tool with it's migration tools.
What you're doing would only make sense if you wouldn't want to migrate to SAS Studio flows but to simple .sas programs ...but this would only make sense imho if the SAS Viya version you've licensed doesn't allow for the direct migration to SAS Studio Flow.