Obsidian | Level 7

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

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

4 REPLIES 4
Super User

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

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.

Tourmaline | Level 20

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

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

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

@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.

Tourmaline | Level 20

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

@Reeza 🙂 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!

Discussion stats
• 4 replies
• 2705 views
• 2 likes
• 3 in conversation