SAS中文论坛

标题: SQL Tips01 PROC SELECT INTO: [打印本页]

作者: shiyiming 时间: 2003-11-10 13:26
标题: SQL Tips01 PROC SELECT INTO:
A good example for proc select into/ dictionary. for your reference.

proc sql;
  reset noprint;
  select '%let n_'||trim(memname)||'='||trim(put(nobs,best12.-L))||';'
  into :doit separated by ' '
  from dictionary.tables
  where libname = 'SASHELP'
  and memtype = 'DATA'
  ;

  &doit;
quit;

%put %superq(doit);

作者: shiyiming 时间: 2012-7-20 20:30
标题: Re: SQL Tips01 PROC SELECT INTO:
Mark

作者: shiyiming 时间: 2012-7-22 14:20
标题: Re: SQL Tips01 PROC SELECT INTO:
马克

作者: shiyiming 时间: 2012-7-31 17:00
标题: Re: SQL Tips01 PROC SELECT INTO:
<img src="{SMILIES_PATH}/icon_lol.gif" alt=":lol:" title="Laughing" />

欢迎光临 SAS中文论坛 (http://www.mysas.net/forum/)