Does zipcitydistance(zip1, zip2)    calculate only 5 digit zip code ? I need to calculate the distance between two 9 digit zipcodes.   when I ran the 9 digits zipcode to calculate the distance, the log shows error " NOTE: Invalid argument to function ZIPCITYDISTANCE('006460000','010133140') at line 28 column 13." data _null_; distance=zipcitydistance('006460000', '010133140'); put   ' distance 8. ' miles'; run;   Can someone share how to calculate the distance between 9 digit zip codes?   Thanks   ... View more

if  any value  contains "no"  then execute program_1.sas, else execute program_2.sas. the errors " error 180-322:statement is not valid or its is used out or proper order" and error " else  statement  is not valid or it is used out of proper order. the sample is attached. Can someone help? data _null_; length comp_lst $20; do until (eof); set a (keep=verified ) end=eof; comp_lst=catx(" ",comp_lst,verified); end; drop verified; if index(comp_lst,"no")>0 then %include "\program_1.sas"; else if index(comp_lst, "no")<1 then %include "\program_2.sas"; run;   Thanks !   ... View more

I want to save dataset names into array, then sort the dataset. I need sort over hundred datasets. so I use the do loop. the macro code doesn't work. can someone help  check ? Thanks you !!!     data mbr_cnty_freq; input mbr_county:$3.   var_freq var_name:$30.   ; datalines;   001 928 mbr_county 002 790 mbr_county 003 1500 mbr_county 004 2000 mbr_county 005 29 mbr_county 0065 mbr_county ; run; data mbr_cty_freq;     infile datalines dsd; input mbr_cty:$15.   var_freq var_name $20.   ; datalines;   Abilene,259,mbr_cty Sanford,78,mbr_cty Chapel Hill,100,mbr_cty Akron,420,mbr_cty Durham,70,mbr_cty Alkol,5,mbr_cty ; run;   　 data mbr_ELG_freq; infile datalines dsd;   input mbr_elg_cd: $10.   var_freq var_name:$30.   ; datalines ;   ACN,1420,mbr_elg MAN,60,mbr_elg SAA,38,mbr_elg CBD,70,mbr_elg AAC,5,mbr_elg ;;;; run;       %macro sorter; array varChk{*} $30 mbr_cnty_freq mbr_cty_freq mbr_ELG_freq; %do i=1 %to dim(varChk) by 1;   proc sort data=varChk(i); by var_freq; run; %end; %mend sorter;     Thanks !!! ... View more

the following drug data ; the goal  is to count days  overlap of at least two drugs taken and list drug names per patient id(PID). i am looking forward the output data should look like the following.   PID drug_name drug_cnt overlapping_flag start_date end_date count_days A ARIPIPRAZOLE 1 0 1/1/15 2/1/15 31 A ARIPIPRAZOLE_DESIPRAMINE 2 1 2/1/15 2/20/15 19 A ARIPIPRAZOLE_DESIPRAMINE_QUETIAPINE 3 1 2/20/15 3/1/15 9 A DESIPRAMINE_QUETIAPINE 2 1 2/20/15 4/1/15 40 A QUETIAPINE 1 0 4/10/15 5/1/15 21       the data  source as the below: PID drug med_taken_begin_dt med_taken_finish_dt MD_taken_by_days 1 HALOPERIDOL DECANOATE 11Dec2013 15Dec2017 1465 1 LITHIUM CARBONATE 23Jan2014 07Feb2018 1476 1 CLOZAPINE 03Mar2014 08Feb2018 1438 2 SERTRALINE 25Feb2014 30Jun2014 125 2 LITHIUM CARBONATE 27Feb2014 20Jan2017 1058 2 QUETIAPINE 03Mar2014 14Feb2017 1079 2 HALOPERIDOL 03Apr2014 08Sep2016 889 2 TRAZODONE 01May2014 20Jan2017 995 2 BUPROPION HCL 10Jul2014 31Jul2014 21 2 BUPROPION HCL 31Jul2014 09Sep2014 40 2 DULOXETINE 11Sep2014 17Oct2014 36 2 ARIPIPRAZOLE 23Apr2015 25Jun2015 63 2 LITHIUM CARBONATE 26Apr2015 01May2015 5 2 LORAZEPAM 27Apr2015 27Apr2015 0 2 FLUOXETINE 15Oct2015 09Nov2015 25 2 QUETIAPINE 14Apr2016 15Sep2016 154 2 SEROQUEL 13Jun2016 20Jun2016 7 2 OLANZAPINE 08Sep2016 24Mar2017 197 2 RISPERIDONE 01Feb2017 19Mar2017 46 2 CLOZAPINE 01Mar2017 31Mar2017 30 3 DESIPRAMINE 11Nov2013 22Sep2014 315 3 QUETIAPINE 26Nov2013 26Jan2017 1157 3 ARIPIPRAZOLE 10Jan2014 26Jan2017 1112 3 VENLAFAXINE 28Mar2014 26Jan2017 1035     Thanks lots! ... View more