title: SAS Invalid data for a variable
body: <p>I keep getting this error code over and over, with different line numbers of course.</p>
  
  <pre><code>NOTE: Invalid data for VAR4 in line 264808 30-30.
  RULE:----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+
  264808    F113Q1008712|201506|43003.27|R|28|332|N||||3.375|0|201412|||| 61
  VAR1=F113Q1008712 VAR2=201506 VAR3=43003.27 VAR4=. VAR5=28 VAR6=332 VAR7=N VAR8=  VAR9=
  VAR10=  VAR11=3.375 VAR12=0 VAR13=2 VAR14=  VAR15=  VAR16=  VAR17=  _ERROR_=1 _N_=264808
  </code></pre>
  
  <p>After enough time I this happening I get this error code:</p>
  
  <pre><code>WARNING: Limit set by ERRORS= option reached Further errors of this type will not be printed.
  </code></pre>
  
  <p>I'm assuming it is a problem with the delimiter (pipe '|' in my case). I found another <a href="https://stackoverflow.com/questions/20332801/sas-invalid-data">question</a>  that said:</p>
  
  <p>"If it's actually tab delimited, you may need to use <code>dlm='09'x</code> instead." I guess my problem is my lack of understanding of coding. (I'm just using SAS to supplement my thesis, so a lot of this is learning as I'm going.) Where would I put <code>dlm='09'x</code> at and would it even help me in my case.</p>
  
  <p>I also found a comment on <a href="https://stackoverflow.com/questions/18829508/sas-9-3-invalid-data-for-variable">another question</a> that said:</p>
  
  <p>"The $ makes it a character variable, not a numeric variable. That will almost certainly override any informat errors (since character variables are very flexible) but won't give you necessarily the right results.:)"</p>
  
  <p>After reading those answers I believe I need to somehow tell SAS to accept the numerical value that can appear in Var4 and also the variable value of 'R'. Is there a way to make SAS accept either. Or am I just going to have to change all of my 'R' to a numerical value?</p>
  
  <p>If it helps I'm inputting into SAS using this code:</p>
  
  <pre><code>proc import datafile="E:\2013\historical_data1_time_Q12013.txt"
       out=TYr2013Q1
       dbms=dlm
       replace;
       delimiter='|';
       getnames=no;
  run;
  </code></pre>
  
  <p>Thanks for any help. It's much appreciated.</p>