I have a data set with 16 quarters of data for each included customer ID and numeric value. I need to see how the minimum value of that numeric value changes overtime. So I need to alter the number so it only changes when there is an new minimum value.   The data currently looks like this:   Customer ID | Date |     Numeric Value ABC123         12/31/17  80 ABC123         3/31/18    90 ABC123         6/30/18    75 ABC123         9/30/18    100 ABC123         12/31/18  110 DEF456         12/31/17   50 DEF456         3/31/18     40 DEF456         6/30/18     55 DEF456         9/30/18     60 DEF456         12/31/18   35   I need it to look like this:   Customer ID | Date |     Numeric Value ABC123         12/31/17  80 ABC123         3/31/18    80 ABC123         6/30/18    75 ABC123         9/30/18    75 ABC123         12/31/18  75 DEF456         12/31/17   50 DEF456         3/31/18     40 DEF456         6/30/18     40 DEF456         9/30/18     40 DEF456         12/31/18   35     I have tried using different lag values with minimal success. Any advise of potential solutions would be appreciated. ... View more

I have three data sets and I want to append of two them on each other then join the appended datasets to a third data set. See code below for sample data and existing process. I would like to get the same result as the Cust_ID_Check dataset in a single data step using the individual, company, and exist_check data sets.   data individual; input Record_ID Cust_ID $5.; datalines;   35 AD123 74 NEW 24 GH456 ; run;   data company; input Record_ID Cust_ID $5.; datalines;   21 YE789 62 AG&7 93 JI245 ; run;   data exist_check; input Customer $4. CN_ID $5.; datalines;   Sam AD123 Mia JI245 Jon YE789 Ben GH456 ; run;   Data TEST; set individual (keep=Record_ID Cust_ID) company(keep=Record_ID Cust_ID); run;   proc sql; create table Cust_ID_Check as select A.*, B.CN_ID from TEST as A left join exist_check as B on (A.Cust_ID=B.CN_ID); quit;   ... View more

I need a solution to remove all characters to the left of a specific string. See the example below:   I have the following transaction codes and need a way to isolate the portion of the string beginning with "4122":   Input Transaction Codes: 601412265320 714122892335 507741225009964   Desired Output Codes: 412265320 4122892335 41225009964   The solution can use the following assumptions: I am using Version 7.12 of SAS Enterprise Guide The Transaction Codes are character variables Every Transaction Code will include the string "4122" The string "4122" will only appear once in each Transaction Code The number of characters on either side of the "4122" string can vary.  The SCAN Function doesn't seem to work when I tried a multi-character delimiter (It treated 4, 1, & 2 as separate delimiters). If I can use "4122" as delimiter and pull the portion of the Transaction Code to the right of "4122" I can just concatenate "4122" back on the string later on. However, if there is a solution that directly generates the desired output code including "4122" that would be preferred.   Thanks, NW ... View more