BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
CHL0320
Obsidian | Level 7

Hi, How do I carry the non-missing up or down within the same ID? The final output is one ID per line. 

 

Before: 

IDABCDEF
12011.1.40
12011.136.
12011451..
27518762..
27518.2..
2751876283.
3233.3..
3233.35773
3233613.

.

 

After:

IDABCDEF
120114513640
2751876283.
32336135773

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20
data have;
input ID	A	B	C	D	E	F;
cards;
1	20	11	.	1	.	40
1	20	11	.	1	36	.
1	20	11	45	1	.	.
2	75	18	76	2	.	.
2	75	18	.	2	.	.
2	75	18	76	2	83	.
3	23	3	.	3	.	.
3	23	3	.	3	57	73
3	23	3	61	3	.	.
;

data want;
update have(obs=0) have;
by id;

run;

 

View solution in original post

1 REPLY 1
novinosrin
Tourmaline | Level 20
data have;
input ID	A	B	C	D	E	F;
cards;
1	20	11	.	1	.	40
1	20	11	.	1	36	.
1	20	11	45	1	.	.
2	75	18	76	2	.	.
2	75	18	.	2	.	.
2	75	18	76	2	83	.
3	23	3	.	3	.	.
3	23	3	.	3	57	73
3	23	3	61	3	.	.
;

data want;
update have(obs=0) have;
by id;

run;

 

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1416 views
  • 0 likes
  • 2 in conversation