Hi,

I have a dataset which contains 2 fields (and some others) modelid and mmodelid. Till this point (and I checked this before embarking on this step) both modelid and mmodelid take values between 1 and 10 (albeit different values within the same range). At this step, I need both the variabels to take the same value (specifically the value that mmodelid has taken upto this point). So I perform the following step:

data trial; set fresh4(drop=modelid); modelid=mmodelid; proc sort data=trial; by modelid nweek; run;

However while this works for all values of mmodelid except the last value 10. Whenever it encounters a 10 it seems to change it to a 1. Any ideas why? This is completely driving me nuts.

Thanks in advance, Seema