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.

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