topic Assigning Group by value to individual records in SAS Programming

Assigning Group by value to individual records

sasuser77 — Thu, 30 Aug 2018 14:52:25 GMT

Hi,

I've a dataset similar to below. I want to assign the Group by value to individual records as shown below.

Name	Sex
Alice	F
Barbara
Carol
Jane
Janet
Joyce
Judy
Louise
Mary
Alfred	M
Henry
James
Jeffrey
John
Philip
Robert
Ronald
Thomas
William

desired output

Name	Sex
Alice	F
Barbara	F
Carol	F
Jane	F
Janet	F
Joyce	F
Judy	F
Louise	F
Mary	F
Alfred	M
Henry	M
James	M
Jeffrey	M
John	M
Philip	M
Robert	M
Ronald	M
Thomas	M
William	M

Re: Assigning Group by value to individual records

novinosrin — Thu, 30 Aug 2018 14:56:25 GMT

data have;
infile cards truncover;
input (Name	Sex) ($);
cards;
Alice	F
Barbara	 
Carol	 
Jane	 
Janet	 
Joyce	 
Judy	 
Louise	 
Mary	 
Alfred	M
Henry	 
James	 
Jeffrey	 
John	 
Philip	 
Robert	 
Ronald	 
Thomas	 
William	
;
 
data want;
set have;
retain _s;
if missing(sex) then sex=_s;
else _s=sex;
drop _s;
run;

Re: Assigning Group by value to individual records

sasuser77 — Thu, 30 Aug 2018 19:37:25 GMT

Thank you!