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

alepage — Mon, 08 Jul 2024 19:54:41 GMT

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

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

Tom — Mon, 08 Jul 2024 20:11:40 GMT

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;

topic Re: how to excecute a perl command via a pipe command in SAS in SAS Enterprise Guide

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

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