Ok Here is Plan A dataset PLAN REQUIREMENT LINE# CDATE A RED 1 C024 B YELLOW 2 C025 C BLUE 3 C026 D GREEN 4 C027 Ok Here is Plan B dataset PLAN REQUIREMENT LINE# CDATE A RED 1 C024 B YELLOW 2 C026 C BLUE 3 C026 D GREEN 4 C028   When I merge the datasets together, I only want it to populate the lines that have changed. This is the end result that I want PLAN REQUIREMENT LINE# CDATE B YELLOW 2 C026 D GREEN 4 C028   Can someone please assist? Thank you. ... View more

I am trying to change the 4th character in a string. The 4th character consists of numbers and letters. The code that I used changes the entire string to all x's. Please see code. Any assistance will be greatly appreciated.    Data Want; set DATASET1; do _N_=2 TO length(code); substr(code,_n_,4)=byte(mod(rank(char(code,_n_))+&offset,255)); end; run; This is the original data  DATASET 1 CODE 0S124 0R123 0T435 0F5F3 0R4RY   This is what I want  DATASET 2 CODE 0S1X4 0R1X3 0T4X5 0F5X3 0R4XY   Here are my results CODE XXXXX XXXXX XXXXX XXXXX XXXXX ... View more

I have two datasets and there are a couple of things that I would like to do. 1.) Dataset1 has the variables: Code, Description, Type. Dataset2 has just the code but it is masked. I would like to first mask the code variable in dataset1 with an "X" as the 4th character replacement in the string. Then I would like to take Datasets 1 & 2 and match the masked with the unmasked to create the dataset below. Also, I wanted to know if there was a way to partially match merge the datasets to get the results below. The only code that I have is the merging. All it is doing is stacking the data not replacing the data as expected. 2.) I wanted to see if I could link the variables code to the description (i.e. 2Y5X1 will always be associated with Description: Apples and Type: A. What I have been doing is the long way...manually changing it in excel, sorting it by ascending, copying it back into dataset 1.  I hope that my question is clear. Please see below.   DataSet1           Code Description Type           2Y521 Apples A           2Y522 Oranges O           2Y523 Bananas B           2Y524 Pears P           2Y525 Grapes G           2Y526 Raspberries R           2Y527 Kiwi K           2Y528 Cantaloupe C                           DataSet2       Mask Dataset to Look like this with the X as replacement for the 4th character in a string                       Code               2Y5X1               2Y5X2               2Y5X3               2Y5X4               2Y5X5               2Y5X6               2Y5X7               2Y5X8                               Then Merge with DataSet1 to Match DataSet2         DataSet2 Description Type           2Y5X1 Apples A <---Then always associate 2Y5X1 with Apples and A 2Y5X2 Oranges O           2Y5X3 Bananas B           2Y5X4 Pears P           2Y5X5 Grapes G           2Y5X6 Raspberries R           2Y5X7 Kiwi K           2Y5X8 Cantaloupe C           /*This is after I mask it in excel and import*/ proc sort data=dataset1; by code; run; proc sort data=dataset2; by code; run; Data Merge; merge dataset1 dataset2; by code; run; ... View more

Data DupA set Duplicates /*I sorted out all of the duplicates I don't want to do that*/ if first.id= 1 then 'AD RSN'n="h"; if last.id = 1 then 'AD RSN'n="h" run; Hello,   I have two things that I would like to address. First, I want to see if my dataset has a duplicate, then if it does I want it to change another variable (AD RSN) to the character "H". Please see the before info and after. I sorted out all of the dups but I would prefer not to do that. I would prefer sas code. I am new to sas so I need layman terms please. Please see code. This is what I have right now: Name ID AD RSN A 12345 I   12345   B 67890 I   67890   C 25489 I   25489   *~*~*~*~*~**~*~*~*~*~*~*~*~* This is what I want it to look like: If there is a dup ID, then change both AD_RSN to H. Name ID AD RSN A 12345 H   12345 H B 67890 H   67890 H C 25489 H   25489 H   Your response will be greatly appreciated.   ... View more