hi, I have a library let's say 'library1'. In this library i have datasets with the same variables (names, type, etc.) Every dataset is created at the end of the month, so i have for example dataset_201701 dataset_201702 dataset_201703 and so on. Now, datasets have the same variables, but they could have have different lenghts of observations which can cause unexpected results while combining them. Example: dataset_201701 has an observation in variable 'abc' which has lenght of 50 . dataset_201702 has an observation in variable 'abc' which has lenght of 40. if someone combines these datasets data combine; set dataset_201701 dataset_201702; run; It will truncate the variable abc to 40. So the question is: How can I check the longest observation in every variable, in every dataset in my library 'library1' and set the lenght for the longest observation ? Basing on my example I want the variable abc to have lenght of 50 in every dataset.
... View more