Only way that i think you will be able to do this is via code. I would use SAS STudio and connect to a cas session.   With datastep syntax below. There might be a different way but here is what i came up with.   cas mySession sessopts=(caslib=casuser timeout=1800 locale="en_US");   libname caspub cas caslib=public; /*libname to the CASLIB that contains data*/   proc sort data=caspub.book1 out=work.book1; by ID Created_Date  Activity_Date; run;   data work.book1;     set work.book1;     by ID Created_Date  Activity_Date; if first.ID=1 then do; diff=Activity_Date-Created_Date; end; run;   Hope this helps.   Carmine ... View more

Unfortunately , that is a hard question to answer as it depends on your client grid setup.   Do you have lsf client installed? Are you using sas/connect? You might want to speak to your sas Admin/Grid Admin to help you figure this out as there are several factors that maybe be the cause of you not seeing those jobs. Here is one example. If you are using sas/connect to connect to the grid then there is no way to see your connections in the grid.   ... View more

I had to recreate the sample code that you send as it did not work.  You have not replied stating the result you are trying to accomplish so not sure if this answers your question.   data test_weekly; infile cards; input ID NAME $ sc1 $ sc2 $ sc3 $ sc4 $ sc5 $ sc6 $ ; array sc{6}; do i=1 to 6; if sc(i) in('A', 'B', 'C') then do; /* insert code here*/ end; end; cards; 1 Bob D A E D A E 2 Sam A D F D A E 3 Mike B D E D A E 4 Al D E E D A E 5 Steve A S D D A E 6 Sara A E E D A E 7 Tom S S D D A E run;     ... View more

Can you please provide a sample data source and the result you are trying to obtain please.   Without these its very difficult to help you figure out a solution.   Thanks     ... View more

Hello,     Normally we ask that you provide a sample data source and the result you are trying to accomplish. It is not clear what you are trying to accomplish with arrays.   ... View more

I am assuming that you are the SAS administrator if you are getting alerts and have taken some SAS admin training, that being said you need to provide more information about your problem. You need to find the cause of the excess CPU consumption that is setting off this alert.  When the alter happens check the running processes and see which process is using all the CPU.   It could be that there are a few individuals that are using all the resources and this has nothing to do with the data.   It could be a wide range of things from your current system not being able to handle the load or users that are running long resource-intensive jobs. There is a simple solution to those, one upgrade your systems or get your users to start submitting those long-running jobs in the evening.   If you know who is causing the issue and want to separate them or limit their resources. There isn't anything that is easily done to accomplish this. You cannot limit the number of resources a SAS session can have but you can put those users on their own machine. You could add a new application server with a new workspace server on a separate machine(this will definitely affect your licensing agreement - $) but allow you to redirect these users to those resources on that machine and not affect anyone else. I would not have this documentation off hand and you would need to contact your Sales rep and then sas tech support for how to include a new Workspace server in your environment.   Hope this helps.   Carmine     ... View more

It's hard to say if increasing the buff size would help, it could just be that you are dealing with a large dataset that takes time to access. This type of question requires lots of benchmarking. The best way to do this would be to provide us with a sample dataset and code so we can test.  You can just use SAS Data instead of SQL Server and recreate your append so we can test ourselves.    If you decide that is too much work to provide a sample and would like to do your own benchmarking then you can use this SAS option to help. Fullstimer sas option FULLSTIMER SAS Option   You could also benchmark other programs in the future and collect performance metrics using a program that would read the log produced by your program to store those metrics. That program is called Logparse, I have included a link for your information.  219-30: Programmatically Measure SAS® Application Performance on Any Computer Platform with the New LOGPARSE SAS Macro   Hope this helps.   Carmine ... View more

This code seems to give me the want dataset . Take a look. Data thewant; merge have1(in=in1) have2(in=in2); by id; if in2; run; ... View more