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
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;
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;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.