About LinusH

LinusH

So do you want to generate one record per "person" base on the values of TotalFemale and TotalMale columns? I would probably use two nested do-loops (one for each gender and with/without MedReceived). In each loop an explicit OUTPUT statment. do f = 1 to TotalFemale; do fr = 1 to FemaleMedReceived; MedReceived = 'Yes'; Output; end; do fnr = 1 to TotalFemale - FemaleMedReceived; MedReceived = 'No'; Output; end; end; /* repeat same logic for male below */

LinusH

If you have the intervals stored in a data set/table, you can feed PROC FORMAT using CNTLIN. SAS Help Center: Creating a Format from a CNTLIN= Data Set.

LinusH

They are pretty much the same, where clauses hit the I/O buffer, regardless of syntax used. Way 4 is probably slower since it acts on output data, rather than filtering the source table. What would speed up retrieval is using an index on lakoach/custid.

LinusH

If this is one off, I don't think it doesn't matter so much. If this is a recurring work that should be executed regularly - try to do data prep "and other operations" on only new data.

LinusH

Haven't tried your code, but I think you need an INFORMAT for your date variables.

LinusH

1. Have your query work in a SQL Server interface (e.g., SQL Server Management Studio). 2. Attach thew full log in you post.

LinusH

I don't have Viya at my fingertips, but given the documentation there is a Sub-flow step, given that you have at least SAS Studio Analyst License: SAS Help Center: About Subflows If you are having many "levels" of flows, you need to use Job flows in Environment Manager (since Sub-flows can't contain other Sub-flows): Tips for Scheduling Flows with SAS Viya Environment Manager - SAS Users

LinusH

Merged posts, duplicates.

LinusH

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

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

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

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.