Excel导入到SAS快速查找空值并删除左移导出到一个新的Excel的SAS代码

/导入Excel数据/ PROC IMPORT OUT=WORK.data DATAFILE="path_to_excel_file.xlsx" DBMS=XLSX REPLACE; SHEET="Sheet1"; GETNAMES=YES; RUN;

/查找空值并删除左移/ DATA WORK.data; SET WORK.data; ARRAY num_vars NUMERIC; ARRAY char_vars CHARACTER; DO OVER num_vars; IF MISSING(num_vars) THEN num_vars=LAG(num_vars); END; DO OVER char_vars; IF MISSING(char_vars) THEN char_vars=LAG(char_vars); END; RUN;

/导出到新Excel文件/ PROC EXPORT DATA=WORK.data OUTFILE="path_to_new_excel_file.xlsx" DBMS=XLSX REPLACE; SHEET="Sheet1"; RUN;