About mjabed600

hashman · ‎07-30-2018

@PGStats, You're most welcome. I have no choice but to continue as a penance for the audacity of triggering this SAS hash thingy in the first place almost exactly 20 years ago ;). Best Paul D.

PaigeMiller · ‎07-29-2018

This is pretty simple using two PROC SUMMARY calls. The first PROC SUMMARY computes the sum of the sales by customer_id and year; the second takes the results of the first and finds the maximum values per year and the customer_id associated with the maximum value.

mjabed600 · ‎07-27-2018

Thank you all for your input. I guess I over-complicated a simple solution. I'll try to practice my base skills further before jumping into macros.

mjabed600 · ‎07-26-2018

Hey, I am trying to do something similar i.e. create a report with the mean of a variable (price) in the title but I wanted to know how would you create a macro variable for the mean to reference in the title without the proc sql step. would it be easier to do with proc means or proc report?

mjabed600 · ‎07-24-2018

Thank you for the reply.

Online Status	Offline
Date Last Visited	‎07-30-2018 10:59 PM

Re: how to add a row

proc sql to find the max(variable) in each year

Re: Macro for Splitting one data set into multiple data sets

Macro for Splitting one data set into multiple data sets

Re: How to print mean of a variable in the title of the report

Re: Using the year(variable) function in %IF%THEN%ELSE

Re: Using the year(variable) function in %IF%THEN%ELSE

Using the year(variable) function in %IF%THEN%ELSE

Re: Macro for Splitting one data set into multiple data sets

Re: Macro for Splitting one data set into multiple data sets

Re: how to add a row

Re: proc sql to find the max(variable) in each year

Re: Macro for Splitting one data set into multiple data sets

Re: How to print mean of a variable in the title of the report

Re: Using the year(variable) function in %IF%THEN%ELSE