topic Re: Calculating the Total Amount with random number of variables in SAS Programming

Calculating the Total Amount with random number of variables

skjhzzang — Tue, 26 Nov 2019 11:29:00 GMT

For example below

Peter 2 14 16

James 3 17 19 18

Max 1 7

Logan 5 19 15 11 9 18

…

First variable is Name, Second variable is number of visit and others are amounts.

Peter visited twice so there are 2 amount variables and James visited three times so there are 3 amount variables.

Is it possible to just ignore reading Amount variables and just calculate sum of amount variables for each person and running total of the total amount variables for each person in a single data step?

Result should be like this.

Name TotalAmt Runtotal

Peter 30 30

James 54 84

Max 7 91

Logan 72 163

...

Re: Calculating the Total Amount with random number of variables

PaigeMiller — Tue, 26 Nov 2019 11:38:25 GMT

assuming you have variables named AMOUNT1-AMOUNT5

Use

totalamt=sum(of amount1-amount5);
runtotal+totalamt;

Re: Calculating the Total Amount with random number of variables

skjhzzang — Tue, 26 Nov 2019 12:04:58 GMT

@PaigeMiller

What if you don't know how many variables are in the data?

I mean in the datalines, there are random number of amount variables. (You don't know the maximum number of Amount Variable)

Datalines above is just an example in a whole datalines

Re: Calculating the Total Amount with random number of variables

PaigeMiller — Tue, 26 Nov 2019 12:57:33 GMT

Surely you must have a SAS data set. PROC CONTENTS will tell you what variables exist, you can use that information.

Please show us an actual SAS data set, following these instructions: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712