09-26-2016 01:39 PM - edited 09-26-2016 02:57 PM
Does anyone have SAS code to share that will parse out raw credit bureau data for each of the major U.S. credit bureaus? Each bureau has it's own data structure.
09-28-2016 09:31 AM - edited 09-28-2016 09:32 AM
My immediate recommendation is to code your own against the data/file(s) you have.
Next - see if you can find a relevant and appropriate data dictionary for the data/file(s) you have.
As you indirectly stated "Major US CB"... the fact that they are - major - does facilitate finding information on the files they might make available for corporate use or consumption by an authorized, licensed entity. It might be on the web as a data dictionary or actual 'code'. But my caution is that they often do have changes to layouts, fields etc. Sometimes per file or projects.
IMHO - you are much better off (safer) asking each CB for the relevant DD, documentation directly per the file (file ids, file names etc).
Now - what you didnt state - which might be the case - is that many of these kinds of files have data dictionary and documentation but are a mess to read. Thus you would like code that is pre-written to help read intricately structured data such as those in CB's or other industries. That is found - but i'm not sure you'd hit the holy grail of all in one place. And certainly not by just saying "CB data" - there is no specificity in that and someone who would have it - wouldnt know what to share of the many types of files to be found (often).
So i'll ask back - do you need help with reading data using @ signs? do you need help with reading data that has different layouts per rows but within the same file? do you need help reading unstructured text? if you could narrow things down that might help out.
09-28-2016 09:45 AM
09-28-2016 10:02 AM
one trick that i do/use is...
a. i run the data thru proc import.
b. copy the relevant part of sas log from said proc import
c. customize and tailor the code and flip it to a dedicated .sas code
the customization i typically do:
a. assign specific lengths and formats
b. tailor field names
c. custom field formatting or changes
so i basically let proc import spring board my code generation for me.