Hi Darrell, I just ran a proc ginisde using this code and it doesn't return back the statefp10, countyfp10 or tractfp10.  It does return blockce10. proc ginside     data=addr     map=blockData     out=addr_out     ;     id blockce10 ; run ;    This is using data that I got from proc mapimport using id blockce10; Can I add the other fields to my id statement within proc ginside?  Will it cause the data to be incorrect? Thank you ... View more

Good morning Darrell, I still have to re-run the map import because I used the select statement and only returned back state, county, tract and block.  GEOID10 is not in those tables. I did do a test with mapimport where I didn't use id or select statements.  This returned everything.  With proc gmap I used ID GEOID10 and it gave me the same map that it did when I used the id statement with blockce10. Thank you so much for all your help. ... View more

Hi Darrell, Previously I didn't use the id statement at all.  I will use GEOID10 within my proc mapimport. This is the code I should use, correct? Proc mapimport datafile="c:\temp\tl_2014_01_tabblock10.shp" out="AL_Block" contents; id GEOID10 ; run; I did run your code using the id statement and a version without the id statement and I did proc gmap.  I can see what you were talking about with the lines not lines up correctly without the id statement.  But when I did a proc ginside using the 2 rows of data you created for Birmingham and Jefferson county no data is returned back.   I'm running your code as it is. Thank you ... View more

Hi Darrell, Thank you so much for all your help. We are going to redo the process and use the id statement. With the block shape files it has Statefp10, CountyFp10, TractCE10 and BlockCE10 that I need to get back from proc ginside. Would this be the correct way to execute the proc mapimport?  I will try doing gmap on one of my current files to see what it looks like and then for the same state I will do it with the id statement. Proc mapimport datafile="c:\temp\tl_2014_01_tabblock10.shp" out="AL_Block" contents; id statefp10 countyfp10 tractce10 blockce10; run; This should give me correct data now when I do proc ginside, correct? Thank you, Jerry ... View more

Hi Darrell, Why isn't that listed as a required statement?  How would it cause bad data? This is the page that I looked at when I was working on that. SAS FAQ: How can I generate maps in SAS using an external shape file? In that example they don't use the id statement but the select statement.   We are not mapping this data.  All we need is the codes returned back using ginside.   Will that still return bad data? Here it says that mapimport will use the existing polygon order for the output map data set. SAS/GRAPH(R) 9.2: Reference, Second Edition For the block shape files what should the id be blockce10?  How about the other fields? Thank you, Jerry ... View more

Hi Darrel, Thank you for the reply. I was using select to select out the variables I need.  The map data does seem sorted.  By not using ID will it give me bad data or just slow down the process? I will speak to the lead guy tomorrow to see if we can use this approach.  My worry is that I created 51 tables use the proc mapimport without the id statement.  We have run some long processes against them.  I want to make sure the returned data isn't compromised. Thank again for your help.  I appreciate the information as well.  ... View more

Hi Darrell, Thank you so much for your reply.  Are you saying that I should subset the block file that I import to only leaves rows with the counties within my data?  I am unable to subset the data.  The lead wants to leave the file as is.  He is afraid we may compromise the quality of the returned data and we have to send it out to many people. Within the mapimport I was doing the following: proc mapimport datafile="c:\temp\state.shp" out=block_temp ;             select statefp10 countyfp10 tractce10 blockce10 ; run; The fact I'm not using the id statement with blockce10 will it cause a problem or slow down the process?  Can I leave it like this? I have already used this import for all 51 states and started to giniside  some of the states.  If the id is an issue I will have to recreate the map files and re-run ginside which will cause me even more delay.  The main thing I have to know is if the output will be incorrect. Thank you so much.  I really need to figure this issue out so I can complete this project. ... View more

Hi Tom, I'm connecting using the signon statement. When proc giniside runs it creates a temp table that is very large.  I want it to put that in a location where I have enough space for it to get as big as it needs. Thank you ... View more

Hi Darrell, That is exactly what I'm doing now.  I'm doing Alabama first.  I have 330 addresses and around 16 million rows in the block file for Alabama. Both tables are within my work library so it doesn't need to go get the data.   I'm using SAS 9.4 64-bit TS1M2 This is how my code looks al_addr=330 obs block_AL=16 million obs proc ginside data=al_addr map=block_AL out=AL_blk ; id statefp10 countyfp10 tractce10 blockce10 ; run ; Thank you so much for your help.  This is a big project and it's been one road block after another.  ... View more

Hi Darrell, I have downloaded the 51 state block shape files and have extracted them and imported them using proc mapimport.  Now I have a table with 645,065,406 rows.  When I try and do the proc ginside for just 1 address row using the block table it is taking a very long time.  It's at about 5 minutes now and still nothing is returned.  Is there options that can speed this process up?  Do you know of a better approach?  The block files have state, county, tract and block so all my info I need is there. Any help would be greatly appreciated. ... View more