05-02-2016 10:51 AM
Thank you for your support. I do not have Ci calculated through SAS. I wanted to provide you more details as follows:
I wanted to achieve custom calculation for the attached data. I have this calculation in excel, but in order to submit to FDA, I need it in SAS. I am using SAS 9.4 TS level 1M2.
The workbook has 3 spreadsheets as follows:
On the test and reference spreadsheets, I wanted the SAS program to calculate the yellow highlighted fields.
On the output sheet, I have data taken from the test and reference spreadsheets and further calculated results and plotted charts. The output sheet also has calculation formula for Q and other fields shown above.
I wanted to achieve the output sheet as a SAS report. Can you please help me by providing a detailed code. I really appreciate your help in this manner.
let me know if you have any questions.
05-02-2016 01:41 PM
The FDA probably wants YOU (@DShah) to understand the SAS output that you submit, not for SAS to provide output that supports claims based on your spreadsheet calculations.
05-02-2016 01:47 PM
The FDA is asking us to provide the data in form of .XPT format. Probably they will perform the calculations once they receive. I wanted to make sure that we perform those calculations at our end and ensure that the data at both ends will be the same.