topic Re: sum for character variables in SAS Programming

sum for character variables

BrahmanandaRao — Wed, 14 Dec 2022 10:18:39 GMT

data hsum;
input ID Trans Sales $;
datalines;
01 1 $135.00
01 1 $75.00
01 1 $140.00
01 2 $140.00
02 1 $220.00
03 1 $135.00
03 1 $125.00
03 2 $80.00
;
run;

proc sql;
select * ,sum(input(Sales,?best12.))as totals from hsum;
quit;

how to sum above char sales varibale

Re: sum for character variables

PeterClemmensen — Wed, 14 Dec 2022 10:21:33 GMT

Use an appropriate informat like dollar8.2

proc sql;
select * ,sum(input(Sales, dollar8.2))as totals from hsum;
quit;

Re: sum for character variables

BrahmanandaRao — Wed, 14 Dec 2022 10:31:27 GMT

vertical sum

Re: sum for character variables

PeterClemmensen — Wed, 14 Dec 2022 10:33:30 GMT

This is a 'vertical' som of all the values of Charsales? If you want a different result, then please be specific about your desired result.

Re: sum for character variables

PaigeMiller — Wed, 14 Dec 2022 11:14:05 GMT

With all due respect, do not make numeric variables into character variables. This causes problems, and we see this repeatedly, over and over again, in this forum, people have numbers as character variables, and they don't know how to handle this. If you are in control of the creation of this data set, do not make numbers character variables. If you are not in control (someone sent it to you), create numeric variables to replace the character variables, and then summing is easy.

Simple things like this, following good practices rather than bad practices, will help you hugely in your SAS career.