topic Re: Proc Append in Macro in SAS Programming

Proc Append in Macro

esita — Tue, 03 Feb 2015 21:18:30 GMT

Hi All,

I'm trying to assign a value to 40 variables in a data set using if then statement in MACRO. But When I execute it, it assigns value to only last variable in the macro list. Here is my code.

%macro up (var, var2);

data abc_new;

set abc;

if &var is <0 then &var2= -1;

else if &var is >0 then &var2 = 1;

run;

%mend up;

%up (expense_1, crd_1);

%up (expense_2, crd_2);

%up (expense_40, crd_40);

when I execute this code my data set only contains crd_40. I don't see crd_1 thru crd_39.

Re: Proc Append in Macro

data_null__ — Tue, 03 Feb 2015 21:23:37 GMT

From what I can see you are overwriting ABC_NEW each time. You would need the MODIFY statement to APPEND as written.

However perhaps you can do it ALL in one simple data set. Show example input data and example of what you want.

Re: Proc Append in Macro

Reeza — Tue, 03 Feb 2015 21:30:50 GMT

Your IF statements are incorrect assuming that is your actual code, you have an IS word that doesn't belong there.

if &var <0 then &var2= -1;

else if &var>0 then &var2 = 1;

This also seems perfect for arrays rather than macros.

Re: Proc Append in Macro

esita — Tue, 03 Feb 2015 21:32:58 GMT

This is my Input data

Id	expense_1	expense_2	expense_3	expense_4
1	-500	250	58	-87
2	400	360	78	69
3	-360	-54	-85	54
4	-80	-69	23	-77
5	500	95	-30	32

And this is what I want

Id	expense_1	expense_2	expense_3	expense_4	crd_1	crd_2	crd_3	crd_4
1	-500	250	58	-87	-1	1	1	-1
2	400	360	78	69	1	1	1	1
3	-360	-54	-85	54	-1	-1	-1	1
4	-80	-69	23	-77	-1	-1	1	-1
5	500	95	-30	32	1	1	-1	1

Re: Proc Append in Macro

data_null__ — Tue, 03 Feb 2015 21:42:36 GMT

SIGN function and ARRAY.

data exp;
   length id $4; 
   array Expense_[4];
   array crd_[4];
   input Id Expense_;
   do i = 1 to dim(Expense_);
      crd_ = sign(Expense_);
      end; 
   drop i;
   cards; 
1  -500  250   58 -87
2  400   360   78 69
3  -360  -54   -85   54
4  -80   -69   23 -77
5  500   95 -30   32
;;;;
   run; 
proc print; 
   run;

Re: Proc Append in Macro

esita — Tue, 03 Feb 2015 21:58:25 GMT

Thank You for the piece of code. This is helpful, but the variables Expense1, expense_2.... are actually named different. Like car_expense, book_expense, exp_office, exp_gas and so on. I named it as Expense_1...expense_40 just for example code.

Re: Proc Append in Macro

esita — Tue, 03 Feb 2015 22:03:51 GMT

Reeza, that is a typo. I don;t have "is" in my code.

Re: Proc Append in Macro

data_null__ — Tue, 03 Feb 2015 22:43:31 GMT

array Expense_[4]  car_expense book_expense exp_office exp_gas;

Re: Proc Append in Macro

esita — Tue, 03 Feb 2015 23:05:49 GMT

Thank You!