Cynthia:
The text file includes a separate field for street suffix. Here is an example of the street number, suffix and name. The fields are fixed width. Leading zeros fill the field..
street number street suffix streetname
0000029221 W 000186TH
I am going to check with the vendor tomorrow about the format. Currently, the script hacks is way through each field with something like this.
set propstreetname = substr(propstreetname,3,length(propstreetname))
where find(propstreetname,'00') = 1;
update sasuser.propinfo
Getting data with leading zeros would make data loading much faster and easier.
Again, thanks for the reply.
alan
... View more