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 ... View more

hi   Im trying to generate a rtf file using proc report, but in output rtf file I'm getting empty space in right half of every page. Table is in only half of the page in landscape mode How can I make the table to cover entire page ? Please refer the attached pic for the empty space I'm referring to    My code high level is below    options orientation=landscape nodate PS=70 ls=120 nocenter nonumber nobyline topmargin=1.5in bottommargin=1in leftmargin=1in rightmargin=1in; title; footnote; ods _all_ close; ods rtf file="C:\result_op\op.rtf" startpage=yes style=tablertf BODYTITLE_AUX nogtitle; ods escapechar='^'; proc report data = DS nowd spacing=2 headline headskip split = "|" nocenter missing; columns /* column names */ **some define columns here ; TITLE1 "Test Proc report "; FOOTNOTE3 "* Number of Subjects is only counted for unique subjects"; run; ods rtf close; ods listing;     ... View more