topic Re: filename statement import data in SAS Data Management

filename statement import data

arv — Tue, 25 Sep 2018 15:03:11 GMT

I get 3 flat file witout header. Using coded as follows-
MAVHIC01 has data-------

1 john calgary
2 Arvi vancouver

DaTA.BKUP_00 has data---

1 fisher Reddeer
2 Ahmadi vancouver

DaTA.BKUP_01 has data---

1 mario Ottwa
2 Julia winnipeg

FILENAME SORTA1 ('/shared/uniki//Mq.FLAT.MAVHIC01'
                 '/shared/uniki/Mq.CMA.DaTA.BKUP_00'
                 '/shared/uniki/Mq.CMA.DaTA.BKUP_01'
                                 );

I have one .sas file which has input variables and code is as follows-

**    Pos  Field Name   Length;
INPUT @1   id                 2.    /* id          */
            @1   name    $     6.    /* employee name         */
            @1   city       $     20.    /* working city           */

Now I wonder what will be in SORTA1 and how the data will be stored in id,name,city inputs.

Re: filename statement import data

Kurt_Bremser — Tue, 25 Sep 2018 15:15:40 GMT

Maxim 4: Try it.

Run your code, inspect the resulting dataset, and study the log.

Re: filename statement import data

ballardw — Tue, 25 Sep 2018 15:46:36 GMT

Without knowing whether the file referenced was using in an INFILE or FILE statement it is pretty hard to tell what may be going one.

If that is used for INFILE with that exact input statement I suspect you will likely not like the contents of Name or City.

Re: filename statement import data

arv — Tue, 25 Sep 2018 16:05:08 GMT

Thanks for reply.

Yes, it is using INFILE as follows-

data SORTA;
INFILE SORTA1 lrecl=150 RECFM=F;
%INCLUDE '/sas//me/refr/phis.sas';

The phis.sas file has input variables.
** Pos Field Name Length;
INPUT @1 id 2. /* id */
@1 name $ 6. /* employee name */
@1 city $ 20. /* working city */

Re: filename statement import data

mkeintz — Fri, 28 Sep 2018 03:17:39 GMT

And, per @Kurt_Bremser's suggestion, did you try it? What results did you get?