/* Hi , i need some help to create a "dynamic" file with macro variable values , i used the datalines but seems that it is not possible with MACRO */
filename in TEMP;
%let val=405;
data _null_;
file in;
input;
put _infile_;
datalines;
{
"rclcId": &val,
"rclcEndDate": %sysfunc(datetime()),
}
;
run;
Macro triggers are not resolved in a datalines block. Use individual put statements instead:
data _null_;
file in;
put;
put "{";
put '"rclcId": '"&val,";
put '"rclcEndDate": '"%sysfunc(datetime()),";
put "}";
run;
Tell us what you have, and what you want. You can't use macro after the time the macro processor has been through:
macro processor runs
data compiler runs < - at this point macro will not work.
for my need ( create a file which is going to be call in a PROC HTTP ( in parameter) ) , i used the JSON procedure ( i have never used it before ... ) :
thanks for your help.
Macro triggers are not resolved in a datalines block. Use individual put statements instead:
data _null_;
file in;
put;
put "{";
put '"rclcId": '"&val,";
put '"rclcEndDate": '"%sysfunc(datetime()),";
put "}";
run;
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.