About LinusH

LinusH

Placing office files in SharePoint and in Teams let you edit the file simultaneously, perhaps this also works for SAS access? Haven't tried since my SAS server can't access those due to firewall rules.

LinusH

SAS is communicating with Git from the DI Studio client, not the server., and this is where the local repo is kept. What does the git config --global -l command give you? Did the "initialize Repository" work without any messages?

LinusH

Haven't used much. But a pro for NFS that you might need as much total disk for your work. But if performance is important, chances are that you probably can get faster disk access with locally mounted disks. To verify, test and/or discus with your infrastructure team.

LinusH

You might find some formulas that calculates this. But the easiest way is to take a subset and test yourself. Things might affect result if you have compression on your data and indexing. I'm usually pro long dataset over wide, but this is an extreme, key-value-pair model which is usually not useful for human usage. What is the purpose of this re-modelling?

LinusH

You macro variable is over 3100, so $2500 is not enough. I see that you also have double spaces, added compbl() if you want to get rid of those. data _null_; length b_allv_Y $4000; b_allv_Y = "'" || tranwrd(compbl("&allv_Y"), " ", "' '") || "'"; call symputx('b_allv_Y', b_allv_Y); run;

LinusH

Ok, here's my shot at it: data want; set work.kpi_data; retain prev_flag_kpi prev_diff; by SubjectId notsorted; if first.subjectId then do; prev_flag_kpi = .; prev_diff = .; end; else do; if prev_flag_kpi = 1 and flag_KPI then do; if (-21 <= prev_diff <= 0 and 0 <= differences_in_days <=7) or (-21 <= differences_in_days <= 0 and 0 <= prev_diff <=7) then Flag_Consecutive = 1; end; end; if not last.SubjectId then do; prev_flag_kpi = flag_KPI; prev_diff = differences_in_days; end; run; I'm noting the data is not sorted on SubjectId. As a data person I'm missing a clear unique key for each row, like a sequence no, or date.

LinusH

Please attach data using a data step and datalines. Also, try to visualize your requirement as an output data set. What have yo tried so far?

LinusH

From user perspective: there are no formatting options in quick reply. Also, after you have replied you can back out directly to the previous screen. The normal reply will back you back only to the post.

LinusH

Since the SW is distributed by you university, you should contact them for support.

LinusH · ‎11-25-2025

Please share the full log, with options fullstimer msglevel=i; If you have the possibility, monitor you server while your export is running (CPU, MEM, I/O).

LinusH · ‎11-25-2025

I think you are comparing apples and pears. Snowflake is basically a database, SAS is an analytics tool with data management capabilities. Sure, there are some overlap. What is your use case ad requirements?

LinusH · ‎11-24-2025

If I remember correctly, CA should be able to collect data from all tiers. The need to move & merge data occur if you want to assess more than one environment, e.g., dev, test, prod.

LinusH · ‎11-21-2025

Troubleshooting 101, print the values of your operations to the LOG. ICD10Code_1 = substr(ICD10Code,1,1); put ICD10Code_1=; Alignment issues can be solved using LEFT() function.

LinusH · ‎11-19-2025

Once your prio logic is in place, you can use SQL, something like: proc sql; select id, pdl1, priority from have group by id having max(priority) = priority ; quit;

LinusH · ‎11-19-2025

But in your picture, both are HTTP, one should med "host".