proc sql; create table Raisin as select distinct 'Total' as Item, '' as Type, count(GFTAmt) as Count, sum(GFTAmt) format 12.2 as Amt from A union all ... union all select distinct 'EventType', EventType, count(GFTAmt) , sum(GFTAmt) from A group by EventType ; quit; Table CRM is created in same way. When I run the following code, error comes. code 1. proc compare base=crm compare=Raisin out=result outnoequal outbase outcomp outdif ; var Count Amt; title 'Comparison of Variables in Different Data Sets'; id Item Type; run; ----------The output1 shows:---------------------v Comparison of Variables in Different Data Sets 14:20 Monday, April 26, 2012 2 The COMPARE Procedure Comparison of WORK.CRM with WORK.RAISIN (Method=EXACT) Values Comparison Summary Number of Variables Compared with All Observations Equal: 1. Number of Variables Compared with Some Observations Unequal: 1. Total Number of Values which Compare Unequal: 1. Maximum Difference: 2.2737E-13. Variables with Unequal Values Variable Type Len Ndif MaxDif Amt NUM 8 1 227E-15 Value Comparison Results for Variables __________________________________________________________________________________ || Base Compare Item Type || Amt Amt Diff. % Diff ____________ __________________ || _________ _________ _________ _________ || EventType General || 1354.11 1354.11 2.274E-13 1.679E-14 __________________________________________________________________________________ code2: proc sql; select a.Item, a.type, a.count-b.count as count, a.Amt ,b.Amt, a.Amt-b.Amt as AmtDiff from raisin a, crm b where a.Item=b.Item and a.type=b.type; quit; --------------Amt format 12.2 and here is a part of the output2----------------------------v Item Type count Amt Amt AmtDiff ... EventType General 0 1354.11 1354.11 2.27E-13 ... --------------------------------------------------------------------------------------------------------------^ My question is that how 2.27E-13 comes?:smileyconfused: how to avoid this format happens? Please help. Thank you.
... View more