Sas interview questions and answers on macros

#SAS INTERVIEW QUESTIONS AND ANSWERS ON MACROS PDF#

20-30 datasets is required for a study to get analyzed for the safety and efficacy parameters. How many analyzed data sets did you create?Р”Р„gain it depends on the study and the safety and efficacy parameters that are need to determined from the study. If the study is phase3 answer should be approx. If the study is phase2 answer should be approx. If the study is phase1 answer should be approx.

Subjects are nothing but the patients involved in the clinical study.Р”Р„nswer to this question depends on the type of the study you have involved in. To get the all these details always refer. Here are some more details you need to lay down in front of himРІР‚В¦Р”Р„) Is it a single blinded or double-blinded study?Р”В«) Is it a randomized or non-randomized study?Р”В) Safety parameters only (if it is a phase-1)Р”В®) Safety and efficacy parameters if the study is either Phase-2,3or 4. You also need to tell about the name of the drug and the therapeutic area of it. If the interviewer asked you this question, then you need to tell that your current project is on a phase-1 study (or phase-2/Phase-3). Generating the demographic tables, adverse events and serious adverse events reports.Р”В¬an you tell me something about your last project study design?.Analyzing the data according to the Statistical Analysis Plan (SAP).Creating the Statistical reports using Proc Report, Data _null_ and SAS Macro.Performing data extraction from various repositories and pre-process data when applicable.

#SAS INTERVIEW QUESTIONS AND ANSWERS ON MACROS PDF#

Creating the Ad hoc reports using the SAS procedures and used ODS statements and PROC TEMPLATE to generate different output formats like HTML, PDF and excel to view them in the web browser.

Validating and QC of the efficacy and safety tables.Developing the Macros at various instances for automating listings and graphing of clinical data for analysis.Using the Base SAS (MEANS, FREQ, SUMMARY, TABULATE, REPORT etc) and SAS/STAT procedures (REG, GLM, ANOVA, and UNIVARIATE etc.) for summarization, Cross-Tabulations and statistical analysis purposes.Involved in mapping, pooling and analysis of clinical study data for safety.Developing the SAS programs for listings & tables for data review & presentation including ad-hoc reports, CRTs as per CDISC, patients listing mapping of safety database and safety tables.Creating and deriving the datasets, listings and summary tables for Phase-I and Phase-II of clinical trials.Developing programs in SAS Base for converting the Oracle Data for a phase II study into SAS datasets using SQL Pass through facility and Libname facility.

Extracting the data from various internal and external database (Oracle, DB2, Excel spreadsheets) using SAS/ACCESS, SAS/INPUT.

Some of them include not necessarily all of themРІР‚В¦. therapeutic areas a pharmaceutical company can work on and few of them include, anti-viral (HIV), AlzheimerРІР‚в„ўs, Respiratory, Oncology, Metabolic Disorders (Anti-Diabetic), Neurological, Cardiovascular. What is the therapeutic area you worked earlier?

Sas interview questions and answers on macros