代码之家 › 专栏 › 技术社区 › CPak

保留具有特定格式的列

sas

1

CPak · 技术社区 · 7 年前

sashelp.cars 有两列,其中 DOLLAR 格式- MSRP & INVOICE . 我只想保留这两列。感谢您的帮助!

1 回复 | 直到 7 年前

1

2

Kiran 7 年前

您可以使用dictionary.columns并执行此操作。

 proc sql ;
    select name into :keepcols SEPARATED by " " from dictionary.columns
    where libname = "SASHELP"
     and memname = "CARS"
     and format = "DOLLAR8.";

  proc sql ;
     select name into :keepcols SEPARATED by " " from dictionary.columns
     where libname = "SASHELP"
    and memname = "CARS"
     and format like "DOLLAR%";



      data cars;
        set sashelp.cars(keep = &keepcols);
     run;