the  last file i sent  was a  copy and  paste  from my original csv  to a  text editor  and maybe  that s why it got  changed again   but   you were right  i was missing  the  lrecl=32767   Works  fine now Million thanks Tom Enjoy the weekend ... View more

  i think  this code  :   data _null_ infile '/path/temp.txt"  end=eof;  input ; if _n_>1 then do; if countw(_infile_,'|','mq') > 3 then put / @; else put ' ' @; end; put _infile_ @; if eof then put; run;   truncuates the "notes" field at some point but  dont  undrstand  why. I have attached  a few  records and  the  1st  record  is  trunctated at the "150%" and  along  with it  the 21th field is assigned a  missing value whereas the  second record  is appended  properly. Also the  3rd record  which is longer than the 1st is read in properly ... View more

this  really  works like  a  charm Tom,wow. Thanks a  lot!   One last thing i'd ask  is  why do you think for a  few  out of 1000 records  the ;last  field  gets  cut off  like  i ve shown in the  pic? i checked  those  2 particular reocrds  in the  text  file and  they  have the  full dates there. ... View more

so it is  pipe delimited but  there is no way i can  find  that splitter in the  20th field (Notes). Any tricks about it? 🙂     ... View more

And how do i find those characters? ... View more

Thx Cant i open the file in text editor and remove the cr or crlf though? ... View more

Ahh i see what you asking me. Yes, it was opened in excel n then saved as a csv file and given to me like it. I see now the 23 commas. If they want the comment i guess i can assign each line of it to the first variable so a comment of 3 lines would go to 3 separate records but what worries me are some records that have more than 1 column. Original csv file has only one column and the entire record embeded in it right? But i see records where some of the value of "notes" is going to another column along with the 21th field so when SAS reads in the file assignes the value of that second column to a new line( into var1 n var2) U think termstr=crlf would take care of that issue? Thx for your insights Tom ... View more

yes  lines   3-8  are a comment and  that comment is not  a part  of any record . They  have a  bunch of different comments  throughout this  file and  now they say  they want  it  imported too???   the comments  are not even  pipe delimited... ... View more

it was a  csv  file they  gave me and  i am  reading it in as such but they only gave me the names of the fields,nothing more  so  we came  up with the specifications  here 🙂   input APPLICATIONDATE :$10. APPLICATIONNUM :$10. CERTNUM :$10. PLANTYPE :$2. CREATEDBY :$30. POLICY_STATUS :$15. POLICY_DETAILED_STATUS :$15. POLICY_EVENT :$15. AGENT_ID :$30. ENROLMENT :$15. STIMULUS :$30. OWNER :$3. PRIMARYFACE :$10. PREMIUM :$10. POSTAL_CODE :$7. CUSTOMERCID :$15. INSURED2CID :$15. DOB :$10. GENDER :$2. NOTES :$500. DATE_STAMP :$10.; run; ;   and  here i am attaching a  record  of this  csv  file where the  20th field goes into  3  rows and SAS  reads the data in the second  row as a new field(1st field) and  the  data in the  3rd row as 2nd field of a  new  record... and  the  20th field is pipe delimited  just like the others  right? So no clue  why SAS is treating the value of this 20th field  like new  fields ... View more

thanks , when  you say "all the  other  records  have no pipe"  are you referring to the comments  after the  second  record? And they want the comments imported too which does not make any sense. Yes  there are  21  fields  but  how do you  see the  23 commas 🙂  just curious   this is  one  of the comments  in the  huge  original file  which is  right  between the  2nd and  3rd  record but also  i noticed  the  value of the  20th  field which is a  string has some  wierd  data . The 23 commas  u showing  in  your  respond  are actually part  of the  20th field .................................................       ? R4 policy created for T10 R3 pending application     ? Please refer to closed R3 policy for application answers - ABC11014263 ? Any certificate reprint requests are to be sent to the Product Group for review             ? Do not request any certificate reprints through Centtric |2017-04-10 ... View more

restarted my  pc and  now i can  import the  file  successfully,ughhh sorry guys ... View more

I  can  import the same  file  from EG SAS(UNIX) but not  from PC SAS. We all use  Windows SAS and a  few of my  co-workers i spoke with can  easily open and  import this  file  from  pc sas. I can view it, i  have access to the  folder  where this file is placed and yet cannot  import it (0 records) . I even created  temp csv  files on my desktop   and same  problem,all seem  good  but  0 records  imported.   atttached  are a  few  records of that file   Thx ... View more