Hi SAS Community, I am trying to merge two datasets by region. In general, some region values can end with decimal places and some don't. The problem is that the region variable values are slightly different between the datasets. In the first dataset, I get the original region values. In the second dataset, if the value does not end with decimal places then two zeroes ("00") are added. I believe the latter was done to make sure all values have the same lengths (to be honest, the reason why is beyond me). Moreover, in the second dataset, the decimal itself is removed from the value. I need region to be identically coded so I can merge the datasets. My goal is to either add two zeroes to the end of the region values in dataset_1, where values do not end with decimals. Or, remove the two trailing zeroes from the region values in dataset_2, where values end in two zeroes. I also want to either add or remove the decimal point. Region is a numeric variable and has a max character length of 10 (e.g. 5356789.02). Can anyone help me do this quickly? I have over 300+ region codes to deal with 😞 I tabulate my data have and data want below: DATA HAVE (region variable) dataset_1 dataset_2 100010 10001000 100020.01 10002001 100020.02 10002002 100033 10003300 256006 25600600 3451678.01 345167801 DATA WANT (region variable) dataset_1 or dataset_2 10001000 100010 10002001 100020.01 10002002 100020.02 10003300 100033 25600600 256006 345167801 3451678.01 (I basically want the region values to be identical) Thank you, and please let me know if more information is required.
... View more