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' }"
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.