I have two tables AC and DC, where the 'Account_Number' field is the merging key. I want to do a left join on both these tables where table AC is the left table. But I want this join to happen only when the variable 'Month' in table AC takes value=5. But I want to retain all the observations of table AC and the new variables that are coming from table DC to AC will only have values in cases where Month=5.   Will this way work?   PROC SQL; CREATE TABLE AC AS SELECT A.*, B.* FROM AC(where=(month=5)) AS A LEFT JOIN DC AS B ON A.KEY=B.KEY; QUIT;   Please help. Thanks! ... View more

I have a program which I need to run daily. So, I scheduled a trial run for it on SAS EG, and it approximately usually takes 1 hour to run. It is 10 mins past the run start time now, and how do I now confirm whether the program is running at all or not?  I am using SAS EG on Unix server.   Thanks! ... View more

I have a numerical variable which takes values of varied lengths. I want to add a decimal point before two last two digits in each value. For Example if the original value in a row is 180000, the new value should be 1800.00, and if its 5676456, the new value should be 56764..56   How can I achieve this? Please help ... View more

I have datasets with their names indexed on date, say ABC_20210424, ABC_20210425, ABC_20210426 and so on. I will be running this code daily where, on each day, I want to extract datasets for 60 days till yesterday. So, if today is APR 27,2021, my start date will be 26FEB2021 and end date will be 26APR2021. I have initialised two macro variables for these dates:   data _null_; call symputx('SD', put(intnx('day', today(), -60, 's'), yymmddn8.)); call symputx('ED' , put(intnx('day', today(), -1, 's'), yymmddn8.)); run;   Now how do I extract all the ABC tables from 26FEB to 26APR into one table, using a macro? Can a %DO statement help here? Thanks in Advance! ... View more

I want to create a macro variable which takes the date of the day before, and hence, its value changes each day. I am using the following code: call symputx('PREVIOUS_DATE' , put(intnx('day', today(), -1, 's'), date9.)); But the problem is that if yesterday was a Sunday, then I would require the macro to take the date of the day before yesterday. For example today id 26APR2021, and yesterday 25APR2021 was a sunday, so I want this macro to take value 24APR2021.   Is there a way to automate this using an if clause or anything else? ... View more

I want to create two macro variables, one for start date and one for end date, both in date9. format. the start date will be 60 days before today's date and end date will be 7 days before today's date. Suppose, today is 30APR2021, then I can create macros like this: %let start_date= 01MAR2021;  %let end_date= 23APR2021; But the problem with this is that I have to run this code on a daily basis which means that each day I will have to change the values of the macro variables. So I want to automatize it in a way that if I am running the code on 01MAY2021 (T) suppose, then the macros will automatically take Start date= 02MAR2021 (T-60) and End date = 24APR2021 (T-7).   Is there any way to automatize these macros to become dynamic and  to take values based on the current date?   ... View more

This is in continuation from my last question (which was solved). The last question was: I have data on spends for a group of people, begining from their very first spend. The spends amount is somewhere positive and somewhere negative (denoting Credit or Debit).I have to pick all those transactions where we have a negative spend happening within 7 days of any positive spend. My data is like this: NAME Date Amount A 3-Jan 400 A 4-Jan 2000 A 5-Jan 3 A 6-Jan 23 A 7-Jan -2400 A 8-Jan -32 A 9-Jan 400 A 10-Jan -340 B 2-May 987 B 3-May -453 B 4-May 544 B 5-May 765 B 6-May -456 C 5-Apr 888 C 6-Apr 1000 C 7-Apr 250 C 8-Apr 450 C 9-Apr 654 C 10-Apr 1000 C 11-Apr 240 The lookup or iteration will reset each time we have a positive spend. For example in row no. 8 for A, we have a positive spend again after negative spend, so we will now again look within 7 days after this spend, and if we encounter any negative spend, the flag will be created. The resultant data will look like this:   NAME Date Amount Flag A 3-Jan 400 1 A 4-Jan 2000 1 A 5-Jan 3 1 A 6-Jan 23 1 A 7-Jan -2400 1 A 8-Jan -32 1 A 9-Jan 400 1 A 10-Jan -340 1 B 2-May 987 1 B 3-May -453 1 B 4-May 544 1 B 5-May 765 1 B 6-May -456 1 C  5-Apr 888 0 C  6-Apr 1000 0 C 7-Apr 250 0 C 8-Apr 450 0 C 9-Apr 654 0 C 10-Apr 1000 0 C 11-Apr 240 0 I have been able to create this flag with the help of @Shmuel . Now my requirement is that I want to take all the sum of positive amounts and the sum of negative amount wherever the negative amount has appeared within 7 days of the positive amount, i.e., where the flag is 1. So against every negative amount with flag=1, 2 variables will be populated, sum of positive amounts(within the last 7 days) and absolute sum of debit amounts. The data will look like this:   NAME Date Amount Flag Positive_sum Negative_sum A 3-Jan 400 1     A 4-Jan 2000 1     A 5-Jan 3 1     A 6-Jan 23 1     A 7-Jan -2400 1 2426 2400 A 8-Jan -32 1 2426 2432 A 9-Jan 400 1     A 10-Jan -340 1 2826 2772 B 2-May 987 1     B 3-May -453 1 987 453 B 4-May 544 1     B 5-May 765 1     B 6-May -456 1 2296 909 C  5-Apr 888 0     C  6-Apr 1000 0     C 7-Apr 250 0     C 8-Apr 450 0     C 9-Apr 654 0     C 10-Apr 1000 0     C 11-Apr 240 0                   Please help me on this. Thanks a lot!   ... View more

I have data on spends for a group of people, begining from their very first spend. The spends amount is somewhere positive and somewhere negative (denoting Credit or Debit).I have to pick all those transactions where we have a negative spend happening within 7 days of any positive spend. My data is like this: NAME Date Amount A 3-Jan 400 A 4-Jan 2000 A 5-Jan 3 A 6-Jan 23 A 7-Jan -2400 A 8-Jan -32 A 9-Jan 400 A 10-Jan -340 B 2-May 987 B 3-May -453 B 4-May 544 B 5-May 765 B 6-May -456 C 5-Apr 888 C 6-Apr 1000 C 7-Apr 250 C 8-Apr 450 C 9-Apr 654 C 10-Apr 1000 C 11-Apr 240 The lookup or iteration will reset each time we have a positive spend. For example in row no. 8 for A, we have a positive spend again after negative spend, so we will now again look within 7 days after this spend, and if we encounter any negative spend, the flag will be created. The resultant data will look like this:   NAME Date Amount Flag A 3-Jan 400 1 A 4-Jan 2000 1 A 5-Jan 3 1 A 6-Jan 23 1 A 7-Jan -2400 1 A 8-Jan -32 1 A 9-Jan 400 1 A 10-Jan -340 1 B 2-May 987 1 B 3-May -453 1 B 4-May 544 1 B 5-May 765 1 B 6-May -456 1 C  5-Apr 888 0 C  6-Apr 1000 0 C 7-Apr 250 0 C 8-Apr 450 0 C 9-Apr 654 0 C 10-Apr 1000 0 C 11-Apr 240 0   How can I acheive this? It would be really helpful if someone would help on this. Thanks!       ... View more

I have a list of strings which contain both alphabets and numericals. I want to keep only those strings which contain only alphabets or a combination of alphabets and numerics. I want to remove strings which contain only numericals. How do I achieve this? ... View more