This is the code I'm using. I keep getting a lot of errors. proc sql; select min(logat) as 'MinLogofTotalAssets', min(roa) as 'MinReturnofAssets', min(bus_seg) as 'MinBusinessSegment', min(geo_seg) as 'MinGeographicSegment', min(ln_nas) as 'MinLNofNAS', min(city_ind_fees) as 'MinCityIndependentFees', min(big4) as 'MinBigFour', min(audit_tenure) as 'MinAuditTenure', max(logat) as 'Max Log of Total Assets', max(roa) as 'Max of Return of Assets', max(bus_seg) as 'Max of Business Segment', max(geo_seg) as 'Max Geographic Segment', max(ln_nas) as 'Max LN of NAS', max(city_ind_fees) as 'Max City Independent Fees', max(big4) as 'Max Big Four', max(audit_tenure) as 'Max Audit Tenure', mean(logat) as 'Mean Log of Total Assets', mean(roa) as 'Mean Return of Assets', mean(bus_seg) as 'Mean Business Segment', mean(geo_seg) as 'Mean Geographic Segment', mean(ln_nas) as 'Mean of LN NAS', mean(city_ind_fees) as 'Mean of City Independent Fees', mean(big4) as 'Mean of Big Four', mean(audit_tenure) as 'Mean of Audit Tenure', median(logat) as 'Median Log of Total Assets', median(roa) as 'MedianReturnofAssets', median(bus_seg) as 'Median Business Segment', median(geo_seg) as 'Median Geographic Segment', median(ln_nas) as 'Median of LN NAS', median(city_ind_fees) as 'Median of City Independent Fees', median(big4) as 'Median of Big Four', median(audit_tenure) as 'Median of Audit Tenure', std(logat) as 'STD Log of Total Assets', std(roa) as 'STD Return of Assets', std(bus_seg) as 'STD Business Segment', std(geo_seg) as 'STD Geographic Segment', std(ln_nas) as 'STD of LN NAS', std(city_ind_fees) as 'STD of City Independent Fees', std(big4) as 'STD of Big Four', std(audit_tenure) as 'STD of Audit Tenure', var(logat) as 'Var Log of Total Assets', var(roa) as 'Var Return of Assets', var(bus_seg) as 'Var Business Segment', var(geo_seg) as 'Var Geographic Segment', var(ln_nas) as 'Var of LN NAS', var(city_ind_fees) as 'Var of City Independent Fees', var(big4) as 'Var of Big Four', var(audit_tenure) as 'Var of Audit Tenure' from audit group by 'Group 1'; quit; Thanks for you help in advance!
... View more