Date:         Wed, 4 Oct 2006 00:10:34 -0700
Reply-To:     avi <aviben@BEZEQINT.NET.IL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         avi <aviben@BEZEQINT.NET.IL>
Organization: http://groups.google.com
Subject:      Re: Surprising retain feature
Comments: To: sas-l@uga.edu
In-Reply-To:  <941871A13165C2418EC144ACB212BDB0078C54@dshsmxoly1504g.dshs.wa.lcl>
Content-Type: text/plain; charset="iso-8859-1"

Hello,

The problem i had was w. large datasets. I tried to reconstitute  it
with a small exemple, but here the retain feature does not work. I'm
quite disturbed (in the exemple, the DPT value for resp_id=2 in the ALL
dataset is supposed to retain its value for previous observation, but
it did not...)


ods html file="eee .html"  path="C:\"  nogtitle style=styles.statdoc  ;

data one;
input resp_id q316 ;
cards;
1 1
2 0
3 5
;
proc print;
data two;
input resp_id  ;
cards;
4 1
;
data all;
attrib   dpt format=$5.;
set  two one;
if Q316=1 then dpt='1111 ';
if Q316=2 then dpt='2222';
if Q316=3 then dpt='3333';
proc print;
run;
ods html close;


Avi