About hameliz

hameliz · ‎12-28-2023

I just did some searching and added it like this proc sort data = medrec2; by medrec results;run; data medrec3; set medrec2; by medrec; if first.Medrec then do; retain growth; if results = 'Growth' then growth = 'y'; else if results = 'No Growth' then growth = 'n'; end; run; and it worked!!! thank you 🙂

hameliz · ‎12-28-2023

Thank you! Where would I put 'Retain'? And there are only two options = 'Growth' or 'No Growth'. thanks!

hameliz · ‎12-27-2023

Hello! I am trying to assign a value to duplicate rows. This is the data I have: Medrec Results 771441 Growth 771441 Growth 771441 No Growth 771441 No Growth 771441 No Growth This is the data I want: Medrec Results Growth 771441 Growth Y 771441 Growth Y 771441 No Growth Y 771441 No Growth Y 771441 No Growth Y This is what I've tried but I only get one row to have Growth = 'Y' proc sort data = medrec2; by medrec results;run; data medrec3; set medrec2; by medrec; if first.Medrec then do; if results = 'Growth' then growth = 'y'; else if results = 'No Growth' then growth = 'n'; end; run; Thank you!!

Online Status	Offline
Date Last Visited	‎12-28-2023 03:28 AM

Re: Assign one value to duplicate variables across rows

Re: Assign one value to duplicate variables across rows

Assign one value to duplicate variables across rows

Re: Assign one value to duplicate variables across rows

Re: Assign one value to duplicate variables across rows

Assign one value to duplicate variables across rows