In my company, I run a process once a month after another one is finished. To know that it is finished, I manually look at the following table (it has about 100 more rows in reality):    Latest date for finishing the process Date when the process was finished Process has begun 31-jan-22 05-jan-22 1 28-feb-22 04-feb-22 1 31-mar-22 03-mar-22 1 30-apr-22 05-apr-22 1 31-maj-22 . 0 30-jun-22 . 0 31-jul-22 . 0 31-aug-22 . 0 30-sep-22 . 0 31-okt-22 . 0 30-nov-22 . 0 31-dec-22 . 0 31-jan-23 . 0 28-feb-23 . 0 31-mar-23 . 0 30-apr-23 . 0   Assuming we are currently standing in april-2022.  Since there is a date (05-apr-22) in the column "Date when the process was finished" I know that the process has been finished and I can run my process. An extra sanity check is that the column "Process has begun" should have a 1 in the row for the relevant month. So if there is a date in the relevant row I should run my process. BUT, this should only be done once every month. Next month, in May I will every day look when the middle column gets an date:  31-maj-22 . 0   when it has I will run my process.  Obviously, this is a manual process that can be automatized and my goal is to set up an SAS Program that perfroms the test (say once day) which will be done automatically by scheduling the SAS program. Any advice how I could write a SAS program to perform the desired test? I also want to emphasize, that if we are standing in april 2022 for instance:  30-apr-22 05-apr-22 1 then the 05-apr-22 I could run my process, but I should not run it anymore that month, so I should continue to next month and check when there comes an date.  I also know that in the column "Date when the process was finished", when there is something filled up it should be the same month and year as in the column: Latest date for finishing the process. Else something is wrong.  I hope it is clear what I mean, appreciate your help!  ... View more

Assume I in principe have observations in a SAS data set of the form (with over 10 million rows so this is just "a piece of the data"):  Customer_ID  Country Male_Flag below_40_years over_40_years 1 USA 1 1 0 2 UK 0 0 1 3 GER 0 0 1 4 USA 1 1 0 5 UK 1 0 1   If the below_40_years_flag = 1 that means you are less than 40 years old.  Now I would like to take a couple of random sample containing 100 customers each.  For the first random sample: You should be from USA, be a Male (Male_Flag = 1) and be below 40 years old.  For the second random sample: You should be from UK, a woman (Male_Flag = 0) and be above 40 years old.  In my real example, I have around 5 criterias (Country, Age, Gender, ...) and want to take around 15 random samples. So the example above just illustrates the point and it could be solved "mechanically" but in my real example it would get extremly messy.  Any ideas?    ... View more

In my organization, we send many mails through through SAS automatically. So it makes sense to write a macro/function for this.  Before starting to write my own it would be awesome if you could share what you/others have done in this front that you know of and that could work as a inspiration or even template. In best case, someone might even have written a "finished macro" that I can reuse.  All tips appreciated.  ... View more

My organization has recently chaged/updated to Viya meaning that we have done a switch from Windows to Linux.  For some libnames (it seems like it is SQL databases - all libnames I have encountered the problem on so far is on SQL databases) I cannot see the tables in the libname from SAS Enterprise Guide, although I can use them as normal, for example by a data step or proc print.  So to make it more clear, this is basically how it looks on the Viya server (I only see the libname but cannot see the corresponding tables):      And this is how it looks like on the older version, Windows server (I can see the libname and the corresponding tables):    It is quite annoying, any ideas on what the problem could be or how to solve it?  ... View more

My organization has recently chaged/updated to Viya meaning that we have done a switch from Windows to Linux.  For some libnames (it seems like it is SQL databases - all libnames I have encountered the problem on so far is on SQL databases) I cannot see the tables in the libname from SAS Enterprise Guide, although I can use them as normal, for example by a data step or proc print.  So to make it more clear, this is basically how it looks on the Viya server (I only see the libname but cannot see the corresponding tables):      And this is how it looks like on the older version, Windows server (I can see the libname and the corresponding tables):    It is quite annoying, any ideas on what the problem could be or how to solve it?  ... View more

I have the following simulated data which I create:  %macro monteCarloSimulation(); %let covariates=300; /* Number of covariates (independent variables) */ %do mcno=1 %to 100; /* Number of simulated datasets = 100 */ data logit_data; drop i j; array x{&covariates.} x1-x&covariates.; do i=1 to 1000; do j=1 to &covariates.; x{j}=ranuni(1); end; linpred=2+10*x17-8*x5+3*x2+7*x6-5*x3-12*x30+11*x130-12*x200+rand("NORMal"); prob = exp(linpred)/ (1 + exp(linpred)); y = (prob > 0.5); output; end; drop prob linpred; run; /* Here I would like to run stepwise forward regression and stepwise backward regression and store the corresponding AIC values to produce the table referenced below. This should be done for each table that i produce in the simulation Note that 100 simulated tables are produced */ %end; %mend monteCarloSimulation; %monteCarloSimulation() From that simulated data, I would like for each simulated dataset to calculate:  - AIC from a stepwise forward regression.  - AIC from a stepwise backward regression.  - If possible (I will read up on this later) AIC from a Lasso regression.  And then finally store the AIC values in a table of the format:    AIC_Forward_Stepwise_Regression AIC_Backward_Stepwise_Regression AIC_Lasso Simulation1        SImulation2       .       .       .       Simulation100       Ideally, I would also like to finally produce some summary statistics for evaluating which model-selection scheme performs best:    Forward_Stepwise_Regression Backward_Stepwise_Regression Lasso Mean AIC       STD        Median AIC       25% quantile       75% quantile        This would be easily done in other programming languages and I guess so in SAS aswell, but are not used to doing statistical analysis in SAS (yet).  All help appreciated.  ... View more