DATA Step, Macro, Functions and more

reading a credit bureau file (space delimited?)

Reply
Super Contributor
Posts: 395

reading a credit bureau file (space delimited?)

Hi,

 

I got back some credit bureau files that have no extension, It looks like it may be space delimited if I try opening them in Excel (it doesn't quite work).  As the file type they are 'CREDITREPORT - FINALV2 File', and that's it.. the file  have a names such as :

E1388a3-5503.creditreport-finalv2 (with no extension).  The Credit Bureau is closed for support and I need to start ASAP on this project.  Any help on this?, I'm trying to read these file sin SAS.  Import of any kind didn't work.

 

Thanks 

Super User
Posts: 17,831

Re: reading a credit bureau file (space delimited?)

Open the file and view it in a text editor, ie Notepad. 

 

You'll most likely need to write a manual data step import. Usually you should get a record layout file that specifies the field and types. 

 

http://www.ats.ucla.edu/stat/sas/modules/input.htm

Ask a Question
Discussion stats
  • 1 reply
  • 141 views
  • 0 likes
  • 2 in conversation