@domroy, I can't find any clear migration path either. I seem that Federation Server is supported in Content Assessment, so if you haven't run that already, do. And I would contact your SAS representative with the overall strategy and plans for Federation Server sites. ... View more

Column length up 32 is no problem for SAS, but column name length has the same limitation as table name. If you have tables that you know comply with SAS naming standard (also beware of special character, spaces, initial digit etc) and they're not visible to SAS - try to connect to the database using the same credentials from another client using the same connection configuration. ... View more

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

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

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

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

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

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

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

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

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

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