Date: Fri, 8 Aug 2008 01:40:36 -0700
Reply-To: Nanita <susana.urbano@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Nanita <susana.urbano@GMAIL.COM>
Organization: http://groups.google.com
Subject: put statement
Content-Type: text/plain; charset=windows-1252
Hi all,
i'm looking at this code:
data rd_pos.payment_cycles(drop=pp reason
rename=(paymentperiod1=paymentperiod)) errors_cycles;
length reason $200;
set payment_cycles;
set rd_stage.Account_paymtypechange(rename=(paymentperiod=pp
dtbegin=dtcyclebegin dtend=dtcycleend PAYMENTAMOUNTS=PAYMENTAMOUNT)
drop=company) key=instid ;
if (_iorc_ ne 0) then do;
put 'not found';
_error_=0;
reason='Contract does not apeear on Payment Cycle table';
output errors_cycles;
end;
else do while (_iorc_ = 0);
set rd_stage.Account_paymtypechange(rename=(paymentperiod=pp
dtbegin=dtcyclebegin dtend=dtcycleend PAYMENTAMOUNTS=PAYMENTAMOUNT)
drop=company) key=instid;
paymentmaturity = put(pp, $MAP_PERIODS_MAT11.)+0;
paymentperiod1 = put(pp, $MAP_PERIODS_UNIT8.);
interestperiod = put(pp, $MAP_PERIODS_UNIT8.);
amortizationperiod = put(pp, $MAP_PERIODS_UNIT8.);
interestmaturity = put(pp, $MAP_PERIODS_MAT8.)+0;
amortizationmaturity = put(pp, $MAP_PERIODS_MAT11.)+0;
if _iorc_= 0 then
output rd_pos.payment_cycles;
end;
_error_=0;
run;
and returns the following error:
21389 paymentmaturity = put(pp, $MAP_PERIODS_MAT10.)+0;
-------------------
48
WARNING: Variable pp has already been defined as numeric.
ERROR 48-59: The format MAP_PERIODS_MAT was not found or could not be
loaded.
21390 paymentperiod1 = put(pp, $MAP_PERIODS_UNIT10.);
--------------------
48
WARNING: Variable pp has already been defined as numeric.
21391 interestperiod = put(pp, $MAP_PERIODS_UNIT10.);
--------------------
48
WARNING: Variable pp has already been defined as numeric.
21392 amortizationperiod = put(pp, $MAP_PERIODS_UNIT10.);
--------------------
48
WARNING: Variable pp has already been defined as numeric.
ERROR 48-59: The format MAP_PERIODS_UNIT was not found or could not be
loaded.
but I used
proc format library=rd_env.formats fmtlib;
select $Map_periods_unit;
run;
proc format library=rd_env.formats fmtlib;
select $Map_periods_mat;
run;
and returns
The SAS System
„ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ†
‚ FORMAT NAME: $MAP_PERIODS_UNIT LENGTH:
8 ‚
‚ MIN LENGTH: 1 MAX LENGTH: 40 DEFAULT LENGTH 8
FUZZ: 0 ‚
‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ…
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‰
‚START ‚END ‚LABEL (VER. 9.1
07AUG2008:19:43:17)‚
‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
‰
‚A ‚A
‚YEAR ‚
‚B ‚B
‚MONTH2 ‚
‚D ‚D
‚DAY ‚
‚M ‚M
‚MONTH ‚
‚N ‚N
‚ ‚
‚O ‚O
‚ ‚
‚Q ‚Q
‚QTR ‚
‚R ‚R
‚QTR3.2 ‚
‚S ‚S
‚SEMIYEAR ‚
‚W ‚W
‚WEEK ‚
‚**OTHER** ‚**OTHER**
‚ ‚
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒŒ
The SAS System
„ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ†
‚ FORMAT NAME: $MAP_PERIODS_MAT LENGTH:
11 ‚
‚ MIN LENGTH: 1 MAX LENGTH: 40 DEFAULT LENGTH 11
FUZZ: 0 ‚
‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ…
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‰
‚START ‚END ‚LABEL (VER. 9.1
07AUG2008:19:14:17)‚
‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
‰
‚A ‚A
‚1 ‚
‚B ‚B
‚0.166666667 ‚
‚D ‚D
‚0.002739726 ‚
‚M ‚M
‚0.083333333 ‚
‚N ‚N
‚. ‚
‚O ‚O
‚. ‚
‚Q ‚Q
‚0.25 ‚
‚R ‚R
‚0.333333333 ‚
‚S ‚S
‚0.5 ‚
‚W ‚W
‚0.019230769 ‚
‚**OTHER** ‚**OTHER**
‚. ‚
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒŒ
What seems to be the problem?
