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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.