/* 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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.