Search code examples
sassas-studio

ERROR: Physical file does not exist {on SAS studio (Academic ondemand-web based)}

I am combining two XPT files with following program code:

    LIBNAME DM XPORT '/home/u62208181\DEMO.XPT';
        LIBNAME QX XPORT '/home/u62208181\CDQ.XPT';
        LIBNAME OUT '/home/u62208181';
        
        DATA OUT.CDQ_DEMO;
           MERGE DM.DEMO (KEEP=SEQN RIDAGEYR RIAGENDR) 
                 QX.CDQ (IN=A);
           BY SEQN;

   IF A;
   RUN;

Even though files are in folder- SAS show this error Image clearly show file in upload section

Solution

  • Try converting the XPT to SAS data sets first. Note that Unix is case sensitive, if you still get an error right click on the XPT file in the folder and copy the path from properties and paste that into your path.

    LIBNAME DM XPORT '/home/u62208181/DEMO.XPT';
LIBNAME QX XPORT '/home/u62208181/CDQ.XPT';
LIBNAME OUT '/home/u62208181';
        
PROC COPY IN=DM  OUT= OUT;
SELECT DEMO;
RUN;

PROC COPY IN=QX OUT=OUT;
SELECT CDQ;
RUN;

DATA OUT.CDQ_DEMO;
    MERGE OUT.DEMO (KEEP=SEQN RIDAGEYR RIAGENDR) 
          OUT.CDQ (IN=A);
    BY SEQN;

    IF A;
RUN;