Desktop productivity for business analysts and programmers

Left join problem

Reply
Contributor
Posts: 65

Left join problem

I was building an detailed project with lots of queries, however suddenly my project started to give the error message, i submitted bellow. I am not sure whats the problem because i was able to join tables previously

Error Message:

   NOTE: Writing TAGSETS.SASREPORT12(EGSR) Body file: EGSR

12        

13         GOPTIONS ACCESSIBLE;

14         %_eg_conditional_dropds(WORK.BASE);

15        

16         PROC SQL;

17            CREATE TABLE WORK.BASE AS

18            SELECT DISTINCT t1.MUSTERI_NO,

19                   t1.BANKA_MUSTERI_NO,

20                   t1.MUSTERI_NO1,

21                   t1.KKLISTE,

22                   t1.URUN_ADI,

23                   t2.TNA

24               FROM WORK.KKJOIN t1 LEFT JOIN WORK.TNA t2 ON (t1.MUSTERI_NO = t2.MUSTERI_NO);

ERROR: Sort execution failure.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

25         QUIT;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

      real time           2.01 seconds

      cpu time            1.90 seconds

Regular Contributor
Posts: 220

Re: Left join problem

Contributor
Posts: 64

Re: Left join problem

Hi,

Hi please can you give the exact dataset names and variables. Because the syntax you used in from is little bit not in proper order(generally dataset names

doesnot contain any blanks).

Contributor
Posts: 65

Re: Left join problem

Hi Dr.Majeti

My dataset names in this query are Work.KKJOIN and Work.TNA

KKJOIN includes my account listings and TNA includes attributes whicch all my accounts have

Contributor
Posts: 64

Re: Left join problem

Proc Sql;

Create table work.base as

  Select *

  From work.kkjoin left join work.tna

           on work.kkjoin.musteri_no = work.tna.musteri_no;

Quit;

Please try this...

Ask a Question
Discussion stats
  • 4 replies
  • 620 views
  • 0 likes
  • 3 in conversation