Hello,   I have a dataset like this with hundreds of additional columns and thousands of rows:   First_name | Last_name | Version | Total_payment Scott | Smith | 1 | $100 John | Smith | 3 | $10 Michael | Scott | 2 | $50 Michael | Scott | 3 | $75 Michael | Scott | 4 | $100 Michael | Jordan | 1 | $20 Michael | Jordan | 2 | $50   I'm looking for a (hopefully) slick way of updating the table so it only includes rows for the latest version of each unique First/Last name combination, like this:   First_name | Last_name | Version | Total_payment Scott | Smith | 1 | $100 John | Smith | 3 | $10 Michael | Scott | 4 | $100 Michael | Jordan | 2 | $50   The dataset is also not necessarily sorted in any way like I have it presented here. Is there any simple way of achieving this?   ... View more

Hello,   I have Table1 with a "Name" column and an "ID" column. All values in the "Name" column are unique from one another. However, the "ID" column is completely blank; there are no values populated.   I also have Table2 that has the same "Name" and "ID" columns. It has all the same "Name" values from Table1, but the names are in a different order. The "ID" values are all populated in this table.    What is the easiest way for me to populate the "ID" column in Table1 using the "ID" values from Table2? The "Name" values are ordered completely differently in both tables, but I need to make sure to match up the correct "ID" values for each name. I need to keep everything about Table1 the same - particularly the way that the rows and columns are ordered.   Any help would be greatly appreciated!   ... View more

Hello,   When I try to open the Ctrl+F window in SAS 9.4, the window no longer appears. The SAS session becomes grayed out when I press Ctrl+F which makes me think that the Ctrl+F window may be somewhere off screen. I saw a suggestion online about using Alt+Space then clicking Move, however, this is not working for me no matter what arrow keys I try using.   Can someone please help me or provide more detail regarding how I can regain the Ctrl+F window?   Thank you. ... View more

Hello,   I am struggling to incorporate three different macro variables into a program that otherwise works just fine. I've tried searching for solutions online, but am struggling to find anything that fixes these problems.   The macro variables are set up at the beginning of the program: %let month_number = 8; %let month = 202308; %let day = 20230831;   Firstly, I am trying to create a table: data table2;     set table1;     if PROCESS_YYYYMM <= (INCURRED_DT_YR_2) * 100 + &month_number.     then... ... I'm getting a syntax error when I try using the &month_number. variable.   Secondly, the program has a step where it connects to a server and creates a table with the following WHERE statement: WHERE t1.PROCESS_YYYYMM between '201601' and '202308' and t2.INCURRED_DT_DAY between '20160101' and '20230831' The program works just fine like this, but I'd like to incorporate the &month. and &day. variables in lieu of the end dates shown here. How do I need to format this? I've tried a number of different possibilities with apostrophes, quotation marks, and even tried using a %syslput line for each variable before this table gets created, but nothing that I've tried seems to work. I keep getting ERROR: CLI execute error and the table doesn't get created.   Any help greatly appreciated! ... View more