Apr
5
awarded Yearling
Apr
5
awarded Yearling
Mar
24
awarded Yearling
Mar
24
awarded Yearling
Mar
16
comment Books to study for Math GRE, self-study, have some time.
@sam_rox "Learning several entirely new subjects will take months, probably more time than you have, and will end up adding just a few points to your score. Mastering the subjects you have already had will help your score much more." This is my opinion.
Mar
1
accepted SAS Macro variable to represent what is in an IN statement in Proc SQL
Mar
1
accepted Use array variables in subsetting IF without specifying number of array variables
Mar
1
accepted Get latest cumulative sales amount for various evaluation dates in SAS
Mar
1
comment Get latest cumulative sales amount for various evaluation dates in SAS
This appears to do exactly what I need. Thanks so much. I am thinking I probably learned this about SAS at one point, but I know for sure I forgot it until now.
Feb
29
comment Get latest cumulative sales amount for various evaluation dates in SAS
As an alternative to the current method, I could do an INNER JOIN of the two tables on transaction_date <= end_date. The issue is it would create a lot of rows I don't want as it's a many-to-many join. It would be great if I could pair this with ordered analytical functions (max over partition by, etc.) to only keep the latest transaction before each evaluation date, but it appears those are not supported in SAS.
Feb
29
comment Get latest cumulative sales amount for various evaluation dates in SAS
I made everything clearer, I hope, including example tables and a basic description of the current process.
Feb
29
revised Get latest cumulative sales amount for various evaluation dates in SAS
added 1112 characters in body
Feb
26
asked Get latest cumulative sales amount for various evaluation dates in SAS
Feb
26
accepted Put list of values into several macro variables in SAS
Feb
23
comment Put list of values into several macro variables in SAS
Hmm, yes, you are correct. +1. There's some existing code that uses the current format and I'm not in control of that code. So, I'm trying to use it so I don't have to recode all the dates manually. But, your point is that if I had control, I could just define the different macros separately and then put them together into one datelist, if necessary.
Feb
23
asked Put list of values into several macro variables in SAS
Dec
25
awarded Good Answer
Dec
23
awarded Famous Question
Dec
9
awarded Notable Question
Dec
4
awarded Announcer
1 2 3 4 5