topic Re: Retain statement in SAS Procedures

Retain statement

deleted_user — Mon, 25 May 2009 22:47:19 GMT

I'm just starting using SAS...I received a file in his format:

Client...SKU....Volume
3020....1000.....10
...........1001......3
............1002..... 7
5505.... 2001.....15
..... ......1005 .....6
............1004.....30

I need to complete the blank with the previus value, for exemle, for line2 the client is 3020 too. How could i do it? A friend toldmeto use Retain statement but did not work.

I tried this code:

Data test;
Set test;

Retain Client;
If _n_=1 then Client=NEW_CLIENT;
Else do;
If NEW_CLIENT=’’ then NEW CLIENT=CLIENT;
Else Client=NEW_CLIENT;
End;
Run;

Thanks

Re: Retain statement

sbb — Tue, 26 May 2009 00:33:11 GMT

The _N_ condition is only in effect with the first observation. You will need to use a sorted input file and use a BY statement with the key variables, and retain the important variable(s) using the IF FIRST. THEN ; condition.

Check the SAS support http://support.sas.com/ website for DATA STEP PROGRAMMING discussion and using a BY statement and the FIRST. and LAST. conditions for additional details.

Scott Barry
SBBWorks, Inc.

Re: Retain statement

Peter_C — Tue, 26 May 2009 12:03:20 GMT

data latest( keep= client sku volume ) ;
* assuming the name of the raw data is CLIENTS ;
set clients( obs= 0 ) ; * getting column definitions ;
do while( not finished ) ;
set clients( rename= ( client= rawC )) end= finished ;
client = coalesce( rawC, client ) ;
output ;
end ;
stop ;
run ;

if column CLIENT is character, use function COALESCEC() rather than COALESCE()

Message was edited by: Peter.C getting column definitions was intended as comment, prefix with *

Message was edited by: Peter.C

Re: Retain statement

deleted_user — Tue, 26 May 2009 15:13:44 GMT

getting column definitions - Sas did not recognized. I couldn't make it work

I'm not a programmer...I'm a mkt consutant and i have a huge amont of data to manipulate. Message was edited by: elilika

Re: Retain statement

sbb — Tue, 26 May 2009 17:12:56 GMT

If willing to solve the problem (regardless of your focus/perspective), you will need to explain what code you attempted and exactly what error occurred or further explain "getting column definitions - Sas did not recognized. I couldn't make it work".

Scott Barry
SBBWorks, Inc.

Re: Retain statement

deleted_user — Tue, 26 May 2009 19:05:07 GMT

Try the following Code. Hope this will help.

data test;
input client sku volume ;
cards;
3020 1000 10
. 1001 3
. 1002 7
5505 2001 15
. 1005 6
. 1004 30
;
run;

data test1(drop=client rename=(temp=client));
set test;
by client notsorted;
retain temp;
if first.client and client ne . then temp=client;
client=temp;
run;

~Sukanya E

Re: Retain statement

Peter_C — Tue, 26 May 2009 19:48:19 GMT

sorry my proposal had a mistake.
As a comment, the text "getting column definitions" should have been prefixed with an asterisk.
I have updated the code in the earlier message

hope it works for you now.
good luck

PeterC

Re: Retain statement

deleted_user — Wed, 27 May 2009 14:31:45 GMT

Thanks Sukanya, it worked!
:-) Message was edited by: elilika