About LinusH

LinusH

This step uses SQL, and SQL does not aggregate based on formats. So what you need to do is transform this column, by using put(LaDate,YYWEEKV5 .).

LinusH

I don't have access to Viya 4 at this point. But it seems there is no OOTB functionality for this. It seems that you could implement this on a Flow instance level, by pointing out a program to execute when a job flow exits: https://documentation.sas.com/doc/en/sasadmincdc/v_071/evfun/n0b9cf8ru47gp6n1lvamxqwbr3by.htm#p00388x4a7b6ywn1ce2d03tz88ns

LinusH

Ok, I don't have access to Studio Engineer at this point to try myself. What does the "i" symbol say if you click/hoover over it? You should compare data type and columns lengths for your datasets.

LinusH

It's hard from just one screenshot to tell what's wrong. Maybe you could attach the generated SAS code?

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 · ‎12-15-2025

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 · ‎12-09-2025

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 · ‎12-08-2025

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 · ‎12-04-2025

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 · ‎12-04-2025

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 · ‎12-04-2025

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 · ‎12-04-2025

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?