demoninator = 49.2333333333333333 numerator = 1.057775751 Thanks again, Reeza 1.057775751 1.057775751 ... View more

Not when I do divisions. 46.54421 and 46.4645 are elements of result(i). result(i)= round(numerator(i)/denominator(i)) Thanks, Reeza. ... View more

Thanks alot Reeza. Regardless of how I write the ROUND function, I find that rounding seems to 'operate' differently in SAS and Excel. For instance 46.54421 is rounded to 47 in Excel and 46 in SAS and 46.4645 is rounded to 46 in Excel and 47 in SAS. I will check the link out. ... View more

Thanks Dr. Muhlbaier. Those functions work on single numbers but not when multiplication/division is involved. Do you happen to know the equivalent SAS syntax/functon for ROUND(+B50/J50,0)) in MS Excel? I assume that the plus(+)  sign indicate a positive number and not a ceiling function but I could be wrong. Below is part of my syntax: result(i)= round(numerator(i)/denominator(i)); or should I use result(i)= round((ceiling(numerator(i)))/(denominator(i))) instead? I wonder if there is anything missing in my code .  . . Thanks again, Hui PS: I have to convert various Excel pivot tables into SAS datasets and my results differ. ... View more

Hi Cynthia, I tried ROUND, ROUNDE, and ROUNDZ functions and my results still do not turn out correctly. I welcome any suggestion(s) you may have for me. Thanks, Hui ... View more

Thanks Quetin. ... View more

Hi Matthew, May I know how you do it? I can't see the data in my work library either, when I run stored process. Thanks, Hui ... View more

Thanks alot Doc. Have a great weekend! Hui ... View more

Thanks for your swift response. How should my proc import statement look like if I were to import it as a 'view' rather than as a dataset? I apologize for my ignorance . .. We use SAS Enterprise Guide here and I do not have sufficient authorization to do DDE . .. With kind regards, Hui   Hui P. Liew, Ph.D. Data Analyst MedExpress Headquarters 1751 Earl Core Road Morgantown, WV 26505 ... View more