topic Excel merged header to a Proc Freq in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Excel-merged-header-to-a-Proc-Freq/m-p/216785#M53371 <HTML><HEAD></HEAD><BODY><P>I am currently wanting to analyze survey data. The data is set up in an excel spreadsheet with a merged header, similar to what is seen below.<IMG alt="Untitled.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/10488_Untitled.png" width="450" /></P><P>I want to be able to count how many respondents selected a particular topic, without merging the responses into one variable. For example, if I wanted to count how many respondents said they like Art, in a proc freq, I would get 100% (5/5). But what I really want to see is Art 83.33% (5/6), so it takes into consideration ALL respondents who completed the question. I want to be able to do a proc freq for the variable "Topics" and have it return Art: 5/6, Science: 2/6, History: 2/6, etc.</P><P></P><P>I know that there is probably an easy solution to my problem, but my brain just isn't thinking that way today!</P></BODY></HTML> Mon, 18 May 2015 17:23:16 GMT loloaloha13 2015-05-18T17:23:16Z Excel merged header to a Proc Freq https://communities.sas.com/t5/SAS-Procedures/Excel-merged-header-to-a-Proc-Freq/m-p/216785#M53371 <HTML><HEAD></HEAD><BODY><P>I am currently wanting to analyze survey data. The data is set up in an excel spreadsheet with a merged header, similar to what is seen below.<IMG alt="Untitled.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/10488_Untitled.png" width="450" /></P><P>I want to be able to count how many respondents selected a particular topic, without merging the responses into one variable. For example, if I wanted to count how many respondents said they like Art, in a proc freq, I would get 100% (5/5). But what I really want to see is Art 83.33% (5/6), so it takes into consideration ALL respondents who completed the question. I want to be able to do a proc freq for the variable "Topics" and have it return Art: 5/6, Science: 2/6, History: 2/6, etc.</P><P></P><P>I know that there is probably an easy solution to my problem, but my brain just isn't thinking that way today!</P></BODY></HTML> Mon, 18 May 2015 17:23:16 GMT https://communities.sas.com/t5/SAS-Procedures/Excel-merged-header-to-a-Proc-Freq/m-p/216785#M53371 loloaloha13 2015-05-18T17:23:16Z