Help in my pgm

[knveraraju91]

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

[mkeintz]

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

[knveraraju91]

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.

[ballardw]

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

---