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.
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!
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.