Dear SAS-L,

I have a problem that has been troubling me for some time. There has been a few exchanges with the tech support people, but the final solution is not in yet. So I would like to seek advice from the list.

An example of the problem is as follows.

Data set 1 has 4 variables, group, year, b_x and b_y. A 1979 1234 3456 A 1980 2345 3454 B 1979 892929 344939 B 1980 9229292 29292929

Data set 2 has three variables, group, VAR and NDEC. A b_x 2 A b_y 4 B b_x 3 B b_y 6

The problem is to use information in NDEC (number of decimal points) in data set 2 to insert decimal points into the values of variables b_x and b_y in data set 1. Note that data set 1 has over 25,000 obs and data set 2 has over 45,000 obs. So the solution probably need to take that into account.

Thanks for any help.

Best, Quan