topic Re: Addition of macro variables. in SAS Programming

Addition of macro variables.

starkt964 — Sat, 30 Apr 2022 11:32:29 GMT

How to add the macro variables and assign it to a new observation?

For example:

%demo(1); -------- > 21
%demo(2); ---------> 33

%demo(3); --------> 20

Obtaining a new observation containing the addition of %demo(1), %demo(2), %demo(3). i.e 74.

Re: Addition of macro variables.

Tom — Sat, 30 Apr 2022 15:34:48 GMT

Your example does not appear to contain any macro variables at all.

Do the macros you are calling really only emit those digit strings as the results?

If you wanted to add those three numbers you should use addition.

data _null_;
  want = 21 + 33 + 20;
  put want=;
run;

The macro processor is a text replacement tool. So you could replace the text 21 with the first macro call, 33 with the second etc.

data _null_;
  want = %demo(1) + %demo(2)+ %demo(3);
  put want=;
run;

Please explain more what you are doing to get a better answer. Also please explain where or how actual macro variables are involved.

Re: Addition of macro variables.

PaigeMiller — Sat, 30 Apr 2022 21:02:31 GMT

@starkt964 wrote:

How to add the macro variables and assign it to a new observation?

For example:

%demo(1); -------- > 21
%demo(2); ---------> 33

%demo(3); --------> 20

Obtaining a new observation containing the addition of %demo(1), %demo(2), %demo(3). i.e 74.

You don't have macro variables, you have a macro named %DEMO. Macros and macro variables are not the same thing. Please show us the code for %DEMO. And please provide a more complete explanation of what you are doing, do not skip this step.

Addition

starkt964 — Sun, 01 May 2022 06:32:29 GMT

Hi!

The output should be a Total Points = 31.

Please refer the code below.

libname chrttgrp "/vbp/warehouse/vbp0lxr/";

data temp;
	set chrttgrp.grps;
run;

%macro demmo(idNumber);
proc sql;
	select points into:  p
	from temp
	where id = &idNumber;
quit;
%mend;

%demmo(1);
%demmo(2);
%demmo(3);

Re: Addition of macro variables.

starkt964 — Sat, 30 Apr 2022 23:39:39 GMT

Please refer to https://communities.sas.com/t5/SAS-Programming/Addition/m-p/810854

Re: Addition

KaueMAlmeida — Sun, 01 May 2022 01:43:13 GMT

The statement SELECT into PROC SQL is used for selecting some observations in your database. You need to summarize the results to achieve 31.

Re: Addition

Kurt_Bremser — Sun, 01 May 2022 04:59:19 GMT

As this post is a continuation, I moved it back in here.

Please post logs and other fixed-width text by copy/pasting into a window openedwith this button:

For SAS code, use the "little running man" right next to it.

Do not post code, logs or data as pictures.

Since we now have a glimpse of the macro, we can see it contains a SQL step, so you cannot use it in a data step, as the created code breaks the data step logic.

Re: Addition of macro variables.

starkt964 — Sun, 01 May 2022 06:57:11 GMT

Here is the code without the SQL query.

libname chrttgrp "/vbp/warehouse/vbp0lxr/";


%macro demmo(idNumber);
data temp;
	set chrttgrp.grps;
	keep points;
	where id = &idNumber;
run;
proc print data=temp;
run;

%mend;


%demmo(1);
%demmo(2);
%demmo(3);

Re: Addition of macro variables.

Kurt_Bremser — Sun, 01 May 2022 07:43:51 GMT

So what is your intention to achieve? Do you want (a) report(s), or (a) dataset?

Please show us a clear example of your source data like this:

data have;
input id points;
datalines;
1 4
2 20
3 7
;

and also show what you want to get out of it as a final result, and if that result depends on additional factors (selection criteria etc), show those also (including from where they come).

Re: Addition

PaigeMiller — Sun, 01 May 2022 10:38:17 GMT

@starkt964 wrote:

Hi!

The output should be a Total Points = 31.

Please refer the code below.

libname chrttgrp "/vbp/warehouse/vbp0lxr/";

data temp;
	set chrttgrp.grps;
run;

%macro demmo(idNumber);
proc sql;
	select points into:  p
	from temp
	where id = &idNumber;
quit;
%mend;

%demmo(1);
%demmo(2);
%demmo(3);

Hello, @starkt964 — when data is in a SAS data set, you can add it without macros. I hope this is clear, because this is an important fundamental understanding that you need to have to use SAS effectively. Macros are simply not necessary, and are an over-complication. You will work much harder use macros to perform arithmetic on data in SAS data sets than if you use the proper SAS tools. In this case, the proper tool to add numbers in SAS data set is PROC SUMMARY.

proc summary data=chrttgrp.grps(where=(id in (1,2,3)));
    var points; 
    output out=_sum_ sum=sum_points;
run;

Re: Addition of macro variables.

starkt964 — Sun, 01 May 2022 11:09:52 GMT

Yes. My bad not expressing it correctly. Let's re-iterate over the problem statement.

So, the intention is to achieve a dataset.

The data is:-

The output of the data:-

So basically, a new dataset containing the addition of different observations.

eg:- revenue = 4 + 20 + 7.

@PaigeMiller @Kurt_Bremser

Re: Addition of macro variables.

PaigeMiller — Sun, 01 May 2022 11:18:03 GMT

My PROC SUMMARY code does this. No macros needed.

Your output table seems to have nothing to do with the data you show, there is no variable with the value "revenue" and no variable with the value "debt" in your data set. It really helps us if your output data is correct for the input you show.

Re: Addition of macro variables.

Kurt_Bremser — Sun, 01 May 2022 11:33:48 GMT

How do your current values of variable name correspond to the values "revenue" and "debt" in your "want" dataset?

From first look, a format and PROC SUMMARY is all you need.

Re: Addition of macro variables.

starkt964 — Sun, 01 May 2022 12:37:58 GMT

There is no reference to the "revenue" and "debt" in the "want" dataset. The revenue and debt needs to be generated by ourselves with the summation of (not all) the points and to be saved inside the new dataset.

eg:- revenue = 4 + 20 + 7
debt = 20 + 7
tax = 20
.....

Re: Addition of macro variables.

PaigeMiller — Sun, 01 May 2022 12:59:42 GMT

@starkt964

The concept that you need to understand is that SAS works with SAS data sets, and then code produces the desired answer.

So ... we need the SAS data set you are working with, not word descriptions like you just provided. We need (a portion of) the data provided as SAS data step code, or via these instructions so we can actually write code to work on the data set. Do not provide the data via other methods, do not provide the data as screen captures, do not provide the data as Excel files.

Re: Addition of macro variables.

starkt964 — Sun, 01 May 2022 14:05:35 GMT

@PaigeMiller

Please find the dataset below.

data WORK.chrrt;
  infile datalines dsd truncover;
  input Id:BEST. Name:$28. Points:$2.;
  format Id BEST.;
  label Id="Id" Name="Name" Points="Points";
datalines4;
1,Accounts Receivable,4
2,Cash Equivalents,20
3,Current Asset,7
4,Long Term Receivables,24
5,Other Long Term Investments,25
6,Other Asset,9
7,Cash,1
8,Bank,2
9,Credit Card Receivable,3
10,Marketable Securities,21
11,Allowance for Bad Debts,22
12,Other Receivables,5
13,Other Current Asset,23
14,Inventory,6
15,Capital Asset,8
16,Accum. Amort. & Depreciation,26
17,Asset,0
18,Other Non-Current Asset,27
19,Accounts Payable,4
20,Liability,0
21,Cash,1
22,Bank,2
23,Current Liability,7
24,Credit Card Payable,3
25,Other Current Liability,25
26,Other Non-Current Liability,28
27,Debt,6
28,Deferred Income Taxes,29
29,Other Liability,9
30,Other Payable,5
31,Short Term Debt,24
32,Income Tax Payable,23
33,Payroll Tax Payable,21
34,Employee Deductions Payable,22
35,Sales Tax Payable,20
36,Deferred Revenue,27
37,Long Term Debt,26
38,Long Term Liability,8
39,Equity,0
40,Cash,1
41,Bank,2
42,Credit Card Payable,3
43,Owner/Partner Contributions,4
44,Owner/Partner Witdrawals,5
45,Dividends,20
46,Share Capital,6
47,Retained Earnings,7
48,Current Earnings,8
49,Revenue,0
50,Farming Revenue,22
51,Other Revenue,1
52,Gain,23
53,Extraordinary Gain,24
54,Operating Revenue,20
55,Non-Operating Revenue,21
56,Non-Operating Expense,26
57,Extraordinary Loss,28
58,Cost of Goods Sold,1
59,Operating Expense,20
60,Payroll Expense,2
61,Employee Benefits,23
62,Expense,0
63,General & Admin. Expense,3
64,Bad Debt Expense,22
65,Interest Expense,24
66,Amort./Depreciation Expense,21
67,Income Tax Expense,25
68,Loss,27
69,Rent,0
70,Capital and Interest,0
;;;;

Re: Addition of macro variables.

PaigeMiller — Sun, 01 May 2022 15:20:32 GMT

Thank you.

Why do you confuse us with "revenue" and "debt", when these are not a part of your data set?

The output you want, the addition of ID 1 2 and 3, is obtained via the PROC SUMMARY code I presented earlier. Again, no macros needed.

Re: Addition of macro variables.

starkt964 — Sun, 01 May 2022 15:29:30 GMT

No, the addition of 1, 2 and 3 needs to be saved in the variable "revenue" likewise with "debt" and needs to be stored in another file.

Re: Addition of macro variables.

Kurt_Bremser — Sun, 01 May 2022 17:56:26 GMT

And which IDs need to be summed for "debt"?

Re: Addition of macro variables.

Tom — Sun, 01 May 2022 18:05:11 GMT

So your POINTS variable needs to be numeric, not character, if you want to SUM it

Your current NAME variable has a few values that repeat. Should the points for those names be collapsed? Or should the names be made distinct in some way?

You need another variable that describes the category (for example DEBT or REVENUE ) for each of the NAME values.