BookmarkSubscribeRSS Feed
Rvasireddi
Calcite | Level 5

Hi,

  I have table shell with column1=parameter (containing continuous and categorical values) ,

                                     Column2=OVERALL (Freq Counts and continuous results using proc means and proc freq) 2-subjects

                                     Column3=MALE (2 subjects).

  As per team request, it is required to present colum4=FEMALE (0 records for continuous and categorical ). I don't have female in source dataset. so how to get it in final output. Is there a possible way to do it. without manipulating with original data.

                                  

2 REPLIES 2
Reeza
Super User

Yes, you can use the PRELOADFMT in several PROC and CLASSDATA in others.

 

This is also commonly asked, so you can find several answers on here:

https://communities.sas.com/t5/SAS-Procedures/PROC-FREQ-Include-Zero-Counts/td-p/325505

 


@Rvasireddi wrote:

Hi,

  I have table shell with column1=parameter (containing continuous and categorical values) ,

                                     Column2=OVERALL (Freq Counts and continuous results using proc means and proc freq) 2-subjects

                                     Column3=MALE (2 subjects).

  As per team request, it is required to present colum4=FEMALE (0 records for continuous and categorical ). I don't have female in source dataset. so how to get it in final output. Is there a possible way to do it. without manipulating with original data.

                                  


 

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Health and Life Sciences Learning

 

Need courses to help you with SAS Life Sciences Analytics Framework, SAS Health Cohort Builder, or other topics? Check out the Health and Life Sciences learning path for all of the offerings.

LEARN MORE

Discussion stats
  • 2 replies
  • 1314 views
  • 1 like
  • 2 in conversation