I'm running a Chi Sq test with 2 binary variables. The data are large (>1 million rows) and not balanced (rare event). The test is statistically significant (p < .0001) and the Cramer's V is very small (.006). I took this to mean there is no relationship and the p value is due to such a large sample size/power. However, the odds ratio is 4.4.   I'm trying to understand how one effect size (Cramer's V) can be so unlike another (Odds Ratio)? Is the Cramer's V sensitive to data imbalance? Is the OR preferred in this case?   ... View more

Hi expert   I'm trying to model a binary outcome event (1=opportunity generated, 0=opportunity missing), based on a set of covariate, one of which is categorical and binary (presence or not of a marketing interaction)   Output provided below     I'm getting for the categorical covariate estimate="0". I remember I have read somewhere that whenever a variable can be represented as linear outcome of other covariates it will not be represented with a coefficient. Then the question is how to check if that covariate is significant?   Bests ... View more

I’m a student currently learning to use SAS for my studies. I’m interested in accessing the basic functions of SAS on my local machine, and if possible, I’d like to know if there are any free options available for students.  ... View more

In the folder, there are 2 files: a1.csv and a2.csv The part of the code is: infile "/doc/a*.csv"; It is reading both files. I want only the latest one. ... View more

Hello, I am getting this error with my code which is trying to create a wide format of my variables. Similar issue have been resolved online but I could not figure out the problem. Thanks in advance. Here is the code and log: /* STEP 5.2: TRANSFORM CARRIER LINE FILE */ data bcarline2016_2021_wide (drop=i line_1st_expns_dt line_last_expns_dt hcpcs_cd line_icd_dgns_cd line_num line_nch_pmt_amt prf_physn_npi tax_num); format line_1st_expns_dt_1-line_1st_expns_dt_13 mmddyy10. line_last_expns_dt_1-line_last_expns_dt_13 mmddyy10. line_icd_dgns_cd1- line_icd_dgns_cd13 $5. hcpcs_cd1-hcpcs_cd13 $7. line_nch_pmt_amt1-line_nch_pmt_amt13 10.2 prf_physn_npi1-prf_physn_npi13 $12. tax_num1-tax_num13 $10.; set bcarline2016_2021; by bene_id clm_id line_num; retain line_1st_expns_dt_1-line_1st_expns_dt_13 line_last_expns_dt_1-line_last_expns_dt_13 line_icd_dgns_cd1-line_icd_dgns_cd13 hcpcs_cd1-hcpcs_cd13 line_nch_pmt_amt1-line_nch_pmt_amt13 prf_physn_npi1-prf_physn_npi13 tax_num1-tax_num13; array xline_icd_dgns_cd(13) line_icd_dgns_cd1-line_icd_dgns_cd13; array xline_1st_expns_dt_(13) line_1st_expns_dt_1-line_1st_expns_dt_13; array xline_last_expns_dt_(13) line_last_expns_dt_1-line_last_expns_dt_13; array xhcpcs_cd(13) hcpcs_cd1-hcpcs_cd13; array xline_nch_pmt_amt(13) line_nch_pmt_amt1-line_nch_pmt_amt13; array xprf_physn_npi(13) prf_physn_npi1-prf_physn_npi13; array xtax_num(13) tax_num1-tax_num13; if first.clm_id then do; do i=1 to 13; xline_icd_dgns_cd(line_num)=''; xline_1st_expns_dt_(line_num)=.; xline_last_expns_dt_(line_num)=.; xhcpcs_cd(line_num)=''; xline_nch_pmt_amt(line_num)=.; xprf_physn_npi(line_num)=''; xtax_num(line_num)=''; end; end; xline_icd_dgns_cd(line_num)=line_icd_dgns_cd; xline_1st_expns_dt_(line_num)=line_1st_expns_dt; xline_last_expns_dt_(line_num)=line_last_expns_dt; xhcpcs_cd(line_num)=hcpcs_cd; xline_nch_pmt_amt(line_num)=line_nch_pmt_amt; xprf_physn_npi(line_num)=prf_physn_npi; xtax_num(line_num)=tax_num; if last.clm_id then output; run; Log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 /* STEP 5.2: TRANSFORM CARRIER LINE FILE */ 74 data bcarline2016_2021_wide (drop=i line_1st_expns_dt line_last_expns_dt hcpcs_cd line_icd_dgns_cd line_num 74 ! line_nch_pmt_amt prf_physn_npi tax_num); 75 format line_1st_expns_dt_1-line_1st_expns_dt_13 mmddyy10. 76 line_last_expns_dt_1-line_last_expns_dt_13 mmddyy10. 77 line_icd_dgns_cd1- line_icd_dgns_cd13 $5. 78 hcpcs_cd1-hcpcs_cd13 $7. 79 line_nch_pmt_amt1-line_nch_pmt_amt13 10.2 80 prf_physn_npi1-prf_physn_npi13 $12. 81 tax_num1-tax_num13 $10.; 82 set bcarline2016_2021; 83 by bene_id clm_id line_num; 84 retain line_1st_expns_dt_1-line_1st_expns_dt_13 85 line_last_expns_dt_1-line_last_expns_dt_13 86 line_icd_dgns_cd1-line_icd_dgns_cd13 87 hcpcs_cd1-hcpcs_cd13 88 line_nch_pmt_amt1-line_nch_pmt_amt13 89 prf_physn_npi1-prf_physn_npi13 90 tax_num1-tax_num13; 91 92 array xline_icd_dgns_cd(13) line_icd_dgns_cd1-line_icd_dgns_cd13; 93 arrayxline_1st_expns_dt_(13) line_1st_expns_dt_1-line_1st_expns_dt_13; 94 arrayxline_last_expns_dt_(13) line_last_expns_dt_1-line_last_expns_dt_13; 95 arrayxhcpcs_cd(13) hcpcs_cd1-hcpcs_cd13; 96 arrayxline_nch_pmt_amt(13) line_nch_pmt_amt1-line_nch_pmt_amt13; 97 arrayxprf_physn_npi(13) prf_physn_npi1-prf_physn_npi13; 98 arrayxtax_num(13) tax_num1-tax_num13; 99 100 if first.clm_id then do; 101 do i=1 to 13; 102 xline_icd_dgns_cd(line_num)=''; 103 xline_1st_expns_dt_(line_num)=.; 104 xline_last_expns_dt_(line_num)=.; 105 xhcpcs_cd(line_num)=''; 106 xline_nch_pmt_amt(line_num)=.; 107 xprf_physn_npi(line_num)=''; 108 xtax_num(line_num)=''; 109 end; 110 end; 111 112 xline_icd_dgns_cd(line_num)=line_icd_dgns_cd; 113 xline_1st_expns_dt_(line_num)=line_1st_expns_dt; 114 xline_last_expns_dt_(line_num)=line_last_expns_dt; 115 xhcpcs_cd(line_num)=hcpcs_cd; 116 xline_nch_pmt_amt(line_num)=line_nch_pmt_amt; 117 xprf_physn_npi(line_num)=prf_physn_npi; 118 xtax_num(line_num)=tax_num; 119 120 if last.clm_id then output; 121 run; ERROR: Array subscript out of range at line 112 column 2. line_1st_expns_dt_1=04/15/2021 line_1st_expns_dt_2=04/15/2021 line_1st_expns_dt_3=04/15/2021 line_1st_expns_dt_4=04/15/2021 line_1st_expns_dt_5=04/15/2021 line_1st_expns_dt_6=04/15/2021 line_1st_expns_dt_7=04/15/2021 line_1st_expns_dt_8=04/15/2021 line_1st_expns_dt_9=04/15/2021 line_1st_expns_dt_10=04/15/2021 line_1st_expns_dt_11=04/15/2021 line_1st_expns_dt_12=04/15/2021 line_1st_expns_dt_13=04/15/2021 line_last_expns_dt_1=04/15/2021 line_last_expns_dt_2=04/15/2021 line_last_expns_dt_3=04/15/2021 line_last_expns_dt_4=04/15/2021 line_last_expns_dt_5=04/15/2021 line_last_expns_dt_6=04/15/2021 line_last_expns_dt_7=04/15/2021 line_last_expns_dt_8=04/15/2021 line_last_expns_dt_9=04/15/2021 line_last_expns_dt_10=04/15/2021 line_last_expns_dt_11=04/15/2021 line_last_expns_dt_12=04/15/2021 line_last_expns_dt_13=04/15/2021 line_icd_dgns_cd1=E782 line_icd_dgns_cd2=E782 line_icd_dgns_cd3=E782 line_icd_dgns_cd4=E782 line_icd_dgns_cd5=E782 line_icd_dgns_cd6=E782 line_icd_dgns_cd7=E782 line_icd_dgns_cd8=E782 line_icd_dgns_cd9=E782 line_icd_dgns_cd10=E782 line_icd_dgns_cd11=E782 line_icd_dgns_cd12=E782 line_icd_dgns_cd13=E782 hcpcs_cd1=81161 hcpcs_cd2=81238 hcpcs_cd3=81411 hcpcs_cd4=81413 hcpcs_cd5=81414 hcpcs_cd6=81401 hcpcs_cd7=81404 hcpcs_cd8=81404 hcpcs_cd9=81404 hcpcs_cd10=81404 hcpcs_cd11=81404 hcpcs_cd12=81405 hcpcs_cd13=81405 line_nch_pmt_amt1=279.00 line_nch_pmt_amt2=600.00 line_nch_pmt_amt3=1350.19 line_nch_pmt_amt4=584.90 line_nch_pmt_amt5=584.90 line_nch_pmt_amt6=137.00 line_nch_pmt_amt7=274.83 line_nch_pmt_amt8=274.83 line_nch_pmt_amt9=274.83 line_nch_pmt_amt10=274.83 line_nch_pmt_amt11=274.83 line_nch_pmt_amt12=301.35 line_nch_pmt_amt13=301.35 prf_physn_npi1=1386023620 prf_physn_npi2=1386023620 prf_physn_npi3=1386023620 prf_physn_npi4=1386023620 prf_physn_npi5=1386023620 prf_physn_npi6=1386023620 prf_physn_npi7=1386023620 prf_physn_npi8=1386023620 prf_physn_npi9=1386023620 prf_physn_npi10=1386023620 prf_physn_npi11=1386023620 prf_physn_npi12=1386023620 prf_physn_npi13=1386023620 tax_num1=472935323 tax_num2=472935323 tax_num3=472935323 tax_num4=472935323 tax_num5=472935323 tax_num6=472935323 tax_num7=472935323 tax_num8=472935323 tax_num9=472935323 tax_num10=472935323 tax_num11=472935323 tax_num12=472935323 tax_num13=472935323 BENE_ID=eeeeee119111E11 CLM_ID=eeeeJ9jJE9reaEa LINE_NUM=14 CLM_THRU_DT=15APR2021 PRF_PHYSN_NPI=1386023620 TAX_NUM=472935323 LINE_1ST_EXPNS_DT=15APR2021 LINE_LAST_EXPNS_DT=15APR2021 HCPCS_CD=81406 LINE_NCH_PMT_AMT=282.88 LINE_ICD_DGNS_CD=E782 Year=2021 Case=Lines FIRST.BENE_ID=0 LAST.BENE_ID=0 FIRST.CLM_ID=0 LAST.CLM_ID=0 FIRST.LINE_NUM=1 LAST.LINE_NUM=1 i=. _ERROR_=1 _N_=5808 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 5809 observations read from the data set WORK.BCARLINE2016_2021. WARNING: The data set WORK.BCARLINE2016_2021_WIDE may be incomplete. When this step was stopped there were 3237 observations and 96 variables. WARNING: Data set WORK.BCARLINE2016_2021_WIDE was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 122 123 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 135    ... View more