I want to import a file into SAS Dataset. The file is in (.DAT) format. The file does not have delimiter.
However I do know the position of the data.
eg. Data in the file is as below
D12302020.....745639200.89USD.......ACCOUNTNULL12354596895...CHN.........
Position information provided is as below
Field Data Length Data Type
Record Type 1 Char
Date 8 Date
Code 6 Number
Amount 11 Decimal
Country 3 Char
The data should be in output in this way
Col1 Col2 Col3 Col4 Col5
D 12302020 7 45639200.89 USD
So based on the start and end position of the string I should be able to separate the columns, i.e. Col1 position(1), Col2 position (2-9), Col3 position(10-15) etc. however I am unable to do import the data into the table.