Clinical SAS Programming | Data Science| SAS Training in Bangalore

https://www.linkedin.com/company/epoch-research-institute-india-pvt-ltd-

Email us: info@epoch.co.in

SAS Training & Placement Programs with Internship: Epoch Research Institute India Largest and Oldest #SASTraining Institute (#epochsastraining)

EPOCH RESEARCH INSTITUTE OFFERS:

Authorized SAS TRAINING | SAS CERTIFICATION | SOFTWARE PURCHASE | BUINESS CONSULTING | TECHNICAL SUPPORT ON SAS || SAS STAFFING SOLUTION

Label:

#SASELEARNING,#SASELEARNING,#SASONLINETRAINING,

#SASONLINETRAININGFORBEGINNERS,#LEARNSASPROGRAMMINGONLINE,

#SASCLINICALONLINETRAINING,#SASBASEONLINETRAINING

#BIGDATASASTRAININGEPOCH,#SASBIGDATATRAINING #EPOCHRESEARCHINSTITUTE, #SASTRAINING, EPOCH SAS FEEDBACK,

Thursday, 22 February 2018

SAS Training from fresher corner : Epoch Research Institute India Pvt. Ltd. (www.epoch.co.in)

SAS Training from fresher corner : EpochResearch Institute India Pvt Ltd. (SASAuthorised Training : Ahmedabad | Bangalore | Chennai)

Resume building

Group discussion training sessions

Aptitude training and problem solving skills

Personal development

Technical interviews training

HR interviews

Mock preparations

Aptitude training sessions

Group discussion training sessions

Technical interview sessions

Personal interview sessions and HR sessions

So these were some of the fundamentals regarding our SAS training sessions from fresher corners. You can share your ideas and views.

Epoch Research Insitute Links:

https://www.linkedin.com/company/epoch-research-institute-india-pvt-ltd-

Email us: info@epoch.co.in

SAS Training & Placement Programs with Internship: Epoch Research Institute India Largest and Oldest #SASTraining Institute (#epochsastraining)

EPOCH RESEARCH INSTITUTE OFFERS:

Authorized SAS TRAINING | SAS CERTIFICATION | SOFTWARE PURCHASE | BUINESS CONSULTING | TECHNICAL SUPPORT ON SAS || SAS STAFFING SOLUTION

Label:

#SASELEARNING,#SASELEARNING,#SASONLINETRAINING,

#SASONLINETRAININGFORBEGINNERS,#LEARNSASPROGRAMMINGONLINE,

#SASCLINICALONLINETRAINING,#SASBASEONLINETRAINING

#BIGDATASASTRAININGEPOCH,#SASBIGDATATRAINING #EPOCHRESEARCHINSTITUTE, #SASTRAINING, EPOCH SAS FEEDBACK,

Wednesday, 13 July 2016

What are the job responsibilities and tasks of Clinical SAS Programmer? : Epoch Research Institute India Pvt. Ltd. (www.epoch.co.in)

What are the job responsibilities and tasks of Clinical SAS Programmer? : EpochResearch Institute India Pvt Ltd. (SASAuthorised Training : Ahmedabad | Bangalore)

I hope so you might have enjoyed my last post and viewed the video “How SAS is applied in Clinical trials?” Today I want to share my views on what are the job tasks and duties of a Clinical SAS programmer. Being a Clinical SAS programmer is not a effortless and straightforward task. There are various job responsibilities and duties of a Clinical SAS programmer. Now here we will discuss what the overall purpose of the job role is:
• He has to create the SAS datasets of clinical data from Biometric databases• He has to create the status and effective datasets.• Has to create specific macros and formats• He has to prepare the data to send it to clients• He has to load the data of client’s from other platform• He has to create listings, summary tables as well as graphs keeping in view the statistical analysis plan

Now let’s discuss the responsibilities of Clinical SAS programmer. It is mentioned below:
•    He has to create the tables, review tables and listing mocks
•    He has to make certain that the internal consistency is maintained among tables and listings
•    He has to be certain whether all the CRF fields are displayed on the listings or not
•    He has to review the clinical data for invalid data points and outliers
•    He has to get in touch with Clinical data management in order to resolve the issues related to data
• He should be capable to use the frequencies, Proc transpose as well as macros and in accordance with it must be able to modify the existing macros and write macros
• He must follow all the relevant SOP’s and guidelines taking into consideration programming and the change control management of all the files that are created by Biometric programming group
• The code has to be written using Base SAS program, SAS procedures or standardized macros
• The data check has to be performed as per the requirement in order to understand the structure and content of the data
• He has to write and compare the QC programs in order to verify the output that is generated for data display
• Coordination is required for qc project teams on large projects. This includes training and entrustment of QC work
•    He has to send the tables and listings to clinical writers and clients
•    He has to attend both the client as well as team meetings as per the requirement
• He has to assist in setting up departmental processes as well as should also interact with other departments or other departmental administrative tasks
So these are the job responsibilities and duties of a Clinical SAS programmer. Do you know much more regarding the same? Kindly provide with your views.

Epoch Research Institute Links:

https://www.linkedin.com/company/epoch-research-institute-india-pvt-ltd-

Email us: info@epoch.co.in

SAS Training & Placement Programs with Internship: Epoch Research Institute India Largest and Oldest #SASTraining Institute (#epochsastraining)

EPOCH RESEARCH INSTITUTE OFFERS:

Authorized SAS TRAINING | SAS CERTIFICATION | SOFTWARE PURCHASE | BUINESS CONSULTING | TECHNICAL SUPPORT ON SAS || SAS STAFFING SOLUTION

Label:

#SASELEARNING,#SASELEARNING,#SASONLINETRAINING,

#SASONLINETRAININGFORBEGINNERS,#LEARNSASPROGRAMMINGONLINE,

#SASCLINICALONLINETRAINING,#SASBASEONLINETRAINING

#BIGDATASASTRAININGEPOCH,#SASBIGDATATRAINING #EPOCHRESEARCHINSTITUTE, #SASTRAINING, EPOCH SAS FEEDBACK,

Thursday, 30 June 2016

Some of the top and the excellent reasons to use PROC SQL : Epoch Research Institute India Pvt. Ltd. (www.epoch.co.in)

Some of the top and the excellent reasons to use PROC SQL : EpochResearch Institute India Pvt Ltd. (SASAuthorised Training : Ahmedabad | Bangalore)

PROC SQL is a very dominant tool. It can make your life much simpler and easier. I have seen SAS users divided among two groups. One of the groups loves PROC SQL while the other group hates PROC SQL. But if it comes to me, I would personally let you know that I fell in love with PROC SQL in earlier time during my learning periods. This is just because I have found that lot of tasks can be easily done in PROC SQL. Sometimes it even happens they are not even possible with other SAS procedures. As per my view, I have seen that there are various different advantages of PROC SQL in making SAS programming and coding task simpler and more spontaneous. Now these are top reasons for using PROC SQL as shown below

Fuzzy merge

The process of matching the records where the condition of a match is based on near but not the equal condition is known as Fuzzy merge. For e.g. in survival analysis, we need to know whether a member is dead so for the same we need to match our sample to the death records in death tape. We compare the variables that are matching and assign points to them. The score of 16 would be a great match. But when it comes to real life, it is not true. So our rule will be that the score of 13 and above will be considered a match. We will do a manual checking for any score between 9 and 12 whether it is a match.

PROC SQL;

CREATE TABLE REVIEW AS

SELECT *

FROM SAMPLE, OW_DEATH

WHERE SUM( ((KBMON =SBMON)*2), ((KBDAY =SBDAY)*1),

((KBYEAR =SBYEAR)*2),

((KFSNDX =SFSNDX)*1), ((KFNAME =SFNAME)*1),

((KMNAME =SMNAME)*1),

((KLSNDX =SLSNDX)*1), ((KLNAME =SLNAME)*1),

((KSEX =SSEX)*2) , ((KSSN =SSSN and KSSN ne ' ')*4) )

>=9;

QUIT;

Summarize the data

SQL functions can be used to summarize data. PROC SQL is more spontaneous than PROC MEANS or PROC SUMMARY. SAS creates and output table containing more rows and columns that are required and you have to choose right_TYPE_value.

COALESCE function

PROC SQL makes the assortment process very easy and simpler where the COALESCE function will pick the first non-missing value.

Insert record to table

I have mentioned the code below to estimate the mid-year membership reckoning from eligibility file for year from 1986 – 2002 (Note that this is just a demonstration purpose, the code is not efficient). Here there is a macro %DO-%END loop where each iteration will produce two macro variables and PROC SQL will insert a new record into the table. If we compared SQL to Base SAS processing, SQL saves one step.

%MACRO MULTI_YR (BY=, EY= );

*---creating empty table---;

DATA MYEARPOP; MYEAR=.; POP=.; DELETE; RUN;

%DO I= &BY %TO &EY;

PROC SQL NOPRINT;

SELECT COUNT(*) INTO :RECORDS

FROM CCPSSD.KPOPGAP2

WHERE FDATE LE "01jul&I"D LE TDATE;

;QUIT; %put &records;

PROC SQL; INSERT INTO MYEARPOP

SET MYEAR=&I,POP=&RECORDS

;QUIT;

%END;

%MEND MULTI_YR;

%MULTI_YR(BY=1986,EY=2002 );

Matching several tables at different levels

Here I have joined three tables. Here the task to be performed is to get inpatient diagnoses existing in OO.ADT_DIAG for sample table. The middle table serves as a link for the other two tables as it contains both the matching variables.

PROC SQL;

CREATE TABLE ADT AS

SELECT A.HRN, DIAG

FROM SAMPLE AS A , OO.ADT_REG (dbkey=HRN dbnullkeys=no) AS B,

OO.ADT_DIAG (dbkey=MAIN_KEY dbnullkeys=no) AS C

WHERE A.HRN = B.HRN and B.MAIN_KEY=C.MAIN_KEY

;QUIT;

Count frequencies

PROC SQL makes it an ease to count the non-missing values for number of variables and give an output on one line.

PROC SQL; SELECT COUNT(*) AS TOTAL,

COUNT(DIAG0001) AS DX1,

COUNT(DIAG0002) AS DX2,

COUNT(DIAG0003) AS DX3,

COUNT(DIAG0004) AS DX4

FROM INP; QUIT;

TOTAL DX1 DX2 DX3 DX4

--------------------------------------------------

1562 1562 1421 1163 814

Textwrapping

You have a long character variable. Now you want to print the values using PROC PRINT. You will get a warning message such like: “Data too long for column “COMMENT” truncated to 124 characters to fit”. Use PROC SQL with flow option To avoid such an error message.

PROC SQL FLOW=30;

SELECT HRN, COMMENT

FROM A

;QUIT;

HRN COMMENT

--------------------------------------

12345678 LONGTEXTTTTTTTTTTTTTTTTTTTTT

TTTTTTTTTTTTTTTTTTTTTTTTTTTT

87654321 LONGTEXTTTTTTTTTTTTTTTTTTTTT

TTTTTTTTTTTTTTTTTTTTTTTTTTTT

My conclusion: PROC SQL is code-saving but it is not always time-saving. You can share your views if you have any.

Epoch Research Institute Links: