topic Re: How to create total sum/count variable from categorical and numerical variables in SAS Programming

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

stancemcgraw — Mon, 15 Jan 2018 23:00:07 GMT

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

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

Reeza — Mon, 15 Jan 2018 23:02:59 GMT

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.

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

novinosrin — Mon, 15 Jan 2018 23:13:12 GMT

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.

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

Reeza — Mon, 15 Jan 2018 23:35:33 GMT

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

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

novinosrin — Tue, 16 Jan 2018 00:05:52 GMT

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