About dauphine

dauphine · ‎09-09-2013

Thanks! I saw there were some spatial analyses in SAS. Temporal variability seems small compared to spatial variability, so I could ignore it at first, but we may want to incorporate it later. In any case I'm still looking for the code to randomly select wells rather than measurements, or convert my multiple rows per well (if it was measured more than once) to a single row for each well, with multiple measurements in new columns. As I told Steve, there's no "Well ID number" column yet, just latitude and longitude.

dauphine · ‎09-09-2013

Thanks for the quick reply Steve! I suppose however I can randomly sample wells, rather than measurements, is fine. The wells don't have ID numbers so far, just latitude and longitude. I was planning to do a geostatistical interpolation (kriging) model in ArcGIS, for starters at least, although I'm no ArcGIS expert either.

dauphine · ‎09-08-2013

Hi! I'm new to SAS, and I have a database with over 6000 measurements of arsenic in drinking water wells. Some wells were measured multiple times, and each measurement is a separate row. I want to change this so that there is a single row for each well, with new columns for the additional measurements, like "date2, arsenic2, depth2, address2..." Can anyone help me with the code? Eventually I want to randomly select 90% of the wells to make a training dataset to build a model predicting arsenic at unmeasured locations. The other 10% of wells will then be used as a validation dataset to see how well the model works. I was thinking of doing this using excel to assign a random number to each well once I get one row per well. If you've read this far, thanks very much!

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Converting multiple rows to a single row with multiple columns

Re: Converting multiple rows to a single row with multiple columns

Converting multiple rows to a single row with multiple columns

Re: Converting multiple rows to a single row with multiple columns

Re: Converting multiple rows to a single row with multiple columns

Converting multiple rows to a single row with multiple columns