About LinusH

LinusH · ‎12-17-2024

Merged posts, duplicates.

LinusH · ‎12-17-2024

The goto method of generating dynamic logic in SAS is by using macros, and that should work fine for this simple scenario. So read your data set formula and push the formula to a macro variable by using CALL SYMPUT. My guess is that your real life scenario is slightly more complicated/extensive, so I need to see more to determine if CALL SYMPUT would work.

LinusH · ‎12-16-2024

Ok, so the question is what kind of expressions are valid in the Value field. I guess you can try your today()-1 or "&Sysdate"d-1.

LinusH · ‎12-16-2024

I'm threading on thin ice here, but could you modify/create you own SQL*Loader control file? It seems that you can configure the loading with aspect to encoding and separators. And then use BL_CONTROL ds option to call it.

LinusH · ‎12-16-2024

I don't have Data Studio at my fingertips, and the docukentation is not really answering this specific need. But your screen shot is from the Convert Column transform, please attach one with the Filter transform.

LinusH · ‎12-12-2024

There is currntly no migration path for WRS reports. You can migrate the underlying data sources (tables, information maps, OLAP cubes), and the rebuild the reports manually in VA.

LinusH · ‎12-09-2024

The user guide is found here: SAS Help Center You need a specific access key, which should be availble at your site, provided by SAS as part of your license.

LinusH · ‎12-09-2024

Maybe a SAS representative should answer this question. But what I've seen so far is the use of Notebook style of editing in SAS Viya Workbench. But it isn't far fetched that we will se similar implementations in additional Viya UI's.

LinusH · ‎12-04-2024

Do you mean in a SAS based application. Please provide some more background. Also, there are specific testing software that probably can do what you are asking for.

LinusH · ‎11-27-2024

Please provide more context, like sample input, and desired input.

LinusH · ‎11-20-2024

Se eaprt of the log (the error and then the email/proint) might help us to understand. A guess, some errors make SAS go into syntax check mode, and sets obs=0.

LinusH · ‎11-19-2024

I'm a little bit confused by these statements: "... it does not list Schema tables...". What do you mean by schema tables? "... and it list tables...". What tables gets listed? Please provide examples of what you see in SAS, and what's available in in SQL Server.

LinusH · ‎11-14-2024

There's a risk that this question ends up in some standard procurement forms/RFP/RFI etc as tick box .

LinusH · ‎11-13-2024

There is no general option that manges this in (fed)SQL. How to handle depends on your situation. Do you use an inner or an outer join? Are the same name columns part of the join criteria? If not, do you expect them to have the same values in both data sets?

LinusH · ‎11-13-2024

Show your code and log for this execution.