I want to use Proc http to download a json file from a website, then read the data and manipulate it.  I have never used Proc http before and have two questions.   First Question - I am getting symbolic reference warnings and don't know if these are warning I can ignore or not?  My URL address is very long and I get the following warnings: WARNING: Apparent symbolic reference SYSPARM_DISPLAY_VALUE not resolved. WARNING: Apparent symbolic reference SYSPARM_EXCLUDE_REFERENCE_LINK not resolved. WARNING: Apparent symbolic reference SYSPARM_FIELDS not resolved. WARNING: Apparent symbolic reference SYSPARM_LIMIT not resolved.   The code I am running is: filename out TEMP; filename cacm TEMP; proc http url="https://abc.service-now.com/api/now/table/u_cacm_pl_uw_mngr_type_8?sysparm_query=cref_referred_dateONLast%2012%20months%40javascript%3Ags.beginningOfLast12Months()%40javascript%3Ags.endOfLast12Months()%5Ecref_referent.job_title%3DPersonal%20LOB%20Underwriting%20Manager%5EORcref_referent.job_title%3DLOB%20Underwriting%20Manager%5EORcref_referent.job_title%3DUnderwriting%20Manager%5EORcref_referent.job_title%3DUnderwriting%20Manager&sysparm_display_value=true&sysparm_exclude_reference_link=true&sysparm_fields=c_number%2Cc_case_open_timestamp%2Ccref_referred_date%2Ccref_response_date%2Ccref_referent%2Ccp_policy.contract_state_code&sysparm_limit=10" method="GET" out=out headerout=cacm AUTH_NEGOTIATE WEBUSERNAME="admin" WEBPASSWORD="xxxxxxxxxx"; run; libname CACM xlsx "%sysfunc(pathname(out))" ; proc copy inlib=cacm outlib=WORK; run;   My second question - assuming that I don't need to worry about the warnings or if I can resolve them and mt PROC HTTP successfully runs (it seems to run with no errors), then how do I read the dataset? In this case, I would like to make JSON output as a SAS dataset and mainpulate it.  My code runs with no errors but also no output. The test JSON output should look loke this: Test REST Response: {"result":[ {"c_number":"3364","cp_policy.contract_state_code":"OH","cref_referred_date":"2019-09-23","cref_response_date":"2019-09-27","c_case_open_timestamp":"2019-09-23"}, {"c_number":"2489","cp_policy.contract_state_code":"CO","cref_referred_date":"2019-07-30","cref_response_date":"2019-07-31","c_case_open_timestamp":"2019-07-30"}, {"c_number":"3571","cp_policy.contract_state_code":"WA","cref_referred_date":"2019-10-09","cref_response_date":"2019-10-18","c_case_open_timestamp":"2019-10-08"}, {"c_number":"2752","cp_policy.contract_state_code":"IA","cref_referred_date":"2019-08-15","cref_response_date":"2019-08-27","c_case_open_timestamp":"2019-08-15"}, {"c_number":"2752","cp_policy.contract_state_code":"IA","cref_referred_date":"2019-08-15","cref_response_date":"2019-08-27","c_case_open_timestamp":"2019-08-15"}, {"c_number":"3016","cp_policy.contract_state_code":"NE","cref_referred_date":"2019-08-29","cref_response_date":"2019-09-09","c_case_open_timestamp":"2019-08-29"}, {"c_number":"3336","cp_policy.contract_state_code":"MO","cref_referred_date":"2019-09-23","cref_response_date":"2019-09-23","c_case_open_timestamp":"2019-09-23"}, {"c_number":"3336","cp_policy.contract_state_code":"MO","cref_referred_date":"2019-09-23","cref_response_date":"2019-09-23","c_case_open_timestamp":"2019-09-23"}, {"c_number":"3336","cp_policy.contract_state_code":"MO","cref_referred_date":"2019-09-23","cref_response_date":"2019-09-23","c_case_open_timestamp":"2019-09-23"}, {"c_number":"2817","cp_policy.contract_state_code":"WI","cref_referred_date":"2019-08-19","cref_response_date":"2019-08-27","c_case_open_timestamp":"2019-08-19"} ]}   I appreciate any help or guidance! ... View more

I am trying to create a triangle report (most commonly used by actuaries for claim loss purposes) in SAS EG.  Essentially it tracks loss payouts (or other types of data) as they change from month to month (or some other period of time).  Unfortunately, I am not having much luck and am wondering if anyone has created one in SAS.  I could use some guidance. Thanks, Greg ... View more

I followed "Convert Character variable / string YYYYMM in date" solved discussion and entered the following code: PROC SQL; CREATE TABLE WORK.QUERY_FOR_COMBINED_PANDG_MONTHLY AS SELECT /* interval */ (input(t1.yr_mnth !! "01",yymmdd8.)) FORMAT=YYMMDD8. LABEL="interval" AS interval FROM PLCP.COMBINED_PANDG_MONTHLY_VOLUMES t1; QUIT;   However, the results came back as dot (.).  Not sure what I did wrong.  Any help will be greatly appreciated.   Thanks, Greg ... View more