I have to columns. One is the Center and the other is diastolic blood pressure reading. How to i compute the average diastolic blood pressure for each center while retaining all other variables in the data set.
Can you please post a sample of what you HAVE and what you WANT?
Really, you could show us some example of your data, and an example of the results you want, so we can truly understand what you are asking for. Without that, we are merely guessing, and possibly wasting evereyone's time.
Here's my guess:
Use PROC SUMMARY with center in the CLASS statement, then merge the results into the original data set.
If that's the answer, great.
If not, DO NOT REPLY that this doesn't work without showing us an exaample of your data and the desired result.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.