Thank you SASKiwi.  That is what I ended up finding last night and I'm looking into it now. Thanks ... View more

It you called MAPIMPORT with an "id statefp10 countyfp10 tractce10 blockce10" then you can put the same ID statement on GINSIDE.  That will cause it to return those values.  Alternately, you can use GEOID10, which returns all those variables in one variable. It turns out MAPIMPORT must be called with that ID statement or GEOID10.  GEOID10 is what it is sorted be so you don't have to have an ID statement for that.  Since 'blockce10' is not unique (there is one in many tracts, it many counties) then you cannot use just that. ... View more

If you don't want to change the value then create a PICTURE format. proc format; picture myformat low-high='000009.99' (mult=1) ; run; data _null_;   input x;   put x 7.2 +1 x myformat. ; cards; 100 567890 run; 100.00 1.00 567890 5678.90 ... View more

Ballardw, I'm sorry about that.  This was about SAS 9.4 the other was with 9.3.  I have to use latitude and longitude to get the it to work.  I used this information to get the county fips code where it was missing from the geocode process. SAS/GRAPH(R) 9.2: Reference, Second Edition Thank you ... View more

Hi ballardw, Thank you so much for you help.  That did get me those 3 variables I needed.  The place is the FIPS Place and the CBSA are the other 2 I need.  I will look to see if SAS offers a file that will contain those 2 variables. Thank you again for your help. ... View more

I always miss the obvious.  Sorry for wasting your time.  I was looking at it a bit differently. Thank you again. ... View more

Hi data_null_; Thank you so much.  I did this and it seems to work correctly. filename temp "C:\temp\test.txt" ; data temp ;        ATTRIB         VAL  FORMAT=F7.2 ; infile temp ; input VAL 1-6 2 ; run ; ... View more

You can use the little known LOSTCARD statement to help you insure that the number of lines is correct. filename FT15F001 temp; data temp;          infile FT15F001 dlm=':' dsd lrecl=260 missover pad firstobs = 2;          length                   ID           $8          FNAME        $20          MNAME         $20          LNAME        $30                  CITY        $40          STATE       $2          ZIP            $5          PHONE       $15          PREV_CITY    $40          PREV_STATE  $2          PREV_ZIP    $5          PREV_PHONE  $15      ;     input #1 ID  FNAME MNAME LNAME          #2 id2 CITY STATE ZIP PHONE          #3 id3 PREV_CITY PREV_STATE PREV_ZIP PREV_PHONE       ;    if missing(id) or cmiss(id2,id3) ne 2 then lostcard; parmcards4; ID:FNAME:MNAME:LNAME:CITY:STATE:ZIP:PHONE:PREV_CITY:PREV_STATE:PREV_ZIP:PREV_PHONE 1:Homer:Jay:Simpson :Springfield:::(222)-333-4444 :Langley Falls:VA:88888 555)-666-7777 :Springfield:::(222)-333-4444 2:Bill:Phil:Williams :New York:NY::(123)-456-7890 ::::(987)-000-1212 2:New York:NY::(123)-456-7890 3:Wildbill:Phil:Williams :New York:NY::(123)-456-7890 ::::(987)-000-1212 ;;;;    run; proc print;    run; ... View more

Thank you so much for all your help ... View more