topic proc freq for only zero values in SAS Programming

proc freq for only zero values

pavank — Wed, 31 Jul 2024 06:13:42 GMT

proc freq data=sashelp.cars;
tables make*origin/norow nocol nopercent nocum sparse;
run;

Hi Experts,

I want to get only zero values from sashelp.cars using proc freq make and origin wise from above code not give zero values

Re: proc freq for only zero values

Ksharp — Wed, 31 Jul 2024 06:39:02 GMT

Post the desired output you are looking for.

Check 'WANT' table whether it is the output you want or not ?

proc freq data=sashelp.cars noprint;
tables make*origin/norow nocol nopercent nocum sparse out=want(where=(COUNT=0)) ;
run;

Re: proc freq for only zero values

pavank — Wed, 31 Jul 2024 06:48:15 GMT

Make	Origin	Frequency
Acura	Europe	0
Acura	USA	0
Audi	Asia	0
Audi	USA	0
BMW	Asia	0
BMW	USA	0
Buick	Asia	0
Buick	Europe	0
Cadillac	Asia	0
Cadillac	Europe	0
Chevrolet	Asia	0
Chevrolet	Europe	0
Chrysler	Asia	0
Chrysler	Europe	0
Dodge	Asia	0
Dodge	Europe	0
Ford	Asia	0
Ford	Europe	0
GMC	Asia	0
GMC	Europe	0
Honda	Europe	0
Honda	USA	0
Hummer	Asia	0
Hummer	Europe	0
Hyundai	Europe	0
Hyundai	USA	0
Infiniti	Europe	0
Infiniti	USA	0
Isuzu	Europe	0
Isuzu	USA	0
Jaguar	Asia	0
Jaguar	USA	0
Jeep	Asia	0
Jeep	Europe	0
Kia	Europe	0
Kia	USA	0
Land Rover	Asia	0
Land Rover	USA	0
Lexus	Europe	0
Lexus	USA	0
Lincoln	Asia	0
Lincoln	Europe	0
MINI	Asia	0
MINI	USA	0
Mazda	Europe	0
Mazda	USA	0
Mercedes-Benz	Asia	0
Mercedes-Benz	USA	0
Mercury	Asia	0
Mercury	Europe	0
Mitsubishi	Europe	0
Mitsubishi	USA	0
Nissan	Europe	0
Nissan	USA	0
Oldsmobile	Asia	0
Oldsmobile	Europe	0
Pontiac	Asia	0
Pontiac	Europe	0
Porsche	Asia	0
Porsche	USA	0
Saab	Asia	0
Saab	USA	0
Saturn	Asia	0
Saturn	Europe	0
Scion	Europe	0
Scion	USA	0
Subaru	Europe	0
Subaru	USA	0
Suzuki	Europe	0
Suzuki	USA	0
Toyota	Europe	0
Toyota	USA	0
Volkswagen	Asia	0
Volkswagen	USA	0
Volvo	Asia	0
Volvo	USA	0

Re: proc freq for only zero values

Ksharp — Wed, 31 Jul 2024 07:36:33 GMT

Check the "WANT" table generated by my code.