data wf; set sashelp.cars; if EngineSize <=2 then excl=1; else if Cylinders <=4 then excl=2; else if Horsepower <=100 then excl=3; else if MPG_City <=20 then excl=4; else if MPG_Highway <22 then excl=5; else if Weight <2000 then excl=6; else if Wheelbase <100 then excl=7; else if Length <110 then excl=8; else excl=99; run; proc format; value exl 1=' 1 EngineSize <=2 ' 2=' 2 Cylinders <=4 ' 3=' 3 Horsepower <=100 ' 4=' 4 MPG_City <=20 ' 5=' 5 MPG_Highway <22 ' 6=' 6 Weight <2000 ' 7=' 7 Wheelbase <100 ' 8=' 8 Length <110 ' 99='99 Pass'; run; proc tabulate data=wf noseps missing; format excl exl.; class excl/preloadfmt; tables excl all, all=''/printmiss misstext='0'; run; proc sort data=wf ;by excl;run; proc tabulate data=wf; format excl exl.; by excl; class excl/preloadfmt; var EngineSize Cylinders Horsepower MPG_City MPG_Highway Weight Wheelbase Length; tables excl, EngineSize Cylinders Horsepower MPG_City MPG_Highway Weight Wheelbase Length , (n*f=6. min*f=6. max*f=6.) ; run; First result remaining ones are by excl multiple tables but needed by excl by logic variable in one step Example I need only engine size should be in the table not remaining variables MIN AND MAX when I run 2nd tabulate
... View more