Thanks for replying.
I'm on a good start.
Can you please review my code now and see why I'm getting the syntax errors?
thanks
1 The SAS System 09:51 Thursday, June 6, 2019
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTNAME='';
7 %LET _SASPROGRAMFILE=;
8
9 ODS _ALL_ CLOSE;
10 OPTIONS DEV=ACTIVEX;
11 GOPTIONS XPIXELS=0 YPIXELS=0;
12 FILENAME EGSR TEMP;
13 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
14 STYLE=HtmlBlue
15 STYLESHEET=(URL="file:///C:/Program%20Files%20(x86)/SAS%20EG%209.4.1/x86/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
16 NOGTITLE
17 NOGFOOTNOTE
18 GPATH=&sasworklocation
19 ENCODING=UTF8
20 options(rolap="on")
21 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
22
23 GOPTIONS ACCESSIBLE;
24 Proc sql noprint /*INOBS=100*/;
25
26
27 Create table NED_Members as
28
29 SELECT DISTINCT
30
31 MM.SEQ_MEMB_ID as MemberID
32 , MM.LAST_NAME as MemberLastName
33 , MM.FIRST_NAME as MemberFirstName
34 , MM.DATE_OF_BIRTH as MemberDOB
35 , MM.GENDER as M_F
36 , MM.MEDICAID_NO as MedicaidID
37 , MM.ETHNICITY_CODE
38 , MM.USER_DATE_7
39 , meh.line_of_business as LOB
40 , meh.SEQ_PROV_ID
41 , meh.IPA_ID
42 , MA.ADDRESS_LINE_1 AS ADDRESS1
43 , MA.ADDRESS_LINE_2 AS ADDRESS2
44 , MA.CITY AS CITY
45 , MA.STATE AS STATE
46 , MA.ZIP_CODE AS ZIP
47 , MA.COUNTY AS COUNTY
48 , MA.HOME_PHONE_NUMBER AS HOMEPHONE
49 , MEH.EFFECTIVE_DATE
50 , MEH.TERM_DATE
51 , MEH.PLAN_CODE
52 , PM.PROVIDER_ID
53 ,PM.LAST_NAME AS PROVIDER_LAST_NAME
54 ,PM.FIRST_NAME AS PROVIDER_FIRST_NAME
55 ,PM.PROVIDER_TYPE
2 The SAS System 09:51 Thursday, June 6, 2019
56 ,PM.LICENSE
57 ,PA.COUNTY AS PROV_COUNTY
58 ,PA.ADDR_CATEGORY_CODE
59 ,MI.IDNUMBER AS SUBSCRIBER_ID
60 ,MP.ATTRRECNO AS ATTRRECNO
61 ,MP.ATTRRRECNO AS ATTRRECNO1
62 ,MP.RECSTAT AS RECSTAT
63 ,MP.MEMRECNO AS MEMRECNO
64 ,MP.PHNUMBER LABEL = "NEHII_HOME_PHONE" AS NEHII_HOME_PHONE
65 ,MP.PHNUMBER LABEL = "NEHII_MOBILE_PHNUMBER" AS NEHII_MOBILE_PHNUMBER
66 ,MA.STLINE1 AS NEHII_STREET_ADDRESS1
67 ,MA.CITY AS NEHII_CITY
68 ,MA.STATE AS NEHII_STATE
69 ,MA.COUNTY AS NEHII_COUNTY
70 ,MA.ZIPCODE AS NEHII_ZIPCODE
71
72
73 FROM
74 HSDREPT.MEMBER_ADDRESS as MA
75 inner join HSDREPT.MEMBER_MASTER as MM
76 on MM.SEQ_MEMB_ID = MA.SEQ_MEMB_ID
77 inner join HSDREPT.member_elig_history as meh
78 on MM.SEQ_MEMB_ID = MEH.SEQ_MEMB_ID
79 inner join HSDREPT.PROV_MASTER as PM
80 on PM.SEQ_PROV_ID = MEH.SEQ_PROV_ID
81 inner join HSDREPT.PROV_ADDRESS as PA
82 on PM.SEQ_PROV_ID = PA.SEQ_PROV_ID
83 inner join MDM.MPI_MEMPHONEWC as MP
84 on MA.MEMRECNO = MP.MEMRECNO
85 inner join MDM.MPI_MEMADDRWC as MA
86 on MA.MEMRECNO = MP.MEMRECNO
87 inner join MDM.MPI_MEMIDENTWC as MI
88 on MA.MEMRECNO = MI.MEMRECNO
89 LEFT JOIN MDM.MPI_MEMIDENTWC as MI
90 on HSDREPT.MEMBER_MASTER.MEDICAID_NO = MDM.MPI_MEMIDENTWC.IDNUMBER
_
22
76
ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND,
ANSIMISS, BETWEEN, CONTAINS, CROSS, EQ, EQT, EXCEPT, FULL, GE, GET, GROUP, GT, GTT, HAVING, IN, INNER, INTERSECT, IS,
JOIN, LE, LEFT, LET, LIKE, LT, LTT, NATURAL, NE, NET, NOMISS, NOT, NOTIN, OR, ORDER, OUTER, RIGHT, UNION, WHERE, ^,
^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
91
92 WHERE
93 MEH.LINE_OF_BUSINESS = 'NED'
94 AND MEH.TERM_DATE IS NULL
95 AND MA.ADDRESS_TYPE = 'R5'
96 AND MP.ATTRRECNO = 389
97 AND MP.ATTRRECNO1 = 391
98 MA.MEMRECNO = MI.MEMRECNO = MP.MEMRECNO
99 AND MA.ATTRRECNO = 390
100 AND MA.TERM_DATE IS NULL;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
101
102 quit;
3 The SAS System 09:51 Thursday, June 6, 2019
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.06 seconds
cpu time 0.01 seconds
103 run;
104
105 proc sort data = NED_Members NODUPKEY;
ERROR: File WORK.NED_MEMBERS.DATA does not exist.
106 by MemberID;
107
108 GOPTIONS NOACCESSIBLE;
109 %LET _CLIENTTASKLABEL=;
110 %LET _CLIENTPROCESSFLOWNAME=;
111 %LET _CLIENTPROJECTPATH=;
112 %LET _CLIENTPROJECTNAME=;
113 %LET _SASPROGRAMFILE=;
114
115 ;*';*";*/;quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
115 ! run;
116 ODS _ALL_ CLOSE;
117
118
119 QUIT; RUN;
120
