Hi, I Have a table that has record with multiple dates. I need to create a dataset with each record with maximum date. The source table looks as below. ID STATE eff_date 123 CA 10/18/2017 123 CA 10/18/2017 123 NY 3/25/2018 123 NY 3/25/2018 234 AZ 1/1/2018 234 AZ 7/18/2018 234 ? 7/18/2018 I need to pick the ID and state with maximum effective date. I need to pick just one id and a state even though they have duplicates. Any logic for this ? Thanks ... View more

Hi, I have this SAS program which is supposed to be run monthly on the first weekday of the month. It has been scheduled to run daily through cron. Is there a way I can wrap this program in a macro that will execute only if it is the first weekday of the month otherwise will exit. Also to account for public/business holidays I have a calendar dataset which looks like this. Date Bus_ind Day_cd 1/1/2018 0 New Year’s Day 1/2/2018 1 Workday 1/3/2018 1 Workday 1/4/2018 1 Workday 1/5/2018 1 Workday 1/6/2018 0 Weekend Any suggestions or code example is highly appreciated. Thanks ... View more

Hi, I have this macro which I need to repeat multiple times so want to loop it instead. Sample 1: %macro check_list; %global list1; %if list1= % then %do; %let list1=“myname”; .... %end; %mend check_list; %check_list; Data test1; Set list1; Run; I need to repeat the same code for list2, list3 and list4 and also create data1, data2 , data3, data4. I tried to wrap the sample1 Code using. %macro loop; %do i = 1 %to 4; Sample1(replaced list1 with list& and data1 with data&i) Error: Attempt to %global a name(list2) which exists in a local environment. Any suggestions ? ... View more

Hi, I had this code which was running fine. %macro check_list; %global list; %if &list= %then %do; %let list=“myname”; (Other code) %end; %mend check_list; Now I had to loop this process so I updated it to below. %macro loop; %do i = 1 to 4; %macro check_list; %global list&i; %if &&list&i= %then %do; %let list&i=“myname”; (Other code) %end; %mend loop; %loop; %end; %mend check_list; But now I am getting this error. Error: attempt to %global a name (list2) which exists in a local environment. How can I get rid of this and run the program successfully. Any suggestions is appreciated. Thanks in advance. ... View more

Hi everyone, Is there any Sas function that returns the current date and time if it is a weekday but returns the next weekday’s date and time if it is saturday or Sunday ? Or do I need to write the conditional statement? If yes, any suggestions is appreciated. Thanks in advance ... View more

Hi,   I have a Teradata table, the data from which I need to group and insert into another Teradata table using SAS. The data in table HAVE looks as below.   TYPE       EMPNO           DATE              TRAN_ID          INDICATOR 001           123                  6/01/2018         2                          A 001            123                6/05/2018          1                          A 001            123                6/03/2018          5                          A 001            234                6/12/2018          3                          A     The Teradata table  HAVE I need to insert into has the following columns.   TYPE        EMPNO      DATE            TRAN_ID      COUNT   I need to group the records from HAVE table and insert into the FINAL table where indicator=A and type=001 and group the records by TYPE and EMPNO. The DATE should have the current date. But the issue I am having is with the TRAN_ID, it should have the tran_id of max(DATE) for each TYPE and EMPNO for eg. in case of emp 123 max date is 6/05 and its TRAN_ID is 1. It should look like this.   TYPE        EMPNO      DATE            TRAN_ID  COUNT 001             123            6/24/2018        1                3 001              234           6/24/2018        3                1   I hope this makes sense. And Thanks in advance.   Note: I am able to group other fields except the tran_id like this   proc sql; insert into table.final select a.TYPE,           a.EMPNO,           current_date as DATE,           a.COUNT from  (select type,          empno, count(*) as COUNT from table.HAVE where indicator='A' and type=001 group by 1,2) a; quit;     **??? tran_id ... View more