Hello,   I have the current code that goes to a weather website a downloads the data into SAS. The station macro, inputs the corresponding station id into the URL and then pulls the weather for that city. I will be inputting about 100+ cities. Instead of adding each individual station id to the macro below, is there a way to utilize a do loop macro that would go through a list of station id's that i will save as a sas dataset? i will be saving the new data set which will contain Station ID and City and calling it Weather_Stations.    %macro station (stat=); filename in url "http://climate.weather.gc.ca/climate_data/bulk_data_e.html?format=csv&stationID=&stat&Year=2018&Month=10&Day=1&timeframe=2&submit=Download+Data"; filename out "%sysfunc(pathname(work))\data.csv"; data _null_; infile in; input; if _n_> 25; file out; put _infile_; run; PROC IMPORT OUT= WORK.data_&stat DATAFILE= "%sysfunc(pathname(work))\data.csv" DBMS=CSV REPLACE; RUN; %mend; %station (stat=52518);/*Sydgary*/ %station (stat=50149);/*Edmonton */ %station (stat=50837);/*Fort St.John*/ %station (stat=48369);/*Kelowananey*/ %station (stat=50620);/*Halifax*/ %station (stat=50309);/*Moncton*/ %station (stat=50068);/*Deer Lake*/ %station (stat=50089);/*St.Johns*/ %station (stat=50621);/*Chartown*/ %station (stat=51157);/*Montreal*/ %station (stat=26892);/*Quebec*/ %station (stat=51459);/*Toronto*/ %station (stat=49568);/*Ottawa */ %station (stat=54604);/*North Bay*/ %station (stat=27174);/*Winnipeg*/ %station (stat=28011);/*Regina*/ %station (stat=47707);/*Saskatoon*/ %station (stat=50430);/*Cal*/ %station (stat=51442);/*Vancouver*/ %station (stat=51337);/*Victoria*/ ... View more

Hello, i currently have a table set up as which is called "store_long_lat" I would like to calculate the distance between Latitude Longitude, and Latitude1 Longitude1.  and call it distance within the same table. There are 2000 rows in this table so I wold like to stray from the method where you have to input your Long and Lat values . I tried the below code and it produces a table with no data. Feel like am I close but just cant get an output to produce.   data distance; set store_long_lat; input Latitude Longitude latitude1 longitude1; distance = geodist(Latitude, Longitude, latitude1, longitude1); put 'distance = ' Distance 'Miles'; datalines; run;   I ran the below which produces a distance value inthe log but this does not work for my scenario:   data _null_; distance = geodist(44.746052,-65.516649,43.68,-79.63); put 'Distance= ' distance 'kilometers'; run;   ... View more

Hello,   I am trying to import some data from a website into SAS. The website has an "Download Data" button which when you select exports a CSV file to excel. I would like this file to come into SAS. Also, when exported to CSV, the data does table does not start until LIne 26 and has some info about the data above that is not needed.   Is it possible to import this? Ive seen example getting data tables from websites but I have yet to find an example of someone pulling data in from a "Download Data" button within a website. The reason I wish to use this data instead of the data table that appears on the website is that it contains the entire years worth of data vs. the table on the website which only shows you the month you selected.     "http://climate.weather.gc.ca/climate_data/daily_data_e.html?hlyRange=2012-09-10%7C2018-10-24&dlyRange=2012-09-10%7C2018-10-24&mlyRange=%7C&StationID=50620&Prov=NS&urlExtension=_e.html&searchType=stnProv&optLimit=specDate&StartYear=1840&EndYear=2018&selRowPerPage=25&Line=15&Month=10&Day=24&lstProvince=NS&timeframe=2&Year=2018" ... View more