SAS Data Management

SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop, SAS Data Preparation and others
BookmarkSubscribeRSS Feed
TW16
Calcite | Level 5

i have a data set of means, stds, min and max. I want to explore the data utilizing all the information i have...ie incorporating the standard deviation along with the means. How do i do that. I don't have the raw data for each mean or std.

4 REPLIES 4
ballardw
Super User

What kind of research questions are you trying to answer.

 

You don't mention whether you have the n (count of subjects) any of those stats are based on. That may make things very hard much with.

TW16
Calcite | Level 5
I am trying to evaluate the distribution, see outliers, see if a process is
under control, observe corrilations and evaluate capabilities. I am
assuming n is the same for all.

##- Please type your reply above this line. Simple formatting, no
attachments. -##
Ksharp
Super User
It is about data simulation.
Better post it at IML forum.

use rand() you can get normal distribution with a special mean and std.
once the data are out the range min-max , throw it out the window.
data have;
do i=1 to 10000;
x=rand('nomal',mean,std);
if min<=x<=max then output;
end;
run;


sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1204 views
  • 0 likes
  • 3 in conversation