topic Help in my pgm in SAS Programming

Help in my pgm

knveraraju91 — Fri, 09 Oct 2020 18:15:22 GMT

Dear,

I am using below pgm to convert xpt files in folder to sas data sets. I am getting syntax error. XPT datasets are in rt1 folder. The output sas datasets will go rt2 folder in my pgm.

filename tmp pipe "dir /b ""abc/programs/qc/archive/rt1/*.xpt""";

libname ms "abc/programs/qc/archive/rt2";
data _null_;
  infile tmp;
  input;
  call execute(cats('filename xptfile "abc/programs/qc/archive/rt1/', _input_'"));
  call execute('proc copy inlib=xptfile outlib=ms; run;');
  call execute('filename xptfile clear;');
run;

Please suggest. Thank you

Re: Help in my pgm

mkeintz — Fri, 09 Oct 2020 19:04:53 GMT

Show the sas log, with reprinted sas statements, and SAS notes and messages regarding your question.

Re: Help in my pgm

ballardw — Fri, 09 Oct 2020 20:26:09 GMT

Check you quotes for unbalanced quotes. Just looking at the code as posted on the forum shows that the quotes aren't balanced because of the color the code text displays. The first Call execute is not closed properly.

@knveraraju91 wrote:

Dear,

I am using below pgm to convert xpt files in folder to sas data sets. I am getting syntax error. XPT datasets are in rt1 folder. The output sas datasets will go rt2 folder in my pgm.
filename tmp pipe "dir /b ""abc/programs/qc/archive/rt1/*.xpt""";

libname ms "abc/programs/qc/archive/rt2";
data _null_;
  infile tmp;
  input;
  call execute(cats('filename xptfile "abc/programs/qc/archive/rt1/', _input_'"));
  call execute('proc copy inlib=xptfile outlib=ms; run;');
  call execute('filename xptfile clear;');
run;
Please suggest. Thank you

Re: Help in my pgm

knveraraju91 — Fri, 09 Oct 2020 19:36:36 GMT

Thank you for your time. I could not resolve it. Please suggest

Here is log
NOTE: CALL EXECUTE generated line.
1 + filename xptfile "abc/programs/qc/archive/rt1/, _input_"
NOTE: Line generated by the CALL EXECUTE routine.
2 + proc copy inlib=xptfile outlib=ms;
____
23
ERROR 23-2: Invalid option name proc.

2 !+ proc copy inlib=xptfile outlib=ms;
____
23
ERROR 23-2: Invalid option name copy.

2 !+ proc copy inlib=xptfile outlib=ms;
_____
23
ERROR 23-2: Invalid option name inlib.

2 !+ proc copy inlib=xptfile outlib=ms;
______
23
ERROR: Error in the FILENAME statement.
ERROR 23-2: Invalid option name outlib.

3 + filename xptfile clear;
3 The SAS System

WARNING: No logical assign for filename XPTFILE.
4 + filename xptfile "abc/programs/qc/archive/rt1/, _input_"
NOTE: Line generated by the CALL EXECUTE routine.
5 + proc copy inlib=xptfile outlib=ms;
____
23
ERROR 23-2: Invalid option name proc.

5 !+ proc copy inlib=xptfile outlib=ms;
____
23
ERROR 23-2: Invalid option name copy.

5 !+ proc copy inlib=xptfile outlib=ms;
_____
23
ERROR 23-2: Invalid option name inlib.

5 !+ proc copy inlib=xptfile outlib=ms;
______
23
ERROR: Error in the FILENAME statement.
ERROR 23-2: Invalid option name outlib.

6 + filename xptfile clear;
WARNING: No logical assign for filename XPTFILE.