/* 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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
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.