/*Published: 06/01/2020 */

*filename mdppas '/directory/md_ppas15.txt';                     /*reading in an un-zipped file*/
*filename mdppas pipe 'gunzip -c /directory/md_ppas15.txt.gz';   /*reading in a zipped file*/
*filename mdppas pipe 'gunzip -c /directory/md_ppas*.txt.gz';    /*using wildcard to match multiple files */
options nocenter validvarname=upcase;

data mdppas;
   infile mdppas lrecl=509 missover pad;
   input
     @001  NPI                     $CHAR10.
     @091  SPEC_BROAD              1.
     @092  SPEC_PRIM_1             $CHAR2.
     @094  SPEC_PRIM_1_NAME        $CHAR38.
     @132  SPEC_PRIM_2             $CHAR2.
     @134  SPEC_PRIM_2_NAME        $CHAR38.
     @172  SPEC_HOSP_CLAIMS_BASED  1.
     @173  SPEC_SOURCE             1.
     @174  SEX                     $CHAR1.
     @175  BIRTH_YR                4.
     @183  STATE                   $CHAR2.
     @185  STATE_MULTI             1.
     @186  CBSA_TYPE               1.
     @187  CBSA_CD                 $CHAR5.
     @192  CBSA_NAME               $CHAR50.
     @242  CBSA_MULTI              1.
     @243  NPI_SRVC_LINES          8.
     @251  NPI_ALLOWED_AMT         12.2
     @263  NPI_UNQ_BENES           8.
     @271  TIN1                    $CHAR9.
     @350  TIN1_SRVC_MONTH         $CHAR12.
     @362  TIN1_SRVC_LINES         8.
     @370  TIN1_ALLOWED_AMT        12.2
     @382  TIN1_UNQ_BENES          8.
     @390  TIN2                    $CHAR9.
     @469  TIN2_SRVC_MONTH         $CHAR12.
     @481  TIN2_SRVC_LINES         8.
     @489  TIN2_ALLOWED_AMT        12.2
     @501  TIN2_UNQ_BENES          8.
   ; 
   label  
       NPI                    = "National Provider Identifier"       /*****Encrypted*****/
       SPEC_BROAD             = "Specialty broad category"
       SPEC_PRIM_1            = "Specialty primary 1 code"
       SPEC_PRIM_2            = "Specialty primary specialty 2 code"
       SPEC_PRIM_1_NAME       = "Specialty primary specialty 1 name"
       SPEC_PRIM_2_NAME       = "Specialty primary specialty 2 name"
       SPEC_HOSP_CLAIMS_BASED = "Specialty hospitalist indicator"
       SPEC_SOURCE            = "Specialty source data (1=PECOS, 0=Claims)"
       SEX                    = "Provider sex"
       BIRTH_YR               = "Provider birth year"
       STATE                  = "Provider state"
       STATE_MULTI            = "Provider multiple state indicator"
       CBSA_TYPE              = "Provider core-based statistical area (type)"
       CBSA_CD                = "Provider core-based statistical area (numeric code)"
       CBSA_NAME              = "Provider core-based statistical area (name)"
       CBSA_MULTI             = "Provider multiple CBSA"
       NPI_SRVC_LINES         = "Provider total number of service lines"
       NPI_ALLOWED_AMT        = "Provider total allowed charges"
       NPI_UNQ_BENES          = "Provider total number of unique beneficiaries"
       TIN1                   = "Tax identification number (TIN1) with the most service lines"   /*****Encrypted*****/
       TIN1_SRVC_MONTH        = "TIN1 monthly indicator"
       TIN1_SRVC_LINES        = "TIN1 total number of service lines"
       TIN1_ALLOWED_AMT       = "TIN1 total allowed charges"
       TIN1_UNQ_BENES         = "TIN1 total number of unique beneficiaries"
       TIN2                   = "Tax identification number (TIN2) with the most service lines"   /*****Encrypted*****/
       TIN2_SRVC_MONTH        = "TIN2 monthly indicator"
       TIN2_SRVC_LINES        = "TIN2 total number of service lines"
       TIN2_ALLOWED_AMT       = "TIN2 total allowed charges"
       TIN2_UNQ_BENES         = "TIN2 total number of uniwue beneficiaries"
     ;
run;

proc contents data=mdppas position;
run;