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

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

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

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

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

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

It is just two different questions so I just didn’t switch from sql to proc summary but Thank you ... View more

How can I calculate the average in a proc sql using group by statement? ... View more

How can I calculate the aversion in a proc sql using group by statement? ... View more

What about RENAME in sql? ... View more

Thank you very much ... View more

@Paige do you know by any chance how to use KEEP statement in SQL? ... View more

It’s just a requirement of the question choosing what to merge first ... View more

Sorry the second question just meant use the average you just calculate and another average from another question and merge them together using 2 different variables roads and cara and also the method they used to apply debt consolidation and the question asking you to decide which average to merge first ... View more