- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I have a format with all values. How do I get counts and % for these values from a dataset ? If the values are not present in dataset, i need count and percent as 0
Example:
proc format library = work; value $car_type "Hybrid" = "Hybrid Drivetrain" "SUV" = "Sports Utility Vehicle" "Sedan" = "4-door Sedan" "Truck" = "Pickup Truck" "Wagon" = "Station Wagon" "Testc" = "Test value" ; run;
But when I run proc feq, I need frequency and percent for type as Testc. Even though it is 0
proc freq data = sashelp.cars; tables type / missing; format type $car_type.; run;
I came across 1 article where it says its not possible, but it dated 2015. So wondering if there is any new feature added to SAS. I'm using SAS release: 9.04.
Solved: How To - Create Count of Variable with Missing Val... - SAS Support Communities
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I don't think PROC FREQ can do this without some manipulation of the data set. However, PROC SUMMARY/PROC MEANS can do this, example:
proc summary data=sashelp.cars completetypes;
class type/preloadfmt;
format type $car_type.;
var invoice;
output out=_stats_ n=n;
run;
Paige Miller
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I don't think PROC FREQ can do this without some manipulation of the data set. However, PROC SUMMARY/PROC MEANS can do this, example:
proc summary data=sashelp.cars completetypes;
class type/preloadfmt;
format type $car_type.;
var invoice;
output out=_stats_ n=n;
run;
Paige Miller
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
In that case, I'm not getting the pre loaded formats
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Creating a dataset with a empty obs when its empty as per below one
I want empty dataset to be worked in Proc means. - SAS Support Communities
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Different procs different possibilities:
proc tabulate data=sashelp.cars; class type/ preloadfmt; format type $car_type.; tables type, n colpctn /printmiss misstext='0' ; run;
proc report data=sashelp.cars completerows; columns type ( n pctn); define type / group format=$car_type. preloadfmt ; define pctn /format=percent8.2; run;