topic Re: Assigning Repeating Values Based on Repeating IDs in New SAS User

Assigning Repeating Values Based on Repeating IDs

chsprogramming — Tue, 12 Sep 2023 15:30:16 GMT

I have a dataset where I need to make sure that each like ID gets assigned the same Value. It's not so much that I need to select a specific value to repeat from all that are assigned to the like ID, but that I need all the like IDs to have the same Value.

Data Have:

Data Want:

 Id   Value   Selected
101   656     656
101   756     656
101   805     656
101   752     656   
501   999     999
502   405     999
502   365     999

Re: Assigning Repeating Values Based on Repeating IDs

PaigeMiller — Tue, 12 Sep 2023 15:46:06 GMT

data want;
    set have;
    by id;
    retain selected;
    if first.id then selected=value;
run;

Re: Assigning Repeating Values Based on Repeating IDs

antonbcristina — Tue, 12 Sep 2023 15:58:03 GMT

Suppose you had the chosen values in a dataset have2 (completely made up based on the values you're displaying):

ID  Selected
101 656
501 999
502 999

Then a PROC SQL left join will do the trick:

proc sql;
    select t1.id, t1.value, t2.selected
    from have as t1 left join have2 as t2
    on t1.id = t2.id;
quit;