Desktop productivity for business analysts and programmers

File does not exist

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 123
Accepted Solution

File does not exist

I created a copy program off of a query builder so that I could take a different dataset as input. Here is what the program looks like:

 

%_eg_conditional_dropds(EGTASK.QUERY_FOR_MAC_PRICE_TREND_B_0002);

PROC SQL;
   CREATE TABLE EGTASK.QUERY_FOR_MAC_PRICE_TREND_B_0002 AS 
   SELECT DISTINCT t4.CLIENT, 
          t4.Business_Line, 
          t4.Channel, 
          t1.GPI, 
          t1.'2016M07'n, 
          t1.'2015M07'n, 
          t2.Y_AWP, 
          t3.Discount, 
          /* SUM_of_SUM_of_SUM_OF_QUANTITYDIS */
            (SUM(t4.SUM_of_SUM_OF_QUANTITYDISPENSED)) FORMAT=20. AS SUM_of_SUM_of_SUM_OF_QUANTITYDIS
      FROM EGTASK.QUERY_FOR_MAC_PRICE_TREND_B t1
           LEFT JOIN EGTASK.AWP t2 ON (t1.GPI = t2.GPI_ID_Number)
           LEFT JOIN EGTASK.GENERICQTY t4 ON (t1.GPI = t4.GPINumber)
           LEFT JOIN EGTASK.GENERIC_DISCOUNTS_BY_CLIENT t3 ON (t4.'MAC List'n = t3.'MAC List'n) AND (t4.Business_Line = 
          t3.Business_Line) AND (t4.CLIENT = t3.CLIENT) AND (t4.Channel = t3.Channel)
      WHERE t4.'MAC List'n IN 
           (
           'MAC01',
           'MACNC',
           'MACIA',
           'MACIVL',
           'MACMAILHIM',
           'MACMS'
           ) AND t4.Business_Line = 'Commercial'
      GROUP BY t4.CLIENT,
               t4.Business_Line,
               t4.Channel,
               t1.GPI,
               t1.'2016M07'n,
               t1.'2015M07'n,
               t2.Y_AWP,
               t3.Discount;
QUIT;

However when I run it I get the errors:

 

ERROR: File EGTASK.AWP.DATA does not exist.
ERROR: File EGTASK.GENERICQTY.DATA does not exist.
ERROR: File EGTASK.GENERIC_DISCOUNTS_BY_CLIENT.DATA does not exist.

 

The dataset names for the joins do not have ".DATA" at the end of them in this query or where they are created within the project and I know this for a fact. The query builder with this same code (minus the new output table name) runs perfectly fine. What is going on here?

 

 


Accepted Solutions
Solution
‎09-30-2016 10:21 AM
Super User
Posts: 5,372

Re: File does not exist

The fact that SAS added .DATA is not an issue.  The folder that holds your data sets is also capable of holding SAS catalogs.  And it is possible that a SAS catalog has the same name as a SAS data set.  So SAS is distinguishing that the file being searched for is a SAS data set and not a catalog.

 

Most likely the issue here is that EGTASK is defined differently in the run that works vs. the run that doesn't work.  That's where I would start the investigation.

 

Good luck.

View solution in original post


All Replies
Solution
‎09-30-2016 10:21 AM
Super User
Posts: 5,372

Re: File does not exist

The fact that SAS added .DATA is not an issue.  The folder that holds your data sets is also capable of holding SAS catalogs.  And it is possible that a SAS catalog has the same name as a SAS data set.  So SAS is distinguishing that the file being searched for is a SAS data set and not a catalog.

 

Most likely the issue here is that EGTASK is defined differently in the run that works vs. the run that doesn't work.  That's where I would start the investigation.

 

Good luck.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 866 views
  • 0 likes
  • 2 in conversation