Hi Brandon!
First, thank you very much for your help.
Sorry if my question was a little vague. My Incident/Facilty locations come from two layers. Both of the layers have a unique identifier for state and county. When I right click on "Facilities" on the table of contents to load the layer, the locations appear in the map wihtout trouble. However, when I open the attribute table for facilities, I don't see anymore the state and county unique identifiers. This problem is completely regardless Stata.
What I want is to keep these identifiers so that later in Stata I can use them to produce different kind of analysis. But since I have thousands of routes, this obviously cannot be a mannual task. I want to automatically produce a route table that contains those identifiers. In the end, let's suppose that the variables or attributes in the final table I want are the following:
Origin ID / Origin name / Destination ID / Destination name / Total route lenght / State-1 / Lenght of road in State -1 / ......... / State-n / Lenght of road in State n.
So, in words, I want the entire distance from origin to destination, but I also want to know all the States the route goes across and the lenght of the route for each particular state.
Thanks again!
Francisco