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:

http://www.epoch.co.in/

https://www.facebook.com/EpochResearchInstitute

https://twitter.com/epochresearch

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,

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

TTTTTTTTTTTTTTTTTTTTTTTTTTTT

TTTTTTTTTTTTTTTTTTTTTTTTTTTT

87654321 LONGTEXTTTTTTTTTTTTTTTTTTTTT

TTTTTTTTTTTTTTTTTTTTTTTTTTTT

TTTTTTTTTTTTTTTTTTTTTTTTTTTT

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:

http://www.epoch.co.in/

https://www.facebook.com/EpochResearchInstitute

https://twitter.com/epochresearch

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,
#CLINICALSASPROGRAMMING, #CLINICALSAS, #CLINICALSASPROGRAMMER

How PROC SQL is unique and different from most other SAS procedures? : Epoch Research Institute India Pvt. Ltd. (www.epoch.co.in)

How PROC SQL is unique and different from most other SAS procedures? : EpochResearch Institute India Pvt Ltd. (SASAuthorised Training : Ahmedabad | Bangalore)

Sometimes you might be wondering that how PROC SQL is unique and different from other SAS procedures. So here is a stop to your question. I will let you know the basics of PROC SQL and how it differs from other SAS procedures.

PROC SQL is the SAS execution of Structured Query language. SQL is the standardized language that is most probably used to retrieve data and update data in tables. PROC SQL can be used as an unconventional and alternative to other SAS procedures or the DATA step. Following is the list and functioning of PROC SQL. You can use PROC SQL for the following reasons:

•      Retrieving data and manipulate SAS tables

•      Modifying data values/adding data values in table

•      Drop columns in table

•      Creating tables and views

•      Generating reports and join multiple tables

PROC SQL allows you to combine data from two different external databases/external databases and SAS data set and presenting them in a single table. You can view it below:

Now next let’s drift to how SQL is unique and differ from other SAS procedures

There are numerous ways in which PROC SQL differs:

•      Many statements in PROC SQL are composed of clauses. Let’s take an example to assist you better. The PROC SQL statement mentioned below consists of two statements i.e. PROC SQL statement and SELECT statement. Further the select statement is composed of various clauses such as SELECT, ORDER BY, WHERE and FROM

        proc sql;

        select empid,jobcode,salary,

        salary*.06 as bonus

        from sasuser.payrollmaster

        where salary<32000

        order by jobcode;

•      PROC SQL executes each query automatically. It does not require RUN statement. If say, you use the RUN statement with PROC SQL, SAS ignores the RUN statement. But it executes the statement asusual and make a note. It is shown below

        SAS Log

       1884 proc sql;

       1885 select empid,jobcode,salary,

       1886 salary*.06 as bonus

       1887 from sasuser.payrollmaster

       1888 where salary<32000

       1889 order by jobcode;

       1890 run;

       NOTE: PROC SQL statements are executed immediately;

       The RUN statement has no effect.

•    PROC SQL carry on and run after you submit a step. So in order to end this statement, you need to submit another PROC step, or a QUIT statement. The example is mentioned below:

      proc sql;

      select empid,jobcode,salary,

      salary*.06 as bonus

      from sasuser.payrollmaster

      where salary<32000

      order by jobcode;

      quit;

Note: SAS enterprise guide automatically inserts a QUIT statement to code when it is submitted to SAS. But still precaution should be taken and you be habituated to add the QUIT statement to the code.

So this was all from my side regarding PROC SQL. I would always encourage the views and responses from your side..

Epoch Research Institute Links:

http://www.epoch.co.in/

https://www.facebook.com/EpochResearchInstitute

https://twitter.com/epochresearch

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,#EPOCHSAS FEEDBACK,#CLINICALSAS,#CLINICALSASPROGRAMMING, #CLINICALSASPROGRAMMER