topic Equivalent for SAS of the Excel function norm.dist in SAS Programming

Equivalent for SAS of the Excel function norm.dist

Demographer — Thu, 16 Apr 2020 16:15:35 GMT

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.

Re: Equivalent for SAS of the Excel function norm.dist

ballardw — Thu, 16 Apr 2020 16:32:08 GMT

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.