BookmarkSubscribeRSS Feed
upadhi
Quartz | Level 8
my infile statement is as:
data work.etls_WGO6ITXY / view = work.etls_WGO6ITXY ;
            infile "&file_name"
                  lrecl = 32760
                  missover
                  firstobs = 1
                  ;;
            attrib N_NUM_TIPO_RECORD length = $1
              format = $1.;
            attrib N_NUM_PROTOCOLLO_DOM length = $9
              format = $9.;
            attrib N_NUM_DISTRETTO_TEL length = $3
              format = $3.;
            attrib N_NUM_NUMERO_TEL length = $8
              format = $8.;
            attrib V_COD_ABI length = $5
              format = $5.;
            attrib C_FLG_TIP_ABI length = $1
              format = $1.;
            attrib V_DES_BANCA length = $30
              format = $30.;
            attrib D_DAT_RIFERIMENTO length = $6
              format = $6.;
            attrib C_FLG_STATO_DELEGA length = $1
              format = $1.;
            attrib ID_MANDATO length = $35
              format = $35.;
            attrib V_COD_RIEMPIMENTO length = $1
              format = $1.;

          

            input @ 1 N_NUM_TIPO_RECORD  $1.
                  @ 2 N_NUM_PROTOCOLLO_DOM  $9.
                  @ 11 N_NUM_DISTRETTO_TEL  $3.
                  @ 14 N_NUM_NUMERO_TEL  $8.
                  @ 22 V_COD_ABI  $5.
                  @ 27 C_FLG_TIP_ABI  $1.
                  @ 28 V_DES_BANCA  $30.
                  @ 58 D_DAT_RIFERIMENTO  $6.
                  @ 64 C_FLG_STATO_DELEGA  $1.
                  @ 65 ID_MANDATO  $35.
                  @ 100 V_COD_RIEMPIMENTO  $1.;

          

        run;
2 REPLIES 2

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1076 views
  • 0 likes
  • 3 in conversation