intermittent truncated values

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

intermittent truncated values

I was wondering if anyone knows of an issue where a value will be truncated intermittently. If not can anyone tell me what I am doing wrong.

Here is my code to create the table. the sample file I pull the data from is attached

data AccgOUTmsgs;

      infile "C:\data\logs\20130726\SOMEONE_TEST.out" dlm='01'x MISSOVER;

      input

   timeout 10.

   ns_out 9.

   @'35=' outmsgtype :$1.

   @'56=' targetcompid :$30.

   @'11=' clordid :$50.

   @'39=' orderstatus :$1.

   @'55=' symbol :$7.;

  DATETIMEOUT = dhms('01jan1970'd,0,0, timeout);

  FORMAT DATETIMEOUT DATETIME.;

   complete_timeout = cat(of timeout ns_out);

RUN;

OUTPUT shows some of my symbols are being truncated. they should all be USD/JPY but some show as USD/JP. Other examples are U and US. I dont know what is causing this to happen.

timeout,ns_out,outmsgtype,targetcompid,clordid,orderstatus,symbol,DATETIMEOUT,complete_timeout

1374801420,699420767,8,SOMEONE-CCG-1,(4 2780 2),A,USD/JPY,26JUL13:01:17:00,1374801420699420767

1374801420,699518420,8,SOMEONE-CCG-1,(4 2780 2),0,USD/JPY,26JUL13:01:17:00,1374801420699518420

1374801420,900818804,8,SOMEONE-CCG-1,(4 2780 2)C,6,USD/JP,26JUL13:01:17:00,1374801420900818804

1374801420,926842284,8,SOMEONE-CCG-1,(4 2780 2),2,,26JUL13:01:17:00,1374801420926842284

1374801420,927011224,9,SOMEONE-CCG-1,(4 2780 2)C,2,,26JUL13:01:17:00,1374801420927011224

1374801425,934460890,0,SOMEONE-CCG-1,,,,26JUL13:01:17:05,1374801425934460890

1374801420,900818804,8,SOMEONE-CCG-1,(4 2780 2)C,6,USD/JP,26JUL13:01:17:00,1374801420900818804

1374801420,900818804,8,SOMEONE-CCG-1,(4 2780 2)C,6,USD/JP,26JUL13:01:17:00,1374801420900818804

1374801420,900818804,8,SOMEONE-CCG-1,(4 2780 2)C,6,USD/JP,26JUL13:01:17:00,1374801420900818804

1374801420,900818804,8,SOMEONE-CCG-1,(4 2780 2)C,6,USD/JP,26JUL13:01:17:00,1374801420900818804

1374801420,900818804,8,SOMEONE-CCG-1,(4 2780 2)C,6,USD/JP,26JUL13:01:17:00,1374801420900818804

Attached Data File is FIX string with '01' delimiter

thanks

Attachment

Accepted Solutions
Solution
‎07-30-2013 04:44 PM
Super User
Posts: 10,500

Re: intermittent truncated values

Default line length that will be read is 256, try adding LRECL=500 (for your example data) to the INFILE statement to read longer lines.

On several of your records the Y in JPY falls in column 257 so that is why you're getting that particular truncation.

View solution in original post


All Replies
Solution
‎07-30-2013 04:44 PM
Super User
Posts: 10,500

Re: intermittent truncated values

Default line length that will be read is 256, try adding LRECL=500 (for your example data) to the INFILE statement to read longer lines.

On several of your records the Y in JPY falls in column 257 so that is why you're getting that particular truncation.

New Contributor
Posts: 4

Re: intermittent truncated values

That did it. thanks for helping with my rookie mistake.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 200 views
  • 4 likes
  • 2 in conversation