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;
Please post the data in usable form and add a description of the rules that you want applied.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.