DATA Step, Macro, Functions and more

How to create total sum/count variable from categorical and numerical variables

Reply
Contributor
Posts: 31

How to create total sum/count variable from categorical and numerical variables

[ Edited ]

Hello. I have 7 categorical variables that are dummy variables coded as Y or N and 2 numerical dummy variables that are coded as 1 or 0. I want to create a variable that counts the total number of 'Y' or 1'' for each of these variables. Any suggestions?

 

Data screenshot is in attachment below

 

 

Super User
Posts: 22,850

Re: How to create total sum/count variable from categorical and numerical variables

Posted in reply to stancemcgraw

1. Use CATX() to combine all into one character variable.

2. Use COUNTC() to count the characters of interest. You'll probably need to call this twice, once for Y and once for N. 

 

In general, its better to store Y/N as 1/0 because then you can use SUM() or other basic math functions. 

PROC Star
Posts: 1,328

Re: How to create total sum/count variable from categorical and numerical variables

[ Edited ]
Posted in reply to stancemcgraw

I would have liked to code had you given the sample data HAVE and WANTas plain text. Screenshot,pdf or any attachments doesn't help at all.

Super User
Posts: 22,850

Re: How to create total sum/count variable from categorical and numerical variables

Posted in reply to novinosrin

@novinosrin I choose to tailor my answers based on the question. No data, then you get an approach solution because I'm not going to make assumptions and have someone come back and say it doesn't work or provide sample data in a different format than I guessed. It's mostly inefficient for me.

Also, if the data is an image, the code is an image these days. It's maybe a bit petty but I think users also learn more when they have to type it out rather than copy and paste and I do follow that myself, I force myself to type it out line by line. 

 

@stancemcgraw Nothing in this post is related to you directly, more so on general behaviour on the community forums. 

PROC Star
Posts: 1,328

Re: How to create total sum/count variable from categorical and numerical variables

@Reeza Smiley Happy true. I got that. Also, I must admit, i code here selfishly for my practice and continued learning. Honestly, not generous yet. Please don't think I am a bad person. lol. I treat this as my school indirectly benefiting OPs. Once I accomplish like you have in career and knowledge, I'd then become selfless.  Ok, i am going out for a beer. Have a great evening!

Ask a Question
Discussion stats
  • 4 replies
  • 277 views
  • 2 likes
  • 3 in conversation