BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Prateek1
Obsidian | Level 7

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
RahulG
Barite | Level 11

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;

View solution in original post

2 REPLIES 2
RahulG
Barite | Level 11

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;

Reeza
Super User

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. 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1423 views
  • 1 like
  • 3 in conversation