topic Re: how do I use proc means for multiple data sets in SAS Procedures

how do I use proc means for multiple data sets

kthartma — Tue, 06 Feb 2018 18:10:33 GMT

Hi everyone,

I am new to SAS studio (3.4) and having some issues understanding how to use proc means for several data sets or if this is possible.

I have 5 SAS data sets in my library (different years of data for the same variables).

I want to conduct proc means for a few continuous variables for each data set and output it in a way that shows each variable's descriptive stats (N, Mean, Median, 10th and 90th percentile, max, min) by year (each data set).

Any advice would be much appreciated.

Re: how do I use proc means for multiple data sets

PaigeMiller — Tue, 06 Feb 2018 18:13:37 GMT

Concatenate the 5 datasets into one, using PROC APPEND, or a datastep.

Then run PROC MEANS using the BY statement to create analyses for each year.

In the future, do not break these data sets up by years, keep them together.

Re: how do I use proc means for multiple data sets

Reeza — Tue, 06 Feb 2018 18:21:04 GMT

@kthartma wrote:

Hi everyone,

I am new to SAS studio (3.4) and having some issues understanding how to use proc means for several data sets or if this is possible.

I have 5 SAS data sets in my library (different years of data for the same variables).

I want to conduct proc means for a few continuous variables for each data set and output it in a way that shows each variable's descriptive stats (N, Mean, Median, 10th and 90th percentile, max, min) by year (each data set).

Any advice would be much appreciated.

It's not good design to keep your data separated like that. The suggestion to combine the data is correct and then you can run PROC MEANS with a CLASS or BY statement to summarize it.

Here are some examples:

https://github.com/statgeek/SAS-Tutorials/blob/master/proc_means_basic.sas

http://video.sas.com/detail/videos/sas-analytics-u/video/3306906230001/summary-statistics-using-sas-studio?autoStart=true&page=1

Re: how do I use proc means for multiple data sets

kthartma — Tue, 06 Feb 2018 18:50:36 GMT

Thank you for the guidance!

Re: how do I use proc means for multiple data sets

kthartma — Tue, 06 Feb 2018 18:50:56 GMT

Thank you for the insight and links!

Re: how do I use proc means for multiple data sets

cheenaChuks — Sat, 30 Mar 2019 22:17:01 GMT

How would you use a class statement for two datasets? Please could you include a short example. I looked at the links but there were only examples with the by statement.