Desktop productivity for business analysts and programmers

File does not exist

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 124
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: 6,903

Re: File does not exist

Posted in reply to JediApprentice

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: 6,903

Re: File does not exist

Posted in reply to JediApprentice

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.

Regular Learner
Posts: 1

Re: File does not exist

Posted in reply to Astounding

Hi All,

 

I need a small help..In library sas data set is existed when merging the data sets, Its shows an error saying that data does not exist in SAS EG.

 

Can you please help me with this one..its a little urgent.

 

Regards,

Sindhu

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 1651 views
  • 0 likes
  • 3 in conversation