Hello ,   I do not understand the simple twist. What exactly do you try to achieve?   Can't you start from the regular EWMA / EMA (in SAS/ETS PROC EXPAND) and do some post-processing?   Solved: N day Exponential Moving Average - SAS Support Communities Compute a moving average in SAS - The DO Loop Ciao, Koen ... View more

I think it's solved when you put the %LET statement after the data step.   run; %let cyear=%sysfunc(substr(&a.,65,4)); %put &=cyear; Ciao, Koen ... View more

I do not have an answer for you top-of-my-head , ... but you might consult this blog-article. It also contains links to doc and other articles. Maybe you will find your hidden diamond in there? The SG annotation macros in SAS By Rick Wicklin on The DO Loop  September 13, 2023 https://blogs.sas.com/content/iml/2023/09/13/sg-annotation-macros.html   Ciao, Koen ... View more

First, I would make mosaic plots for visualization: Create mosaic plots in SAS by using PROC FREQ - The DO Loop How to specify mosaic plot colors in SAS - The DO Loop Color cells in a mosaic plot by deviation from independence - The DO Loop How to add an annotation to a mosaic plot in SAS - The DO Loop Then compare proportions. For dependent samples : 22562 - Testing the equality of proportions from dependent samples For independent samples :  22561 - Testing the equality of two or more proportions from independent samples Test for the equality of two proportions in SAS - The DO Loop You can also take a modelling approach, but first you can try with statistical hypothesis testing.   Ciao, Koen ... View more

pertinent remark @PaigeMiller .   I enriched the solution of @Ksharp with an extra line to have the single quotes around the formatted date. %let mm=09; %let yyyy=2025; %let calculatedDate = %sysfunc(INTNX(MONTH, %sysfunc(MDY(&mm., 1, &yyyy.)),0,e),yymmdd10.); %put &=calculatedDate; %let calculatedDateWithSingleQuotes = %str(%')&calculatedDate%str(%'); %put &=calculatedDateWithSingleQuotes;   Ciao, Koen ... View more

Solved: How to find the last day of the month - SAS Support Communities   Compute the first or last day of a month or year - The DO Loop   Ciao, Koen ... View more

undersampling the majority class in your binary classification model might be worthwhile oversampling the minority class  in your binary classification model might be worthwhile  MITIGATING THE EFFECTS OF CLASS IMBALANCE USING SMOTE adding business features might be worthwhile!! (extra inputs or derived or composite inputs that are also relevant for explaining and predicting the target) calculating statistical and machine learning features might be worthwhile. e.g. in Enterprise Miner there is a node for variable clustering. Cluster your variables and model with the 1st principal component of every cluster as inputs / candidate predictors. do not forget to adjust your posterior probabilities for the real priors. you can use the target profiler for this. Prior Probabilities :: SAS(R) Enterprise Miner(TM) 14.1 Extension Nodes: Developer's Guide Search the best threshold that gives good balance between precision and recall (true positive rate). Or look at the F1-score. https://en.wikipedia.org/wiki/Confusion_matrix Ciao, Koen ... View more

@StatDave wrote: ... and there are methods discussed in this note for dealing with that.  Topic = adjusting the posterior probabilities for the real priors after under-sampling the majority class in binary classification.   If you want some additional prose on that topic and on that note (mentioned by @StatDave) , see here : SAS Help Center: Prior Probabilities SAS Help Center: Handling Rare Events   Ciao, Koen ... View more

Hello ,   There is no option MOOD in your PROC NPAR1WAY statement. So you have not requested an analysis of Mood scores. Are you sure about having any output based on Mood scores?   You have requested an analysis of Wilcoxon scores (WILCOXON option). When there are two classification levels (samples), this option produces the Wilcoxon rank-sum test. For any number of classification levels, this option produces the Kruskal-Wallis test.    Mood's Median Test is particularly useful when there are significant outliers, as it is less sensitive to them than the Kruskal-Wallis test.   Good luck, Koen ... View more

It has probably something to do with numeric values in the SAS System being represented as IEEE double-precision floating-point numbers. SAS Help Center: Numeric Precision   data _NULL_; file print; x=36; y=3.6; z=(y-x)/x*100; put z= 25.15; if z=-90 then do; put '1. hurray ; z equals -90'; end; if int(z)=-90 then do; put '2. hurray ; z equals -90'; end; if floor(z)=-90 then do; put '3. hurray ; z equals -90'; end; if ceil(z)=-90 then do; put '4. hurray ; z equals -90'; end; if round(z)=-90 then do; put '5. hurray ; z equals -90'; end; run; /* end of program */ Ciao, Koen ... View more

A Wiener process (or Weiner process) is a special case of a diffusion process.    Here's how you simulate a Wiener process :  https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/How-to-simulate-a-Weiner-process-in-SAS/td-p/203411   Ciao, Koen ... View more

I don't think SAS has diffusion models as a standard feature of the (econometrics part of the) software. Diffusion models are used for time series forecasting ... mainly when the time series (before forecasting) is short.   You can estimate "Jump Diffusion" though: https://support.sas.com/resources/papers/proceedings20/5079-2020.pdf   Not sure why you have asked this question in the "Operations Research / Management Science" - board , and not in the "econometrics / forecasting" - board.   Ciao, Koen ... View more

@Tom wrote: So now that I have access to SAS Viya I see that it has a command line tool named sas-viya that has a concept called batch that appears to be able to do the same thing.  The syntax is different, but I can adapt to that.    But what is confusing me is that ... Unfortunately this is not an answer that will take away your confusion. I just want to put some links here for people wanting to use the "SAS Viya Command Line Interface Plug-ins". And more specifically the batch plug-in.   How to Run SAS Programs in Batch in the New SAS Viya Started ‎07-APR-2021 | Modified ‎05-JUN-2022 | Views 22,580 by Bogdan Teleuca https://communities.sas.com/t5/SAS-Communities-Library/How-to-Run-SAS-Programs-in-Batch-in-the-New-SAS-Viya/ta-p/732126   SAS Help Center: Set Up the batch Plug-in   Ciao, Koen ... View more