I've never used APM but it is interesting to note that you are getting > 86% compression on the ARTIFACTUSAGEDETAILS dataset. That suggests it contains a lot of empty space. To reduce it in size one obvious thought would be to reduce the history kept. You will need to analyse the dataset in more detail to understand why it has grown so much. Comparing it to an earlier and smaller version would be useful.   ... View more

In my experience cloud latency will depend a lot on the type of network connection you have between on-prem and cloud. Ideally a dedicated cloud private link should provide good performance. We are using such a connection between SAS and Snowflake and performance is very good.   With on-prem to on-prem dedicated fibre connections should be available and latency should not be an issue.       ... View more

I suggest you check your server disks IO performance with the SAS IO Test Utility before doing anything. ... View more

You can't leverage your local computer's performance advantage unless you switch some of your SAS processing to it. You could parallel process some steps using both your PC and your remote server at the same time.   Have you discussed the SAS server performance with your SAS administrator? In my experience if your PC outperforms your remote SAS server then there is something seriously wrong with the server resources available to you. You might also want to consider doing remote server processing after hours if it performs much better then.   ... View more

In my experience you don't need to do anything. If you are working in EG and open a SAS program then the name of it appears in the EG session title like so: In the above I just opened a SAS program called Staging _Extract.sas.   If you are working in an EG project, then the project name is automatically added to the EG window title as well:     ... View more

You need to provide the ALTER password on the MOVE option: Here's the link to the SAS doc with the above COPY statement. ... View more

I guess you've seen this then: https://communities.sas.com/t5/SAS-Viya-on-Microsoft-Azure/How-to-get-support-for-SAS-Viya-on-the-Microsoft-Azure/td-p/834841 ... View more

Are you using Azure Marketplace or just "normal" Azure? With normal Azure and the standard SAS licensing agreeement opening a SAS Tech Support track is your best option.  ... View more

My approach is to implement programs that don't have errors, warnings or unitialized variable notes to start with. That means something has changed if I then run the program and such messages are written.   Also I run all production programs via a scheduler where an email will be triggered if there is an error so I only need to look at programs that generate an email. I then check the bottom of the SAS log to see if there is an error summary which looks like this: ERROR: Errors printed on pages 710,714,716,722,723,724,726,727,735,740,741,742,743,745,746,755,756,757,758,759,760,766,767,768,770, 771,772,774,776,777,778,779,780,781,782,783,784,785,786,787,791,792,793. I then only need to investigate page 710 to start with. By following simple processes like this you can reduce your log searching considerably.   Also running your programs in SAS EG or SAS Studio will produce a log summary of errors and warnings and there are function keys to search through these:   ... View more

Agreed Right_Hours is already numeric, so you could do just this: proc means data = name2 median; var Right_Hours; run; You said you wanted age also included but how - by age band or something else? ... View more

@ChrisHemedinger - Thanks for the post Chris! Given we are still running on SAS 9.4M2 I realised this issue also affects us so this is timely indeed. I've implemented the recommended change and it fixes an error in our business-critical processing.  ... View more

How about this? data want; keep word; concat_location = "Los Lunas/Corona/Corona/White Mountain/White Mountain"; do i = 1 to countw(concat_location,"/"); word = scan(concat_location, i, "/"); output; end; run; proc sort data = want nodupkey; by word; run; data want; keep concat_location_dedup; set want end = eof; retain concat_location_dedup; length concat_location_dedup $ 1024; concat_location_dedup = catx("/", concat_location_dedup, word); if eof; run; ... View more

An alternative to manipulating SAS user metadata programmatically is to sync it from your security system (for example Active Directory). SAS provides the programs to do this and you can read about it in this link.  We use this ourselves and it does avoid a lot of extra user metadata maintenance. ... View more