What are the names of the table(s) in the files? Are they always named Sunday? or does each file have multiple tables? Does every file have the same number of tables? - Files are  named as 1-31. Tables can be any of the weekdays. One file can have multiple tables.   Also what is with the folder that looks like it might be referencing some day in September? - I have 11 folders each containing 28-31 files from Nov 17-Sept18. (nov 2017 to Sept 2018)     ... View more

First, translate your lat-long coordinates into X-Y coordinates, such as UTMX and UTMY, so that both are expressed in the same units. Then ask proc mixed to fit a spatial covariance structure to your data with   random intercept / type=sp(pow)(utmx utmy);   also consider type=sp(sph)(utmx utmy) or type=sp(exp)(utmx utmy), (the choice will probably not matter much).   hth ... View more