Left join problem

[omerzeybek]

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

[sas_9]

This will help you!

http://support.sas.com/kb/45/592.html

http://support.sas.com/kb/49/873.html

[DR_Majeti]

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).

[omerzeybek]

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

[DR_Majeti]

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...