How do I use GeoMap feature

[laxmikanth]

Hi... I am trying to acces SAS Visual Analytics from teradatauniversity network. I have two questions.

1) I try to upload data from local, a .xlsx format file. It shows an error and says, could be a credential issue with the server

2) I would like to use GeoMap feature. The data set that I am analyzing has the X and Y coordinates in SPC (State Plane Coordinates) system. But I dont see one option of selecting the coordinates format into this. I only see, GDS, British and someother type.   

Can someone help me with this.

Thanks for your assistance!!!

[Sam_SAS]

Hi, can you share the error message you get when loading a xlsx file?

I have forwarded your question about SPC coordinates to our geomap specialist, hopefully he can provide some advice on how to get your SPC data working in VA.

Thanks,
Sam

[laxmikanth]

Thanks for the reply Sam, please find the attached capture of the error. To confirm again, I am using a cloud version of the VA tool from the teradatauniversitynetwork.com.

Thanks!!!

[Sam_SAS]

I am not an expert on VA administration or data loading, but I would think this is a configuration issue with teradatauniversity. Do they have a support contact you could report it to?

[laxmikanth]

Not sure Sam, this is my first time use of the tool and my first try of the question to the community. I will try reaching out to teradata, anyways thanks for the reply.

Regards! 

[Sam_SAS · Accepted solution]

About State Plane Coordinates, you will need to convert those coordinates to another system such as World Geodetic System. SAS/GRAPH has a GPROJECT procedure that can do this. I'm sure there are also third party utilities to convert the coordinates.

SAS is working to add support for State Plane Coordinates in VA for the future, hopefully for next release.

[laxmikanth]

Thanks for the information Sam, sure will look into the said procedures.

[laxmikanth]

Sam, you sure on how and from where to access SAS/GRAPH software.

Thanks,

[Sam_SAS]

As I understand it, SAS/GRAPH is not part of the SAS University Edition that is available free to university students / faculty. You would have to license SAS, which probably does not make sense for you.

There are some SPC conversion utilties such as this one:
http://www.ngs.noaa.gov/TOOLS/spc.shtml#

I have no experience with this, but it might help.