I use this code:
%let Result = %sysevalf(&Number1. + &Number2.);
%let old = %sysfunc(stpsrv_header(Content-type, application/json));
%let old = %sysfunc(stpsrv_header(Access-Control-Allow-Origin, *));
data _null_;
file _webout;
put '{ "name":"John1", "age":31, "city":"New York" }';
run;
Here the Number1 and Number2 macro variables come from prompts and should ultimately come from query strings. How can I add the Result macro variable to the JSON file to achieve something like this:
{ "name":"John1", "age":31, "city":"New York", "Result":"333" }
ff
Would it be acceptable to use single quotes instead of double quotes?
{ 'name':'John1', 'age':31, 'city':'New York', 'Result':'333' }
If so, the PUT statement could use double quotes on the outside, and the end might look like:
put "{ ..................... 'Result':'&result' }"
Would it be acceptable to use single quotes instead of double quotes?
{ 'name':'John1', 'age':31, 'city':'New York', 'Result':'333' }
If so, the PUT statement could use double quotes on the outside, and the end might look like:
put "{ ..................... 'Result':'&result' }"
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.