/* 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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.