Use multiple statements to plot the data in PROC SGMAP, using GROUP with NOMISSINGGROUP in the SCATTER statements to keep missing data from being plotted. You can use the missing values to help plot locations. In the dataset below, PROVIDER is for the hotspot locations, sas is for the SAS Training Center, and BUSINESS_NAME2 is for the sidewalk cafés. When you combine the datasets, different variables are created for each item plotted in PROC SGMAP. See the SAS program for importing the café CSV data and add the distance from the SAS Training Center as you did before. New York City also provides data for sidewalk café licenses. Next, add some sidewalk cafés locations so you can use the free Wi-Fi while having lunch. I want to calculate it manually to get the same value 4.6443116482. Now you know where the free Wi-Fi hotspots are located close to the SAS Training Center. I want to calculate the distance using latitudes and longitudes but it should exactly replicate the outcome of GEODIST function for the same input of latitudes and longitudes. * this is to indicate the location of SAS */ Markerattrs= (symbol=triangledown size= 10 color=red ) * this plots the locations of the hotspots */ * This is the beginning of the Esri URL */ %let url = Use the PROC IMPORT DATAROW and GETNAMES statements to create a data set with well named variables. If you do a search for Wi-Fi Hotspot, a page for the NYC public WiFi hotspot locations is displayed and you export the data in CSV format.ĭownload the data and notice that first row of the data set are the column names, and the data starts on the second row. New York City provides many data sets on the NYC Open Data website. Plot the free Wi-Fi hotspots and some sidewalk cafés near the training center so you can have lunch and browse the internet. SAS Institute has a training center located on 7th Avenue in New York, but lunch is not provided. Here is the complete code for this example. You will also combine datasets and use multiple PROC SGMAP statements to plot data onto background maps. You can use these to create PROC SGMAP output even when using the free SAS University edition. As mentioned in other PROC SGMAP blogs, several SAS/GRAPH procedures have been moved to 9.4M6 Base SAS to be used with PROC SGMAP.
0 Comments
Leave a Reply. |