LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 2008, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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
Comments: To: sas-l@uga.edu
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 ャャャャャャャャャャャャャャャャ ャャャャャャャャャャャャャャャャャャャャ 4TART END LABEL (VER. 9.1 07AUG2008:19:43:17)

ャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャ A A YEAR B B MONTH2 D D DAY M M MONTH N N 0 0 2 2 2TR 3 3 2TR3.2 4 4 4EMIYEAR 8 8 8EEK **OTHER** **OTHER**

ャャャャャャャャ泣ャャャャャャャルャャャャャャャャャャャャャャャャャャャャ The SAS System

сャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャャユ FORMAT NAME: $MAP_PERIODS_MAT LENGTH: 11 MIN LENGTH: 1 MAX LENGTH: 40 DEFAULT LENGTH 11 FUZZ: 0 ャャャャャャャャャャャャャャャャ ャャャャャャャャャャャャャャャャャャャャ 4TART 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 . 0 0 . 2 2 0.25 3 3 0.333333333 4 4 0.5 8 8 0.019230769 **OTHER** **OTHER** .

ャャャャャャャャ泣ャャャャャャャルャャャャャャャャャャャャャャャャャャャャ

What seems to be the problem?


Back to: Top of message | Previous page | Main SAS-L page