BookmarkSubscribeRSS Feed
teja5959
Obsidian | Level 7

i have data in this type 


data have;
length id visitno visitdt visit $200;
infile datalines dsd truncover;
input id visitno visitdt visit $;
datalines;
1006,01,2019-11-06,v1
1006,02,2019-11-08,v2
1006,03,2019-11-22,v3
1006,04,2019-12-19,v4
1006,9.01,2019-11-21,Unscheduled-21-NOV-2019
1006,9.01,2019-11-21,Unscheduled-21-NOV-2019
1006,9.01,2019-11-21,Unscheduled-21-NOV-2019
1006,9.01,2019-11-21,Unscheduled-21-NOV-2019
1007,01,2019-10-06,v1
1007,02,2019-10-08,v2
1007,03,2019-11-22,v3
1007,04,2019-12-19,v4
1007 ,9.01 ,2019-11-23,Unscheduled-23-NOV-2019
1007,9.01,2019-11-23,Unscheduled-23-NOV-2019
1007,9.01,2019-11-23,Unscheduled-23-NOV-2019
1007,9.01,2019-12-21,Unscheduled-21-DEC-2019
1008,01,2019-09-06,v1
1008,02,2019-10-08,v2
1008,03,2019-11-22,v3
1008,04,2019-12-19,v4
1008,9.01,2019-09-07,Unscheduled-07-SEP-2019
1008,9.01,2019-09-07,Unscheduled-07-SEP-2019
1008,9.01,2019-12-20,Unscheduled-20-DEC-2019
1008,9.01,2019-12-20,Unscheduled-20-DEC-2019
;
run;

 

i want this 


data want;
length id visitno visit $200 visitdt 8;
infile datalines dsd truncover;
input id visitdt visit $ visitno;
datalines;
1006,1,2019-11-06,v1
1006,2,2019-11-08,v2
1006,2.1,2019-11-21,Unscheduled 2.1
1006,2.1,2019-11-21,Unscheduled 2.1
1006,2.1,2019-11-21,Unscheduled 2.1
1006,2.1,2019-11-21,Unscheduled 2.1
1006,3,2019-11-22,v3
1006,4, 2019-12-19,v4
1007,1,2019-10-06,v1
1007,2,2019-10-08,v2
1007,3,2019-11-22,v3
1007,3.1,2019-11-23,Unscheduled 3.1
1007,3.1,2019-11-23,Unscheduled 3.1
1007,3.1,2019-11-23,Unscheduled 3.1
1007,4,2019-12-19,v4
1007,4.1,2019-12-21,Unscheduled 4.1
1008,1,2019-09-06,v1
1008,1.1,2019-09-07,Unscheduled 1.1
1008,1.1,2019-09-07,Unscheduled 1.1
1008,2,2019-10-08,v2
1008,3,2019-11-22,v3
1008,4, 2019-12-19,v4
1008,4.1,2019-12-20,Unscheduled 4.1
1008,4.1,2019-12-20,Unscheduled 4.1
;
run;

1 REPLY 1
andreas_lds
Jade | Level 19

Please post the data in usable form and add a description of the rules that you want applied.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 636 views
  • 1 like
  • 2 in conversation