Thank you @LinusH and @Tom  Yes, Teradata is on Unicode and SAS on LATIN1 which is the root cause for the error.    I believe I figured out what the issue is (have to fully verify next week when back at work): The SAS SQL accesses a Teradata View that sources from another Teradata view. I can only access the first (last in the chain) view. Data protection has lately been tightened and I've realised that the account_id's I'm getting are masked (hex string).  The users (user id's) that still can execute the SAS script without mode=Teradata are used for production runs and certainly need clear-text data.  My guess is that these users got additional/different Teradata permissions and that the Teradata view defines the account_id column with a different definition (=likely not as Unicode) for these users. ... View more

Tables in databases need stable structures. Unlike with SAS Files (tables) you normally also create the table structure only once and then insert, update or delete data attached to this structure.  What you are describing feels like a bad use case for using SQL Server tables as "dumping ground" for SAS output.  It only complicates things for your users and likely also increases end-to-end processing time caused by frequent data transfers between SAS and the database.   What is the reason for pushing "all" SAS output to SQL Server? ... View more

Another option that I'm using frequently for autocall macros: options mautolocdisplay; With this option a log message get printed that tells you where the macro has been compiled from whenever you use the macro. ... View more

If attach to the output dataset means storing it in a variable of this dataset then below is a straightforward way of achieving this. data want; set sashelp.class end=last; length my_logic $400; if last then do; my_logic=cats('%let wtcalc1=',"&wtcalc1;",'%let wtcalc2=',"&wtcalc2;",'%let wtcalc3=',"&wtcalc3;"); end; run; ... View more

"We are migrating a SAS 9.4 on-prem DI environment to Azure where future ETL processes will be developed using Azure-based tools" So are you initially migrating from a on-prem SAS 9.4 to an Azure cloud based SAS 9.4 or is this from start about replacing SAS 9.4 with something else like Databricks?   A SAS 9.4 on-prem to SAS 9.4 Azure migration is certainly very doable and there are SAS provided tools & scripts that can support such a migration.   A replacement of SAS 9.4 is a totally different story and will require much more planning. If you search a bit then you'll find 3rd party providers who offer automation tools. I don't know though how much their claims match reality. With the rapid growth of AI there might be tools in the not so far future which will make such migration much easier. Right now it's from what I know still a labour intensive and costly exercise that will require very good planning and the right people for it not to fail.   job dependencies You should be able to derive this from the scheduler used. Or you could also use the information which output table from one job get used as input tables by another job. With DIS AND if the tables got actually registered in SAS metadata that's something you could work out scripted via SAS Metadata queries.   and logic from SAS DI Well: DIS is used to define jobs but it's the DIS generated SAS code that actually gets executed. And it's not uncommon that not all DIS steps are fully metadata driven but are just using manually created SAS code in first place. You would need to analyse both the SAS DIS metadata and the generated SAS code to fully derive the logic - and that requires good SAS skills to do efficiently. ... View more

What do you mean by SAS to Azure? To which SAS version are you migrating to? If this is about a SAS9.4 to SAS Viya migration then use SAS Content Assessment. ... View more

@CherylCoyle  It's not an issue for me but I felt you/SAS might want to know about this limitation. ... View more

I'm using Bitdefender VPN. If on a secured connection, your link returns below. This also happens if I'm connecting via the United States and not my country of residence.     Without Bitdefender VPN:   With Bitdefender VPN United States:     ... View more

It feels like "something happened" and SAS overreacted. Backward compatibility was imho always an important selling point for SAS. I believe that it would have been more than sufficient for these functions to be disabled as a default but with some option to enable them - something similar to noxcmd. ... View more

The 3rd party app with which SAS communicates doesn't "know" how SAS password encoding and decoding works. SAS must therefore send the password cleartext. This is also true for SAS Access where you're passing something like pw="{SAS005}6DDE667...." SAS will during runtime decode the password and send it cleartext to the database.   It appears such decoding is not implemented for proc http with oauth_bearer parameter and therefore you can't use a SAS encoded password but must send it cleartext.   Based on some Googling Databricks supports OAuth Token Federation - but SAS only fully supports it in the Viya version. ...and it would also require some setup.   For OAuth Bearer Token you could store your token in a secure location and access it during runtime (=not directly storing it in the script). Another option would be to wrap your code into a SAS macro that you compile secure into some permanent SAS catalogue - with the token provided as macro parameter when you compile the macro.   ... View more

@fnajera If you don't get an answer here, contact SAS Tech Support. They can give you an official answer where things are at. ... View more

@Nasser_DRMCP wrote: hello thanks for your respons. I tested what tom has suggested. and the 2 codes take the same time, arroud 10 min   nasser And that's o.k. for you or not? Make sure you look into the readbuff value. If it's set to the default of 1 then increasing this value will highly likely improve elapsed time further. And depending on your data and disk I/O adding compress=yes could also help. ... View more

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.  ... View more

In case the data step you shared is within a macro, the macro variables created could be in local scope.  If that's the issue then try with below amendments.     ... View more