I am running into a problem where I would like to duplicate data from one row that contains data to other rows with the same key value, but does not contain any additional data. However, ONLY conditioned if variable 3 or V3 is equal to “Cardio”. For instance. I have a dataset that looks like this.

key V1 V2 V3 V4 V5
21484242|35 blue five Cardio Microsoft CLU
21484242|35
21485736|27
21487732|18

The first two row contain the same key, but the second row does not contain any other information other than the key (no value for v1,v2, v3 etc.) Because the first row has “cardio” for V3, this row would need to be duplicated to the second row that does not contain the information. How am I able to do that in SAS? Thanks in advance.