Date:         Wed, 21 Jul 2010 13:23:02 -0700
Reply-To:     "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Subject:      Re: Inputing Missing Value
In-Reply-To:  <5B1372272ABB7B4DB178622784D52BC107F19E4913@MOR-EXMBPRD01.bvnet.bv>
Content-Type: text/plain; charset="iso-8859-1"

"Don't work" is not very descriptive.  What happened that was different than what you wanted to happen?

Read the instructions again.  When should you assign a new value to DT?

And keep the correspondence in the list.

-----Original Message-----
From: Ricardo Gonçalves da Silva [mailto:rgs.rsilva@bancovotorantim.com.br]
Sent: Wednesday, July 21, 2010 12:48 PM
To: Schwarz, Barry A
Subject: RES: Inputing Missing Value

Hi,

I try

DATA TEST;
SET LIB.BASE_PT2;
DT=DATE;
RETAIN DT;
IF DATE = ' ' THEN DATE=DT;
RUN;

But dont work?!!!!

-----Mensagem original-----
De: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] Em nome de Schwarz, Barry A
Enviada em: quarta-feira, 21 de julho de 2010 16:25
Para: SAS-L@LISTSERV.UGA.EDU
Assunto: Re: Inputing Missing Value

If the variable is not missing in the current observation, save the value in a retained variable.

If the variable is missing in the current observation, set its value to the value of the retained variable.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ricardo Gonçalves da Silva
Sent: Wednesday, July 21, 2010 12:13 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Inputing Missing Value

HI,

I have a DATE variable where some cells are missing.
I would like to input in the missing cells the value of the cell exactly above.
Esta mensagem e seus anexos podem conter informações confidenciais ou privilegiadas. Se você não é o destinatário dos mesmos você não está autorizado a utilizar o material para qualquer fim. Solicitamos que você apague a mensagem e avise imediatamente ao remetente. O conteúdo desta mensagem e seus anexos não representam necessariamente a opinião e a intenção da empresa, não implicando em qualquer obrigaçâo ou responsabilidade da parte da mesma.
This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. The contents of this message and its attachments do not necessarily express the opinion or the intention of the company, and do not implies any legal obligation or responsibilities from this company.