Help to load data in to a PDB from a file

Pon1 — Thu, 06 Dec 2018 14:35:39 GMT

Dear All,

I am trying to load data from an external file to a SAS PDB in mainframe. The external CSV file contains (actually space delimited). The first record is the file headers, and the remaining is the data. Since we have more headers, I would like to know the easiest way to read the header (column name) and its type (Char or Num) and length of the column. Guide me how to create a PDB using the column names in header and it its record format. Then load the PDB.

Thank you,

Regards,

Raj.

Re: Help to load data in to a PDB from a file

Kurt_Bremser — Thu, 06 Dec 2018 20:07:36 GMT

Write a data step, according to the description you got with the csv file. In the infile statement, use firstobs=2 to skip the header line.

topic Re: Help to load data in to a PDB from a file in SAS Programming

Help to load data in to a PDB from a file

Re: Help to load data in to a PDB from a file