Good Afternoon All, I am running the below Macro code and getting some errors.   data _null_; set hospcnt; call symput('maxcnt',maxnum); run; %put &maxcnt; /* loop to go through all hospitals */ %macro hosrep(); %do j= 1 %to &maxcnt; data _null_; set hospcnt; if cnt=&j; call symput('i',trim(left(prvorg))); run; data report1; set &save..procrpt; if prvorg="&i"; run; %end; %mend hosrep;   Error: MPRINT(HOSP_LOOP):   data _null_; MPRINT(HOSP_LOOP):   set hospcnt; MPRINT(HOSP_LOOP):   call symput('maxcnt',maxnum); MPRINT(HOSP_LOOP):   run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).       3:179   NOTE: There were 91 observations read from the data set WORK.HOSPCNT. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       user cpu time       0.00 seconds       system cpu time     0.00 seconds       memory              189.17k       OS Memory           26480.00k       Timestamp           09/24/2015 12:37:28 PM       SYMBOLGEN:  Macro variable MAXCNT resolves to           91 91 SYMBOLGEN:  Macro variable MAXCNT resolves to           91 SYMBOLGEN:  Macro variable MAXCNT resolves to           91 NOTE: Line generated by the invoked macro "HOSREP". 1       data _null_;     set hospcnt;     if cnt=&j;     call symput('i',trim(left(prvorg)));    run;      data report1;                                                  -                                                  22 1    !      set &save..procrpt;     if prvorg="&i";        run;     data report2;     set &save..percents;     if 1    ! prvorg="&i"; MPRINT(HOSREP):   data _null_; MPRINT(HOSREP):   set hospcnt; WARNING: Apparent symbolic reference J not resolved. MPRINT(HOSREP):   if cnt=&j; MPRINT(HOSREP):   call symput('i',trim(left(prvorg))); MPRINT(HOSREP):   run; ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant,               a datetime constant, a missing value, bitstring, INPUT, PUT.  NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time):       real time           0.13 seconds       user cpu time       0.00 seconds       system cpu time     0.00 seconds       memory              125.64k       OS Memory           26480.00k       Timestamp           09/24/2015 12:37:28 PM       MPRINT(HOSREP):   data report1; SYMBOLGEN:  Macro variable SAVE resolves to work MPRINT(HOSREP):   set work.procrpt; WARNING: Apparent symbolic reference I not resolved. MPRINT(HOSREP):   if prvorg="&i"; MPRINT(HOSREP):   run; ... View more

Hi All, For each member number we need to look at the discharge date should be less than 30 days of the next admit date, if so Y else N on the Readmission variable. Please let me know how to apply date logic for this. Member_Number      Claim_ID         Admit_Date     Discharge_Date Readmission 420000000694600   0102241579644   2/15/2015       2/19/2015 420000000694600   0102121583902   2/2/2015         2/6/2015 420000000694600   0101161597102   1/6/2015          1/8/2015 420000009817200   0106101514987   5/26/2015       5/28/2015 420000009817200   0105051585970   4/18/2015       4/24/2015 420000009817200   0104151510931   4/1/2015           4/3/2015 420000009817200   0103241584788   3/10/2015       3/14/2015 Thanks for your help. ... View more

Hi All, We have clamno and other fields in the report. If we are running a program today, it has to get only previous adjudicated date not other date. For example, if a program runs Monday it has to get the Friday’s data and for Tuesday it has to get Monday’s data vice versa...Do you have any macro code to get only previous day (date format mm/dd/yyyy). clamno Adjdate 12345 03/08/2013 56789 03/08/2013 90876 03/29/2013 Output needs to be: clamno Adjdate 12345 03/08/2013 56789 03/08/2013 Can you please provide me the sample macro code to get only previous day? Thanks in Advance ... View more

Hi I have the below data, cl_No lineno Servive_code 1       01      120 2       01      D373 2       02      373 2       03      D440 3       01      270 3       02      D20 3       03      D4567 3       04      D567 3       05      F679 The service_code should include a 3 digit service_code and a 4 digit service_code. The four digit servie_code should begin with the letter "D" and is the last of the cl_no. The output should be like this: cl_No lineno Servive_code 1       01      120 2       02      373 2       03      D440 3       01      270 3       02      D20 3       04      D567 Thanks in advance ... View more

Hi , I have a folder that has multiple text files as below. \\hfn5\SASPROD\H10521R1.TXT \\hfn5\SASPROD\H10522R1.TXT \\hfn5\SASPROD\H10523R1.TXT \\hfn5\SASPROD\H10524R1.TXT \\hfn5\SASPROD\H10525R1.TXT \\hfn5\SASPROD\H10526R1.TXT I need to read all text files data from the above folder by using macro code instead of infile statement because the files will get updated frequently and create a sas dataset for further analysis. Please help me how to create a macro to read all txt files data in the sas dataset ? Thanks for your help. ... View more

Hi all, Membno             GRPNUM                 EFFDAT                 EXPDAT                     GAP          GAP Month Reqd 123                             PI                      20120601                 99999999           0                         N/A ABC                        LI                          20120201                20120201                  0                   N/A ABC                        H1NAS                  20120201                20120331 ABC                        PAMAS                 20120401                99999999 DEF                        LI                          20120101                 20120229               2                        DEF                        H1NAS                  20120401                20120430                                          20120301 DEF                        PAMAS                 20120601                99999999                                          20120501 GHI                        LI                          20120201                20120229               1                          GHI                        H1NAS                  20120301                20120331 GHI                        PAMAS                 20120401                20120430 GHI                        PAMAS                 20120601                20120630                                          20120501 JKL                          LI                        20120401                20120430               0 JKL                          H1NAS                20120501                20120531 JKL                          PAMAS               20120601                9999999 MNO                     LI                          20120101                20120331                0 MNO                     H1NAS                  20120401                20120430                                SO the member ABC is not enrolled for the month of Jan and we don’t want this Memb to be included SO the member DEF we need him for he has a GAP in enrollment for the month of March and May. So total GAP = 2 For the Member GHI, we need him as he has a GAP in enrollment for the month of May, so GAP = 1 For the Member JKL, we don’t need him as he has NO GAP even though he is not enrolled for Jan thru March For the Member MNO, we don’t need him as his enrollment ended in April and he is no longer enrolled We need ONLY those Members who have a GAP in their enrollment period Please help me with the above logic. Thanks in Advance ... View more

Hi All, Please help me out to get the below logic, Membno             GRPNUM                 EFFDAT                 EXPDAT                  GAP ABC                        LI                          20120201                20120201                  0 ABC                        H1NAS                  20120201                20120331 ABC                        PAMAS                 20120401                99999999 SO the member ABC is not enrolled for the month of Jan and we don’t want this Memb to be included DEF                        LI                          20120101                20120229                2 DEF                        H1NAS                  20120401                20120430 DEF                        PAMAS                 20120601                99999999 SO the member DEF we need him for he has a GAP in enrollment for the month of March and May. So total GAP = 2 GHI                        LI                          20120201                20120229               1 GHI                        H1NAS                  20120301                20120331 GHI                        PAMAS                 20120401                20120430 GHI                        PAMAS                 20120601                20120630 For the Member GHI, we need him as he has a GAP in enrollment for the month of May, so GAP = 1 JKL                          LI                          20120401                20120430               0 JKL                          H1NAS                  20120501                20120531 JKL                          PAMAS                 20120601                99999999 For the Member JKL, we don’t need him as he has NO GAP even though he is not enrolled for Jan thru March MNO                     LI                           20120101                20120331                  0 MNO                     H1NAS                  20120401                 20120430 For the Member MNO, we don’t need him as his enrollment ended in April and he is no longer enrolled               We need ONLY those Members who have a GAP in their enrollment period Thanks in Advance ... View more

Hi, In my final output I need to get that if any member is not enrolled for any month from Jan thru June 2012. For e.g.: I have to create a report till June 30th 2012 for those members who have a gap in enrollment           ABC 20110201 20120229    This means that the member is enrolled from Jan thru Feb 2012           ABC 20120401 20120430    This means that the member is enrolled for April 2012           ABC 20120701 20121231                                                      In this case ABC has a gap for March, May and June 2012           DEF 20120401 20120530           DEF 20120101 20120229           DEF 20120301 20120331                                           In this case DEF is enrolled for the months from Jan thru May 2012 and is missing June 2012           GHI 20110401 20120430           GHI 20120101 20120229           GHI 20120301 20120331              GHI 20120501 20120930                                          In this case GHI is enrolled for ALL the months from Jan thru Sep 2012 and is not needed in the final output Please let me know how to get a missing months on the final output. Thanks. ... View more