BookmarkSubscribeRSS Feed
Demographer
Pyrite | Level 9

Hi,

I wonder under a data statement, there is a function equivalent to NORM.DIST from Excel (which returns the non-cumulative probability of x giving an average and a SD). 

For instance, for an average of 26 and a SD is 10, I want the variable prob the value 0.001752 if x=1, 0.002239 if x=2, etc.

1 REPLY 1
ballardw
Super User

It looks like you want the PDF function. Example:

data example;
   input x;
   p2 = pdf('normal',x,26,10);
datalines;
1
2
3
26
;

'normal' is the name of the distribution. SAS will work with a number of distributions. X is the value of interest and the next parameters are the mean and standard deviation. If you leave off the mean and standard deviation SAS will use 0 and 1.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 1237 views
  • 0 likes
  • 2 in conversation