The RESOLVE() function solution should work.
Let's set up and example by creating some example files. First the original file with no macro variable references. Then a version that replaces the original text with macro variable references. Here is code to create a file name WANT with your original text with some minor editing to make it look more like valid JSON (Notice the quotes around the text values) and make the indentation easier for humans to scan.
filename want temp;
options parmcards=want;
parmcards4;
data =
{"name": "name"
,"dataTableUri": "dataTableUri"
,"type": "predictive"
,"pipelineBuildMethod": "template"
,"analyticsProjectAttributes":
{"targetVariable" : "target"
,"partitionEnabled" : "True"
,"targetEventLevel" : "1"
}
,"settings":
{"applyGlobalMetadata" : "false"
}
,"links":
[
{"method": "GET"
,"rel": "initialPipelineTemplate"
,"href": "pipelineHref"
,"uri": "pipelineUri"
,"type": "application/vnd.sas.analytics.pipeline.template"
}
]
}
;;;;
Now let's replace some of the values with macro variables and make a new file named HAVE which will be the input to our program.
filename have temp;
options parmcards=have;
parmcards4;
data =
{"name": "name"
,"dataTableUri": "&dataTableUri."
,"type": "predictive"
,"pipelineBuildMethod": "template"
,"analyticsProjectAttributes":
{"targetVariable" : "&target."
,"partitionEnabled" : "True"
,"targetEventLevel" : "1"
}
,"settings":
{"applyGlobalMetadata" : "false"
}
,"links":
[
{"method": "GET"
,"rel": "initialPipelineTemplate"
,"href": "&pipelineHref."
,"uri": "&pipelineUri."
,"type": "application/vnd.sas.analytics.pipeline.template"
}
]
}
;;;;
So now let's make a program to convert the HAVE dataset. Let's call the output TRY. First we need to assign values to the macro variables.
%let dataTableUri=dataTableUri;
%let target=target;
%let pipelineHref=pipelineHref;
%let pipelineUri=pipelineUri;
filename try temp;
data _null_;
infile have ;
file try;
input ;
_infile_=resolve(_infile_);
put _infile_;
run;
Now let's compare the two files and see if they match.
156 data _null_;
157 length cmd $600 ;
158 cmd=catx(' ','diff -b',quote(trim(pathname('want'))),quote(trim(pathname('try'))));
159 infile cmd pipe filevar=cmd;
160 input;
161 put _infile_;
162 run;
NOTE: The infile CMD is:
Pipe command="diff -b ".../#LN00028" ".../#LN00030""
NOTE: 0 records were read from the infile CMD.
Let's try it with different values for the macro variables:
%let dataTableUri=intable;
%let target=outtable;
%let pipelineHref=url;
%let pipelineUri=uri;
results:
3c3
< ,"dataTableUri": "dataTableUri"
---
> ,"dataTableUri": "intable"
7c7
< {"targetVariable" : "target"
---
> {"targetVariable" : "outtable"
18,19c18,19
< ,"href": "pipelineHref"
< ,"uri": "pipelineUri"
---
> ,"href": "url"
> ,"uri": "uri"
NOTE: 14 records were read from the infile CMD.
The minimum record length was 3.
The maximum record length was 34.
Click image to register for webinar
