topic Calculating percentages across row in SAS Programming

Calculating percentages across row

aaou — Wed, 22 Jun 2016 23:06:00 GMT

I have a dataset which takes the following form:

ID	North	East	West	South
4634	45	767	34	65
1264	23	54	643	43
2654	5	34	342	434

I want to calcualte the percentage across each row for each ID, so that I get something that looks like this:

ID	North	East	West	South	Total
4634	5%	84%	4%	7%	100%
1264	3%	7%	84%	6%	100%
2654	1%	4%	42%	53%	100%

Please help! Thank you!

Re: Calculating percentages across row

Jagadishkatam — Thu, 23 Jun 2016 01:17:32 GMT

Please try

data have;
input ID	North	East	West	South;
tot=sum(of North,East,	West,	South);
cards;
4634	45	767	34	65
1264	23	54	643	43
2654	5	34	342	434
;

data want;
set have;
array pct(5) North	East	West	South tot;
array pcts(5) North_	East_	West_	South_ tot_;
do i = 1 to 5;
pcts(i)=input((pct(i)/tot),PERCENT8.);
end;
run;

Re: Calculating percentages across row

aaou — Thu, 23 Jun 2016 01:31:18 GMT

It gives the following error:

ERROR 22-322: Syntax error, expecting one of the following: ), -.

ERROR 200-322: The symbol is not recognized and will be ignored.

Re: Calculating percentages across row

Reeza — Thu, 23 Jun 2016 01:48:08 GMT

Remove total out of the array and use sum(of pct(*)) instead as the total.

Re: Calculating percentages across row

Reeza — Thu, 23 Jun 2016 01:49:10 GMT

Your error shouldn't be caused by that though. In general when you get an error post your code and the error. We can't see your computer screen.

Re: Calculating percentages across row

aaou — Thu, 23 Jun 2016 02:00:03 GMT

Hey thanks, for some reason it works now. Would you mind re-commenting with the amended code, with the suggestion you have made in the above comment....just so that I know what exactly you meant?

I'm sorry, I'm new to programing, so struggling a bit.

Thanks again!

Re: Calculating percentages across row

Reeza — Thu, 23 Jun 2016 02:42:23 GMT

No, @Jagadishkatam original solution was correct. I missed seeing the tot calculation when he read the file.

Your error was likely caused by a typo. If you didn't change anything and it ran I would double check my log and results.