Thanks for your valuable comments. I need to conduct a ANOVA test with a samples. Hence I would except  my samples to be normal. Will it sounds good if I remove the values which are less than or equal 0 before applying log-normal distribution ? I wonder when I see the various moments (non-normal to normal) for my variable after I switch over from normal to log-normal? What is the significance behind log-normal distribution? Can it be applied to the variable 'balance/amount'? ... View more

Any suggestions? ... View more

Minimum account in my dataset is 0 and the maximum is 124346. When I tried the code below. ods graphics on; options maxmemquery =6M; proc univariate data=Anova_data_new normaltest plots; var tot_balanc; histogram /midpoints=1 to 124346 by 1000  /*How to find the divisor value*/                lognormal; run; ods graphics off; Encounted by error as ERROR: The smallest value of amount is less than or equal to the threshold parameter (THETA) for the lognormal fit.  According to documenation, The threshold parameter must be less than the minimum data value. You can specify with the THRESHOLD= lognormal-option. By default, . If you specify THETA=EST, a maximum likelihood estimate is computed for . You can specify and with the SCALE= and SHAPE= lognormal-options, respectively. By default, the procedure calculates maximum likelihood estimates for these parameters. But I'm not sure how to compute theta value for my data. May I request you to extend your help on the same? Also let me know why we going for log normal distribution instead of normal distribution? ... View more

I don't see much difference in my output with the options 'Normaltest'. My code is below. proc univariate data=normality normaltest ; var balance; histogram /normal (color=red); run; Any other suggestions to produce a normal data? Thanks! ... View more