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. ... View more

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. ... View more

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. ... View more

@nhev wrote: How can I calculate the aversion in a proc sql using group by statement? How do you calculate an "aversion" in SQL without a group by statement? I haven't ever had to calculate an "aversion" before and haven't a clue where to start.   This forum prefers that a question relates to a single topic, or interactive topics around a process.   Adding random questions not related to a previous question we prefer to see a new thread that is easier for folks to read and follow when they find the topic from a search somewhere. Adding non-related topics to the subject line makes that harder for inexperienced SAS users to find solutions to their problems. ... View more

Thank you so much Reeza ... View more