Hi All, I have two data steps, one in Proc SQL the other in bases SAS. Both of the codes are sourcing the exact same variables from the same source and are being sorted by the same variable. proc sql;
create table vals_base as
select
ACCTAPPLNUMBER as application_id,
VALUATIONDATE,
DIM_CO_VALUATION_SSK,
VALUATIONTYPE,
LASTMODIFIEDDATE_DATE,
NUMBEROFBATHROOMS,
NUMBEROFBEDROOMS,
PROPERTYBUILT,
VALUEINCURRENTCONDITION,
PROPERTYTYPE,
PROPERTYSUBTYPE
from TEST_APP.DPR_DIM_APPLICATION_VALUATIONS
order by ACCTAPPLNUMBER;
quit; proc sort data=test_app.DPR_DIM_APPLICATION_VALUATIONS (keep = DIM_CO_VALUATION_SSK
VALUATIONDATE VALUATIONTYPE VALUEINCURRENTCONDITION LASTMODIFIEDDATE_DATE
NUMBEROFBATHROOMS NUMBEROFBEDROOMS PROPERTYBUILT ACCTAPPLNUMBER
PROPERTYTYPE PROPERTYSUBTYPE ) out=vals_base (rename = (ACCTAPPLNUMBER = application_id));
by ACCTAPPLNUMBER;
run; Why would the outputs differ in sort beyond the sort key. For example the valuationtype variable is outputted different in both outputs although it is not listed as a variable to be sorted. Base SAS output application_id VALUATIONDATE VALUATIONTYPE 1538 28FEB2014:00:00:00 Quest - Homebuyers 1538 17FEB2014:00:00:00 Quest - Homebuyers 1538 28FEB2014:00:00:00 Quest - Full Valuation Proc SQL output application_id VALUATIONDATE VALUATIONTYPE 1538 28FEB2014:00:00:00 Quest - Full Valuation 1538 17FEB2014:00:00:00 Quest - Homebuyers 1538 28FEB2014:00:00:00 Quest - Homebuyers The source table does contain multiple application Id's. Thanks Adnan
... View more