data want; set have_1 - have_100; run; I have 100 datasets, have_1 - have_100 (each have 3 observations and 10 variables), and the order of the datasets is important. However, some of those 100 datasets are empty which only contain 10 variable names but have no observation. For example, have_1, have_10, have_23, and have_62 are empty datasets (I don't know which one/s is empty datasets). The dataset want generated by above code only include 288 observations, and since those 4 empty datasets are not included, the order of the observations in dataset want is now all wrong. Any options to also merge those 4 empty datasets into dataset want and assign those 4 empty datasets with either 0 or missing value, so that the resulted dataset want will have 300 observation in the original order (of them 12 observations with 0 or missing value)? Thanks! Above is something what I want. If dataset 1 and dataset 4 are not included, then dataset 2 will be the first, dastset 3 then will be 2nd, and datset 5 will be 3rd, etc., that is not what I want.
... View more
