New issue was caused by adding the input statement below. Used exactly as the first one and it worked. Thanks! ... View more

Thanks for the reply. No values as in the second case so I went with the first solution. Now have a new issue for numbers with no decimals though ... View more

Thanks for the reply, this fixed the comma issue but now there's a new one. Variables without any decimals are assigned a period (40 -> 4.0). I didn't include those without decimals before, below is an updated code    Data Work.Have; Input PatientId $ AgeMo Temp $; Temp_n = input(translate(Temp,",","."), comma8.1); Drop Temp; Rename Temp_n = Temp; Datalines; 0001 11 37.9 0002 9 38.7 0003 44 38,1 0004 30 37.7 0005 19 37,5 0006 20 40 0007 10 39 ; Run; Which gives this output Obs PatientId AgeMo Temp1234567 0001 11 37.9 0002 9 38.7 0003 44 38.1 0004 30 37.7 0005 19 37.5 0006 20 4.0 0007 10 3.9 ... View more