Hi All,
I am an amateur and have no idear about macro if it's required in this case.
It requires me to proceed same analysis on the other 599 variables in the same way as var1 (var1-var600):
proc glm data = training;
class flag;
model var1.=bad_flag;
run;
I tried to settle the task in this way:
proc glm data = training;
class flag;
do i=1 to 600;
model var&i.=flag;
run;
Warnings said
apparent symbolic reference I not resolved.
variable var not fund.
How can I solve it? Pls enlighten me and thank you indeed!
@aegeangu wrote:
Hi All,
I am an amateur and have no idear about macro if it's required in this case.
It requires me to proceed same analysis on the other 599 variables in the same way as var1 (var1-var600):
proc glm data = training;
class flag;
model var1.=bad_flag;
run;
I tried to settle the task in this way:
proc glm data = training;
class flag;
do i=1 to 600;
model var&i.=flag;
run;
Warnings said
apparent symbolic reference I not resolved.
variable var not fund.
How can I solve it? Pls enlighten me and thank you indeed!
You don't need a macro.
Try this:
proc glm data = training;
class bad_flag;
model var1-var600=bad_flag;
run;
A couple of other points:
@aegeangu wrote:
Hi All,
I am an amateur and have no idear about macro if it's required in this case.
It requires me to proceed same analysis on the other 599 variables in the same way as var1 (var1-var600):
proc glm data = training;
class flag;
model var1.=bad_flag;
run;
I tried to settle the task in this way:
proc glm data = training;
class flag;
do i=1 to 600;
model var&i.=flag;
run;
Warnings said
apparent symbolic reference I not resolved.
variable var not fund.
How can I solve it? Pls enlighten me and thank you indeed!
You don't need a macro.
Try this:
proc glm data = training;
class bad_flag;
model var1-var600=bad_flag;
run;
A couple of other points:
Thank you very much!
MANOVA is strange to me not sure whether it requires the vars obey normal distribution... I will work on it. Thank you again!
Transpose your DATA and use BY processing.
https://blogs.sas.com/content/iml/2017/02/13/run-1000-regressions.html
@aegeangu wrote:
Hi All,
I am an amateur and have no idear about macro if it's required in this case.
It requires me to proceed same analysis on the other 599 variables in the same way as var1 (var1-var600):
proc glm data = training;
class flag;
model var1.=bad_flag;
run;
I tried to settle the task in this way:
proc glm data = training;
class flag;
do i=1 to 600;
model var&i.=flag;
run;
Warnings said
apparent symbolic reference I not resolved.
variable var not fund.
How can I solve it? Pls enlighten me and thank you indeed!
@Reeza wrote:
Transpose your DATA and use BY processing.
https://blogs.sas.com/content/iml/2017/02/13/run-1000-regressions.html
That's for hundreds/thousands of X variables. It's completely unnecessary for hundreds/thousands of Y variables.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.