Replace empty spaces

WilliamB — Thu, 05 Sep 2019 08:45:04 GMT

Hello, in a table I have empty spaces, I would like to fill them with the information of the table.

Table

Name	Function	Cat
William	55	A4
Sabastien	44	A5
Didier	78
Faben	74	A9
Mathias	25



I want this:

Name	Function	Cat
William	55	A4
Sabastien	44	A5
Didier	78	Didier-78
Faben	74	A9
Mathias	25	Mathias-25

Thanks a lot for your help

Re: Replace empty spaces

PeterClemmensen — Thu, 05 Sep 2019 08:51:07 GMT

data have;
input Name $10. Function Cat $2.;
infile datalines;
datalines;
William   55 A4
Sabastien 44 A5
Didier    78   
Faben     74 A9
Mathias	  25   
;

data want;
    length Name $10 Function 8 Cat $50;
    set have;
    if missing(Cat) then Cat=catx('-', Name, Function);
run;

topic Re: Replace empty spaces in SAS Programming

Replace empty spaces

Re: Replace empty spaces