topic Re: Unscheduled Visit number in SAS Programming https://communities.sas.com/t5/SAS-Programming/Unscheduled-Visit-number/m-p/615620#M180077 <P>Please post the data in usable form and add a description of the rules that you want applied.</P> Tue, 07 Jan 2020 11:04:01 GMT andreas_lds 2020-01-07T11:04:01Z Unscheduled Visit number https://communities.sas.com/t5/SAS-Programming/Unscheduled-Visit-number/m-p/615615#M180075 <P>i have data in this type&nbsp;</P> <P><BR />data have;<BR />length id visitno visitdt visit $200;<BR />infile datalines dsd truncover;<BR />input id visitno visitdt visit $;<BR />datalines;<BR />1006,01,2019-11-06,v1<BR />1006,02,2019-11-08,v2<BR />1006,03,2019-11-22,v3<BR />1006,04,2019-12-19,v4<BR />1006,9.01,2019-11-21,Unscheduled-21-NOV-2019<BR />1006,9.01,2019-11-21,Unscheduled-21-NOV-2019<BR />1006,9.01,2019-11-21,Unscheduled-21-NOV-2019<BR />1006,9.01,2019-11-21,Unscheduled-21-NOV-2019<BR />1007,01,2019-10-06,v1<BR />1007,02,2019-10-08,v2<BR />1007,03,2019-11-22,v3<BR />1007,04,2019-12-19,v4<BR />1007 ,9.01 ,2019-11-23,Unscheduled-23-NOV-2019<BR />1007,9.01,2019-11-23,Unscheduled-23-NOV-2019<BR />1007,9.01,2019-11-23,Unscheduled-23-NOV-2019<BR />1007,9.01,2019-12-21,Unscheduled-21-DEC-2019<BR />1008,01,2019-09-06,v1<BR />1008,02,2019-10-08,v2<BR />1008,03,2019-11-22,v3<BR />1008,04,2019-12-19,v4<BR />1008,9.01,2019-09-07,Unscheduled-07-SEP-2019<BR />1008,9.01,2019-09-07,Unscheduled-07-SEP-2019<BR />1008,9.01,2019-12-20,Unscheduled-20-DEC-2019<BR />1008,9.01,2019-12-20,Unscheduled-20-DEC-2019<BR />;<BR />run;</P> <P>&nbsp;</P> <P>i want this&nbsp;</P> <P><BR />data want;<BR />length id visitno visit $200 visitdt 8;<BR />infile datalines dsd truncover;<BR />input id visitdt visit $ visitno;<BR />datalines;<BR />1006,1,2019-11-06,v1<BR />1006,2,2019-11-08,v2<BR />1006,2.1,2019-11-21,Unscheduled 2.1<BR />1006,2.1,2019-11-21,Unscheduled 2.1<BR />1006,2.1,2019-11-21,Unscheduled 2.1<BR />1006,2.1,2019-11-21,Unscheduled 2.1<BR />1006,3,2019-11-22,v3<BR />1006,4, 2019-12-19,v4<BR />1007,1,2019-10-06,v1<BR />1007,2,2019-10-08,v2<BR />1007,3,2019-11-22,v3<BR />1007,3.1,2019-11-23,Unscheduled 3.1<BR />1007,3.1,2019-11-23,Unscheduled 3.1<BR />1007,3.1,2019-11-23,Unscheduled 3.1<BR />1007,4,2019-12-19,v4<BR />1007,4.1,2019-12-21,Unscheduled 4.1<BR />1008,1,2019-09-06,v1<BR />1008,1.1,2019-09-07,Unscheduled 1.1<BR />1008,1.1,2019-09-07,Unscheduled 1.1<BR />1008,2,2019-10-08,v2<BR />1008,3,2019-11-22,v3<BR />1008,4, 2019-12-19,v4<BR />1008,4.1,2019-12-20,Unscheduled 4.1<BR />1008,4.1,2019-12-20,Unscheduled 4.1<BR />;<BR />run;</P> Tue, 07 Jan 2020 12:07:16 GMT https://communities.sas.com/t5/SAS-Programming/Unscheduled-Visit-number/m-p/615615#M180075 teja5959 2020-01-07T12:07:16Z Re: Unscheduled Visit number https://communities.sas.com/t5/SAS-Programming/Unscheduled-Visit-number/m-p/615620#M180077 <P>Please post the data in usable form and add a description of the rules that you want applied.</P> Tue, 07 Jan 2020 11:04:01 GMT https://communities.sas.com/t5/SAS-Programming/Unscheduled-Visit-number/m-p/615620#M180077 andreas_lds 2020-01-07T11:04:01Z