SAS 代码：导入 Excel、删除空值并左移、导出到新文件

/* 导入Excel文件 */ proc import out=work.importdata datafile='C:\users\data.xlsx' dbms=xlsx replace; sheet='Sheet1'; run;

/* 删除右侧空值左移 / data work.cleaneddata; set work.importdata; array vars[] numeric;

do i = 1 to dim(vars);
    if missing(vars[i]) then do j=i+1 to dim(vars);
        vars[j-1] = vars[j];
        vars[j] = .;
    end;
end;

run;

/* 导出到新的Excel */ proc export data=work.cleaneddata outfile='C:\users\cleaneddata.xlsx' dbms=xlsx replace; sheet='Sheet1'; run;