BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
bebess
Quartz | Level 8

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

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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;

View solution in original post

3 REPLIES 3
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

bebess
Quartz | Level 8

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 ... ) :

 

http://documentation.sas.com/?docsetId=proc&docsetTarget=n0s97o94nhawspn1rjhhsiu4nucz.htm&docsetVers...

 

thanks for your help.

Kurt_Bremser
Super User

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;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 4486 views
  • 2 likes
  • 3 in conversation