topic Re: datalines and macro variable in SAS Programming

datalines and macro variable

bebess — Thu, 28 Jun 2018 11:53:20 GMT

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

Re: datalines and macro variable

RW9 — Thu, 28 Jun 2018 12:12:36 GMT

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.

Re: datalines and macro variable

Kurt_Bremser — Thu, 28 Jun 2018 12:43:50 GMT

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;

Re: datalines and macro variable

bebess — Thu, 28 Jun 2018 12:47:47 GMT

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&docsetVersion=9.4&locale=fr

thanks for your help.