topic Re: Macros in SAS Programming

Macros

Prateek1 — Fri, 08 Jul 2016 06:09:24 GMT

hi,

i am not able to solve this question

what should be the code for this question ?

Write a macro to create the following dataset

var_1 var_2 .....var_9 var_10

1 4 .... 81 100

1 8 .... 729 1000

please help ?

Re: Macros

RahulG — Fri, 08 Jul 2016 06:30:39 GMT

You can control the number of rows with Outer loop and number of columns with inner loop variable.

%MACRO T;
data k;
%do j= 2 %to 3;
%do i= 1 %to 10;
var&i=&i**&j;
%end;
output;
%end;
run;
%MEND;
%T;

Re: Macros

Reeza — Fri, 08 Jul 2016 07:19:09 GMT

Maybe I'm missing it but what's the logic? I'm also assuming this is homework because practically it has no purpose. I feel there has to be more to the question though, otherwise macros don't add any value at all.