topic Re: Retaining values in SAS Programming

Retaining values

Adnan_Razaq — Thu, 31 May 2018 11:58:56 GMT

Hi All,

I have the following dataset

data have;
	input reporting_date account_id $ repayment_type $; 
	informat reporting_date  date9.;
	format reporting_date date9.;
	
	cards ;
	31JAN2018 123 REP
	31JAN2018 456 INT
	31JAN2018 789 PAP
	28FEB2018 123 REP
	28FEB2018 456 .   
	28FEB2018 789 PAP 
	31MAR2018 123 .   
	31MAR2018 456 .   
	31MAR2018 789 .   
	;
run;

What I need to get to is

Reporting_Date	Account_ID	Repayment_Type
31-Jan-18	123	REP
31-Jan-18	456	INT
31-Jan-18	789	PAP
28-Feb-18	123	REP
28-Feb-18	456	INT
28-Feb-18	789	PAP
31-Mar-18	123	REP
31-Mar-18	456	INT
31-Mar-18	789	PAP

I need to retain the repayment type only if the repayment type is missing the following month.

Regards

Adnan

Re: Retaining values

RW9 — Thu, 31 May 2018 12:34:57 GMT

Thats very simple, did you read the examples in the SAS docs?

http://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=p0t2ac0tfzcgbjn112mu96hkgg9o.htm&docsetVersion=9.4&locale=en

Maybe something like:

data want;
  set have;
  retain lst;
  if lst ne "" then lst=repayment_type;
  else repayment_type=lst;
run;

Re: Retaining values

Ksharp — Thu, 31 May 2018 13:06:44 GMT

data have;
	input reporting_date account_id $ repayment_type $; 
	informat reporting_date  date9.;
	format reporting_date date9.;
	
	cards ;
	31JAN2018 123 REP
	31JAN2018 456 INT
	31JAN2018 789 PAP
	28FEB2018 123 REP
	28FEB2018 456 .   
	28FEB2018 789 PAP 
	31MAR2018 123 .   
	31MAR2018 456 .   
	31MAR2018 789 .   
	;
run;

data want;
 set  have ;
 by reporting_date;
 if first.reporting_date then n=0;
 n+1;
 if n=1 then repayment_type='REP';
 if n=2 then repayment_type='INT';
 if n=3 then repayment_type='PAP';
drop n;
run;