/* 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;
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.