how to excecute a perl command via a pipe command in SAS

[alepage]

Here's an example how to rename a file in Unix via a pipe command.

filename oscmd pipe "mv ""&file_path./&xmlFile."" ""&file_path./&xmlFile2."" 2>&1";

data _null_;
infile oscmd;
input;
put _infile_;
run;

But how do we execute the following perl command:

perl -pe 's/[^çêèàûéîôâÇÀÛÔÉÇÈÊ"@-_<>’[:ascii:][:alnum:][:space:][:punct:]]+//g' </&Path1/Virage Survey.xml> &Path1./VirageSurvey.xml

[Tom]

Why would it work any differently????

Just be careful with the quotes.  Both SAS and unix shells are picky about making sure the quotes a balanced and appropriate.  The QUOTE() function can help.

Note you don't need to use a FILENAME statement.  You can include the command in the INFILE statement directly instead.

%let path1=/some/folder/name ;
%let cmd=perl -pe 's/[^çêèàûéîôâÇÀÛÔÉÇÈÊ"@-_<>’[:ascii:][:alnum:][:space:][:punct:]]+//g' </&Path1/Virage Survey.xml >&Path1./VirageSurvey.xml;
data _null_;
  infile %sysfunc(quote(&cmd)) pipe;
  input;
  put _infile_;
run;