I am trying to pull records that are equal to 'Unknown' and DRG =469. What is wrong with my where statement?     select count(desy_sort_key) from etl.inp_claims_lds2013_2016 where Age_Range='Unknown' and clm_drg_cd ='469';   LOG BELOW   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 select count(desy_sort_key) from etl.inp_claims_lds2013_2016 where Age_Range='Unknown' ______ 180 62 ! and clm_drg_cd ='469'; ERROR 180-322: Statement is not valid or it is used out of proper order. 63 64 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 77 ... View more

All - I would like to turn the below data step into 4 files that are appended together.  the 'j' files have the same format and 'k' file has a different format - less and a few different fields.  The record count on my data step seems to be off.   Not sure of the best way to accomplish this task using SAS general programming or SQL;   order the files should be appended etl.inp_claimsj_lds2013 etl.inp_claimsj_lds2014 etl.inp_claimsj_lds2015 etl.inp_claimsk_lds2016   SAS Code data etl.inp_claims_lds2013_2016; set etl.inp_claimsj_lds2013 etl.inp_claimsj_lds2014 etl.inp_claimsj_lds2015 etl.inp_claimsk_lds2016; run; ... View more

All   I want to update all observations in dataset with M or F.  Prefer to use modify statement but sql works too.  Just wan to get the below data step working.  It only updates the first obs     data etl.inp_claims_lds2013_2016; modify etl.inp_claims_lds2013_2016;  if gndr_cd = '1' then gndr_cd ='M'; replace;  if gndr_cd = '2' then gndr_cd = 'F'; replace;  run; ERROR: No matching observation was found in MASTER data set. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1 observations read from the data set ETL.INP_CLAIMS_LDS2013_2016. NOTE: The data set ETL.INP_CLAIMS_LDS2013_2016 has been updated. There were 1 observations rewritten, 0 observations added and 0 observations deleted. ... View more

proc sql select desy_sort_key, clm_admsn_dt, prvdr_num from inp.inp_claims_lds2013_2016 group by desy_sort_key prvdr_num clm_admsn_dt; quit;   LOG BELOW   100 proc sql 101 select desy_sort_key, clm_admsn_dt, prvdr_num from inp.inp_claims_lds2013_2016 ______ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, CHECK, CODEGEN, CONSTDATETIME, DICTDIAG, DOUBLE, DQUOTE, ERRORSTOP, EXEC, EXITCODE, FEEDBACK, FLOW, INOBS, IPASSTHRU, LOOPS, NOCHECK, NOCODEGEN, NOCONSTDATETIME, NODICTDIAG, NODOUBLE, NOERRORSTOP, NOEXEC, NOFEEDBACK, NOFLOW, NOIPASSTHRU, NONUMBER, NOPRINT, NOPROMPT, NOREMERGE, NOSORTMSG, NOSTIMER, NOSTOPONTRUNC, NOTHREADS, NOWARNRECURS, NUMBER, OUTOBS, PRINT, PROMPT, REDUCEPUT, REDUCEPUTOBS, REDUCEPUTVALUES, REMERGE, SORTMSG, SORTSEQ, STIMER, STOPONTRUNC, THREADS, UBUFSIZE, UNDO_POLICY, WARNRECURS. ERROR 76-322: Syntax error, statement will be ignored. 102 group by desy_sort_key prvdr_num clm_admsn_dt; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 103 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   ... View more

proc sql ; select * from inp.inp_claims_lds2013_2016 group by prvdr_num quit;   LOG BELOW   99 100 proc sql ; 101 select * from inp.inp_claims_lds2013_2016 102 group by prvdr_num 103 quit; ____ 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?, AND, CONTAINS, EQ, EQT, GE, GET, GT, GTT, HAVING, LE, LET, LIKE, LT, LTT, NE, NET, OR, ORDER, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored. ... View more

data inp.inp_claims_lds2013_2016; set inp.inp_claimsj_lds2013 inp.inp_claimsj_lds2014 inp.inp_claimsj_lds2015 inp.inp_claimsk_lds2016; if prvdr_num < '0879'; run;   prvdr_num is a character variable.  I need values 0001-0879 and 1300-1399.  I only used 0879 above.  needless to say the IF condition did not work properly ... View more

PROC SQL ; CREATE TABLE WORK.query AS SELECT DISTINCT (CLM_DRG_CD) FROM INP.INP_CLAIMSK_LDS2016 WHERE CLM_DRG_CD='469' OR CLM_DRG_CD='470' COUNT(CLM_DRG_CD) AS COUNT GROUP BY CLM_DRG_CD; CONTENTS DATA=WORK.query OUT=WORK.details; RUN;       1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 PROC SQL ; 63 CREATE TABLE WORK.query AS SELECT DISTINCT (CLM_DRG_CD) FROM 64 INP.INP_CLAIMSK_LDS2016 WHERE CLM_DRG_CD='469' OR CLM_DRG_CD='470' 65 COUNT(CLM_DRG_CD) AS COUNT GROUP BY CLM_DRG_CD; _____ 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET, GROUP, GT, GTT, HAVING, LE, LET, LT, LTT, NE, NET, OR, ORDER, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 66 CONTENTS DATA=WORK.query OUT=WORK.details; ________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 67 RUN; NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. 68 69 70 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 83 ... View more