cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
postollma
‎02-27-2019
  • 5 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Entering a range into the %let statment

by Fluorite | Level 6 in SAS Procedures
‎02-19-2019 01:15 PM
‎02-19-2019 01:15 PM
@Reeza I have measles(YEAR) as different datasets. After that let statement, I want to do a proc summary as follows: proc summary data=&year; var countvalue; output out=total_&year sum=; run; so that I can get column totals for the variable countvalue by year. ... View more

Entering a range into the %let statment

by Fluorite | Level 6 in SAS Procedures
‎02-19-2019 01:05 PM
‎02-19-2019 01:05 PM
I would like to basically use the following code  %let year = measles1900 - measles2001; versus listing out each year %let year = measles1900 measles1901 measles1902 measles1903 measles1904 measles1905 measles1906 measles1907 measles1908 measles1909 ... and so on.   Do I need to use a command along the lines of %nstr, etc., am I able to use an array somehow, or am I out of luck and need to resort to listing all 102 years? ... View more

Re: Using API for CSV data

by Fluorite | Level 6 in SAS Data Science
‎02-06-2019 09:01 AM
‎02-06-2019 09:01 AM
@Patrick Try this url with my APIKEY https://www.tycho.pitt.edu/api/query?apikey=056b7aa4c98a061c4136&ConditionName=Measles&CountryISO=US   After I have this run, the log says "PROCEDURE HTTP used" then gives me the real and cpu processing times. It also has a note that says "200 OK" ... View more

Re: Using API for CSV data

by Fluorite | Level 6 in SAS Data Science
‎02-05-2019 01:01 PM
‎02-05-2019 01:01 PM
Thanks!  I tried using single quotes and the %nrstr() options, but the file doesn't show up in the work folder. I also tried saving to my documents folder instead of temp, but the file doesn't show up there either. Any thoughts on what is going wrong? ... View more

Using API for CSV data

by Fluorite | Level 6 in SAS Data Science
‎02-02-2019 03:47 PM
‎02-02-2019 03:47 PM
I am trying to download data that is in a CSV format from a query on the project tycho website.  I have the following:   filename response temp; proc http url="https://www.tycho.pitt.edu/api/query?apikey=MYAPIKEYHERE&ConditionName=Measles&CountryISO=US" out=response; run;   I have seen answers to other similar questions that show how to do the next step (libname statement) with JSON formats, but not with CSV. Does anyone know how to do this? Also, this is the first time I have worked with APIs. After the CSV is imported, do I just continue to analyze the data with data steps and procedures? Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-27-2019 12:04 PM
Likes given to
View All
Quick links