Often when data is imported from excel with merged-cells this type of missing data pattern will created. You can use the features of the UPDATE statement to fill of LOCF the missing values. You just need to identify the variables to be operated on and create dummy BY variable a "necessary evil". I added that variable with a data step view. data mergedcell; infile cards dsd; input row group $ subgroup $ value; cards; 1,AI,AZ,2201 2,,,2262 3,,,2271 4,,,2272 5,AO,AO,341 6,,,414 7,,BB,731 8,,,2262 9,,, ;;;; run; proc print; run; data v / view=v; set mergedcell; retain dummy 1; run; %let by = dummy; %let fill = group subgroup; data filled; if 0 then set mergedcell; update v(obs=0 keep=&by) v(keep=&by &fill); by &by; set mergedcell(drop=&fill); output; drop dummy; run; proc print; run;
... View more