Hi, I am trying to calculate how many times different suppliers have provided a name and address. What I need is for the value of the supplied variable for last.UID to be applied to all observations of that UID so that when I later class by each supplier I get an accurate count of the total time that record has been supplied. Current code: data new; set supplied1; by uid; if first.uid then do; supplied=0; end; supplied=supplied+1; retain supplied; if last.uid; run; I can do this in a number of steps but I have a feeling there is a much simpler way of doing it! Thanks
... View more