[sas-users] Fw: frequency question

[terry.l.pennington at census.gov]

Hopefully someone can help Beth with an answer???
Please send a response to sas-users at lists.census.gov
Thanks!


|------------>
| From:      |
|------------>
  >----------------------------------------------------------------------------------------------------------------------------------------|
  |elizabeth.may.nichols at census.gov                                                                                                        |
  >----------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To:        |
|------------>
  >----------------------------------------------------------------------------------------------------------------------------------------|
  |sas-users at lists.census.gov                                                                                                              |
  >----------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date:      |
|------------>
  >----------------------------------------------------------------------------------------------------------------------------------------|
  |07/27/2011 02:40 PM                                                                                                                     |
  >----------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject:   |
|------------>
  >----------------------------------------------------------------------------------------------------------------------------------------|
  |[sas-users] Fw: frequency question                                                                                                      |
  >----------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Sent by:   |
|------------>
  >----------------------------------------------------------------------------------------------------------------------------------------|
  |sas-users-bounces at lists.census.gov                                                                                                      |
  >----------------------------------------------------------------------------------------------------------------------------------------|






Thank you very much for getting me the right user group to ask this
question.    See below.

Beth Nichols
Center for Survey Measurement
U.S. Census Bureau
301-763-1724
elizabeth.may.nichols at census.gov

----- Forwarded by Elizabeth May Nichols/CSM/HQ/BOC on 07/27/2011 02:38 PM
-----

  From:       Elizabeth May Nichols/CSM/HQ/BOC


  To:         Katherine Drom/CSM/HQ/BOC at BOC


  Date:       07/27/2011 01:48 PM


  Subject:    frequency question






I have data that is from a mark all question.

Let's say it is race.
They stored the first answer as race1.  It could be between 1-6.  If the
person marked a second answer they stored the second answer as race 2.

race1 freq
white =5
black =4
asian =2

race 2 freq
white=1
black =1

I want a combined frequency.

race total
white=6
black=5
asian=2

I think I need to output my frequencies from the individual varialbes and
then add them together but I don't know how to do that.

I have a feeling it is a proc summary statement, but again, not sure and
have been playing round with it and haven't had luck.

Beth Nichols
Center for Survey Measurement
U.S. Census Bureau
301-763-1724
elizabeth.may.nichols at census.gov


_______________________________________________
sas-users mailing list
sas-users at lists.census.gov
http://lists.census.gov/mailman/listinfo/sas-users