topic MACRO in New SAS User

Macro

nhev — Wed, 28 Jul 2021 04:20:03 GMT

Hello everyone,
I was blé to get the frequency on 2 variables age and score and plot an histograms for both using the following formulas
Proc freq
Data=Risk3;
Tables age;
Where status=‘full time’
Run;

Proc sgplot data= Risk3;
Histogram age/ scale=count;
Where status =‘full time’ and decision in ( pass, overide, overiden);

Run;

I wrote the same steps and formula with score ( by replacing age by score).

Now I am looking to create a macro using the same formulas as a base to plot the frequencies and SAS charts but on 3 others more variables time, arrears and income. Anyone knows how to proceed?

Thank you indeed

MACRO

nhev — Wed, 28 Jul 2021 04:44:59 GMT

Re: Macro

andreas_lds — Wed, 28 Jul 2021 05:13:36 GMT

The where-statement in proc sgplot seems to create errors, due to missing quotes.

Step 1: Wrap the code in %macro and %mend, spend some time on choosing a proper name for the macro. Execute it. If the result is still what it was before, go ahead to Step 2.

Step 2: Identify the things that need to be replaced, add parameters for them and use &your_param. in the appropriate places. Re-run the macro, providing the original value, check the log.

Macro

nhev — Wed, 28 Jul 2021 09:13:49 GMT

Re: Macro

Kurt_Bremser — Wed, 28 Jul 2021 09:17:58 GMT

PLEASE DO NOT MULTI-POST!!

It serves no purpose, and makes keeping track of suggested solutions hard for everybody.

Help with Macro

nhev — Wed, 28 Jul 2021 09:19:22 GMT

Re: Macro

andreas_lds — Wed, 28 Jul 2021 09:39:58 GMT

Please stop re-posting the same question over and over again!

Re: Macro

nhev — Wed, 28 Jul 2021 09:42:47 GMT

You don’t have to tell me what to do.
I couldn’t have a response to my question so I simply repost it. I don’t see where is the issue

Re: Macro

andreas_lds — Wed, 28 Jul 2021 09:55:49 GMT

@nhev wrote:
You don’t have to tell me what to do.
I couldn’t have a response to my question so I simply repost it. I don’t see where is the issue

I gave you an answer, if you don't understand it, ask. Also note, that re-posting the same question is just annoying and will hardly help getting a full solution to your problem.

Re: Macro

Kurt_Bremser — Wed, 28 Jul 2021 10:02:37 GMT

@nhev wrote:
You don’t have to tell me what to do.

(Super-User speaking) Oh yes, we have, if you don't behave responsibly.

@nhev wrote:
I couldn’t have a response to my question so I simply repost it. I don’t see where is the issue

Lie. You got an answer; instead of replying to it, you reposted the identical question again and again, forcing us to merge it back into the original thread.

Re: Macro

nhev — Wed, 28 Jul 2021 10:15:45 GMT

UNBELIEVABLE. You think you have the right to call me a liar because I asked a question? Do you think you own the chat?

Re: Macro

nhev — Wed, 28 Jul 2021 10:17:09 GMT

That’s correct I didn’t understand it so I simply repost. Someone else could help me to see things in a different view so for me I still haven’t got a reply

Re: Macro

Kurt_Bremser — Wed, 28 Jul 2021 10:34:50 GMT

You got an answer to a question; the reason that the answer is not understandable for you might be how you initially stated your question, so re-posting the identical question won't help.

Instead please reply to the answer and say what in particular you do not understand, so we can elaborate.

Mind that we have no clue about your current expertise, so an answer might assume a level of SAS knowledge that you do not yet have.

Re: Macro

Kurt_Bremser — Wed, 28 Jul 2021 10:49:02 GMT

@nhev wrote:
UNBELIEVABLE. You think you have the right to call me a liar because I asked a question? Do you think you own the chat?

I concede that you might simply have overlooked the answer that was already given. But still your statement that you did not get an answer was not what people usually call "the truth".

Let's end this and get back to the issue at hand: how do we need to elaborate on the answer already given to get closer to solving your issue?

Re: Macro

Astounding — Wed, 28 Jul 2021 12:24:24 GMT

Your original post started out as a lie:

I was able to get the frequency on 2 variables age and score and plot an histograms for both using the following formulas.

Both of the steps you posted contain an error. Neither will work. Maybe you got something to work, but it's not the code that you posted.

What does this say about you? I don't know. But I know it plays a role in why you got very little response to your question. For a macro to work, the code within it has to work. Once you wrap the code inside a macro, it becomes much more difficult to debug. So I wouldn't waste my time putting a macro around it when I know the macro has to fail. Rightly or wrongly, I am imagining that I would have to solve 3 or 4 questions instead of 1 ... how to write a macro, how to correct errors that result, and likely how to add functionality that is not included in your simplified program.

If you get your part right, there are dozens of posters who could easily answer your question.