https://communities.sas.com/t5/SAS-Procedures/Reg-Dots/m-p/33642#M8146 data emi_mth;<BR /> input emi$;<BR /> emi1=scan(emi,1);<BR /> emi2=scan(emi,2);<BR /> cards;<BR /> 423.23659<BR /> 4523<BR /> 425.233<BR /> 45.1<BR /> 4.2369<BR /> 1.36985<BR /> run;<BR /> <BR /> <BR /> got it Tue, 19 May 2009 08:56:27 GMT deleted_user 2009-05-19T08:56:27Z https://communities.sas.com/t5/SAS-Procedures/Reg-Dots/m-p/33641#M8145 Hi<BR /> <BR /> i am having data with dots i want the data before the dots only,if there are no dots then the data should come exactly and the variable is in character.<BR /> <BR /> data emi_mth;<BR /> input emi$;<BR /> cards;<BR /> 423.23659<BR /> 4523<BR /> 4,255.233<BR /> 46,569.236<BR /> 45.1<BR /> 4.2369<BR /> 1.36985<BR /> run;<BR /> <BR /> the output should be like this and varible shd be in numeric<BR /> emi <BR /> 423<BR /> 4523<BR /> 4255<BR /> 45<BR /> 4<BR /> 1 Tue, 19 May 2009 08:48:56 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Dots/m-p/33641#M8145 deleted_user 2009-05-19T08:48:56Z https://communities.sas.com/t5/SAS-Procedures/Reg-Dots/m-p/33642#M8146 data emi_mth;<BR /> input emi$;<BR /> emi1=scan(emi,1);<BR /> emi2=scan(emi,2);<BR /> cards;<BR /> 423.23659<BR /> 4523<BR /> 425.233<BR /> 45.1<BR /> 4.2369<BR /> 1.36985<BR /> run;<BR /> <BR /> <BR /> got it Tue, 19 May 2009 08:56:27 GMT https://communities.sas.com/t5/SAS-Procedures/Reg-Dots/m-p/33642#M8146 deleted_user 2009-05-19T08:56:27Z