Hi, I am trying to follow the instructions in the SAS beginner programming course on the TSA Claims Data. I am filtering through the data as they proposed, but whenever I try to condition on the dates being missing or '.' to make them be 'needs review', it replaces all of the 220k rows with it, instead of just the missing ones:   This is what they have:     This is what I have: data work.tsa_report; set work.tsa_nodupkey; retain Date_Issues; /* 3. Clean the Claim_Site column. */ if Claim_Site in('-' '') then Claim_Site='Unknown'; /* 4. Clean the Disposition column. */ if Disposition in('-' '') then Disposition='Unknown'; else if Disposition in('Closed: Contractor Claim' 'losed: Contractor Claim') then Disposition='Closed:Contractor Claim'; else if Disposition='Closed: Canceled' then Disposition='Closed:Canceled'; /* 5. Clean the Claim_Type column. */ if Claim_Type in('-' '') then Claim_Type='Unknown'; else if Claim_Type in('Passenger Property Loss/Personal Injur' 'Passenger Property Loss/Personal Injury') then Claim_Type='Passenger Property Loss'; else if Claim_Type='Property Damage/Personal Injury' then Claim_Type='Passenger Damage'; /* 6. Convert all State values to uppercase and all StateName values to proper case. */ StateName=propcase(StateName); State=upcase(State); /* 7. Create a new column to indicate date issues. */ if (Incident_Date > Date_Received or Date_Received = . or Incident_Date = . or year(Incident_Date) < 2002 or year(Incident_Date) > 2017 or year(Date_Received) < 2002 or year(Date_Received) > 2017) then Date_Issues='Needs Review'; /* 8. Add permanent labels and formats. */ format Date_Received Incident_Date date9. Close_Amount dollar20.2; label Claim_Number='Claim Number' Incident_Date='Incident Date' Date_Received='Date Received' Airport_Code='Airport Code' Airport_Name='Airport Name' Claim_Type='Claim Type' Claim_Site='Claim Site' Item_Category='Item Category' Close_Amount='Close Amount' Date_Issues='Date Issues'; /* 9. Drop County and City. */ drop County City; run;   I don't know why it's doing this as I had this problem before. ... View more

Hi, I am looking at the SAS CSV USA-TSA Claim Data and I am getting this error: I am asked to create a column called Date_Issues where I track if there is an incorrect or unexpected formatting of the dates. It says that I should flag the date issues if either of the two date columns, Incident_Date or Date_Received, are outside the date range 2002-2017, or if Incident_Date>Date_Received. However, I am getting this error message when I do the inequality test:   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 data work.tsa_adjust; 70 set work.tsa_claims; 71 format Date_Received Incident_Date date9.; 72 length Claim_Site Claim_Type Disposition $ 100; WARNING: Length of character variable Claim_Site has already been set. Use the LENGTH statement as the very first statement in the DATA STEP to declare the length of a character variable. WARNING: Length of character variable Claim_Type has already been set. Use the LENGTH statement as the very first statement in the DATA STEP to declare the length of a character variable. WARNING: Length of character variable Disposition has already been set. Use the LENGTH statement as the very first statement in the DATA STEP to declare the length of a character variable. 73 if (Claim_Site in('-' '') or Claim_Site=.) then Claim_Site='Unknown'; 74 if (Disposition in('-' '') or Disposition=.) then Disposition='Unknown'; 75 if (Claim_Type in('-' '') or Claim_Type=.) then Claim_Type='Unknown'; 76 if (Incident_Date=.) or (Incident_Date<'01JAN2002'd or Incident_Date>'31DEC2017'd)) _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOT, NOTIN, OR, THEN, ^, ^=, |, ||, ~, ~=. ERROR 200-322: The symbol is not recognized and will be ignored. 77 then Date_Issues='Needs Review'; 78 if (Date_Received=.) or (Date_Received<'01JAN2002'd or Date_Received>'31DEC2017'd)) _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOT, NOTIN, OR, THEN, ^, ^=, |, ||, ~, ~=. ERROR 200-322: The symbol is not recognized and will be ignored. 79 then Date_Issues='Needs Review'; 80 if (Incident_Date>Date_Received) then Date_Issues='Needs Review'; ... View more