SQL Tips01 PROC SELECT INTO:

shiyiming · 发表于 2003-11-10 13:26:46

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:35

Mark

shiyiming · 发表于 2012-7-22 14:20:46

马克

shiyiming · 发表于 2012-7-31 17:00:18

<img src="{SMILIES_PATH}/icon_lol.gif" alt=":lol:" title="Laughing" />

		自动登录	找回密码
密码			立即注册

SQL Tips01 PROC SELECT INTO:

SQL Tips01 PROC SELECT INTO:

Re: SQL Tips01 PROC SELECT INTO:

Re: SQL Tips01 PROC SELECT INTO:

Re: SQL Tips01 PROC SELECT INTO: