proc sql into clause

From sasCommunity

By Shiva 0923 on Fri Sep 19, 2008 1:41 am

how to get the last observation values by using retain statement in proc sql into clause? tell me syntax with example. thanq..

Private Message | Personal Page | Quote

By Mahesh on Fri Nov 07, 2008 2:13 am

hi shiva,

           correct me if i am wrong,i hope to get the last observation u can use eof stmt,
eg:

  data asd,
  infile  end=eof;
  input ;
  stmts..
  ...    
  if eof=1;
  run;

plz check it once.

Private Message | Personal Page | Quote

By Shiva 0923 on Fri Nov 14, 2008 12:56 am

hi..mahesh thanq..for ur reply i got it.. ur absolutly ryt.

           correct me if i am wrong,i hope to get the last observation u can use eof stmt,
eg:

  data asd,
  infile  end=eof;
  input ;
  stmts..
  ...    
  if eof=1;
  run;

Private Message | Personal Page | Quote