Importing a pipe delimited file. The pipes are in the output

Steelers_In_DC — Thu, 23 Jun 2016 19:40:27 GMT

I am manipulating code I get from using the Enterprise Import feature. The original code is this:

    INFILE '/sas/saswork/SAS_work39CA0000252B_scsmt300a/#LN00017'
        LRECL=467
        ENCODING="LATIN1"
        TERMSTR=CRLF
        DLM='7F'x
        MISSOVER
        DSD ;
    INPUT
        sys              : $CHAR6.
        LOAN_NUMBER      : ?? BEST20.
        LOAN_CLOSING_DATE : ?? YYMMDD8.
        FIRST_PAYMENT_DATE : ?? YYMMDD8.

I changed the code to allow for the maximum lengths that the Federal Reserve may provide, I also changed the date to character format. Here is what I have:

INFILE "/sas/user_data/general/sandbox/pp78499/&filename"
       firstobs=2
        LRECL=542
/*        ENCODING="LATIN1"*/
/*        TERMSTR=crlf*/
        DLM='|'
        MISSOVER
        DSD ;
    INPUT

        sys              $CHAR6.
        LOAN_NUMBER      $char33.
        LOAN_CLOSING_DATE $char10.
        FIRST_PAYMENT_DATE $char10.

an example of the output is below:

ACLShe   |0000000000000000|20040716|200408   15|PA|1908   2|15000|15
ACLShe   |0000000000000000|19990604|199907   10|PA|1932   0|176663|1
ACLShe   |0000000000000000|20010213|200104   05|PA|1913   6|40000|40
ACLShe   |0000000000000000|20010215|200103   20|PA|1903   8|104000|1

The pipes are coming into the output, not deliminating the data. Any help will be appreciated.

Thank You,

Mark

Re: Importing a pipe delimited file. The pipes are in the output

data_null__ — Thu, 23 Jun 2016 19:43:52 GMT

You need format modifier : colon in the input statement as in the example.

Re: Importing a pipe delimited file. The pipes are in the output

Steelers_In_DC — Thu, 23 Jun 2016 19:44:54 GMT

Ah, if it was a snake it would have bit me. Thanks!

topic Re: Importing a pipe delimited file. The pipes are in the output in SAS Programming

Importing a pipe delimited file. The pipes are in the output

Re: Importing a pipe delimited file. The pipes are in the output

Re: Importing a pipe delimited file. The pipes are in the output