Proc Compare with transposite

[rknallamothu]

Hi have sas job like below i need the create the report like transpose ouput.i didn't know the syntex can you please look into this please.

below is the sas job.

libname prod '/sasdata/prod';
libname test '/sasdata/test';

%include '/sasdata/formats/s_smsloan';
run;

data prod.DEPARTMENT;
infile 'prod/DEPARTMENT.csv' dsd delimiter='Î' lrecl=2000 missover;
%stgDepartment;
title 'DEPARTMENT';
proc sort data=prod.DEPARTMENT;by orig_num;
run;
data test.DEPARTMENT;
infile 'test/DEPARTMENT.csv' dsd delimiter='Î' lrecl=2000 missover;
%stgDepartment;
proc sort data=test.DEPARTMENT;by orig_num;
run;
proc compare MAXPRINT=(10,1000) base=prod.DEPARTMENT compare=test.DEPARTMENT;id orig_num;
run;

 

[rknallamothu]

sorry misspelled TRANSPOSE REPORT.