qa_package_pd

/*-------------------------------------------------------------------------------------*\

|  PROGRAM NAME:                                                                        |

|     scdm_data_qa_review-patientsurvey.sas                                             |

|                                                                                       |                                 |

|---------------------------------------------------------------------------------------|

|  PURPOSE:                                                                             |

|     The purpose of this program is to perform data quality checks on the Patient      |

|     reported measures / outcomes (PRM) survey table.                                  |

|---------------------------------------------------------------------------------------|

|  PROGRAM INPUT:                                                                       |

|     see 00.0_scdm_prm_data_qa_review_master_file.sas                                  |

|                                                                                       |

|  PROGRAM OUTPUT:                                                                      |

|     see Workplan PDF                                                                  |

|---------------------------------------------------------------------------------------|

|  CONTACT:                                                                             |

|     Sentinel Coordinating Center                                                      |

|     info@sentinelsystem.org                                                           |

\*-------------------------------------------------------------------------------------*/

​

*-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-;

*  PLEASE DO NOT EDIT BELOW WITHOUT CONTACTING THE SENTINEL OPERATIONS CENTER           ;

*-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-;

​

/*-------------------------------------------------------------------------------------*/

/*  START Level 2                                                                      */

/*-------------------------------------------------------------------------------------*/

%let level=2;

​

/*-------------------------------------------------------------------------------------*/

/*  START Level 2 Flags                                                                */

/*-------------------------------------------------------------------------------------*/

%level2;

​

/*-------------------------------------------------------------------------------------*/

/*  START Level 3                                                                      */

/*-------------------------------------------------------------------------------------*/

%let level=3;

​

%let qa_table= ;

%macro get_qa_table ;

  %if &do_partitions and not %eval(&module in &tabid_exc) %then %do ;

    data t_view /view=t_view ;

      set qadata.&&&module.table.: (keep=prm_code surveyid survey_name questionid questionverid question_dt) ;

    run;

    %let qa_table = t_view ;

  %end ;

  %else %do;

    %let qa_table = qadata.&&&module.table (keep=prm_code surveyid survey_name questionid questionverid question_dt) ;

  %end;

%mend;

%get_qa_table ;

proc sql noprint;

  create table dplocal.&module._temp as 

  select prm_code

       , surveyid

       , survey_name

       , questionid

       , questionverid

       , question_dt

       , count(*) as n

  from &qa_table

  group by 1,2,3,4,5