Proc sql output

[BrahmanandaRao]

data new1;
input id ;
datalines;
1
.
1
1
;
run;

data new2;
input id ;
datalines;
1
1
1
;
run;

proc sort data=new1 ;
by id;
run;


proc sort data=new2;
by id;
run;



data left;
merge new1 (in=a) new2 (in=b);
by id;
if  a then output;
proc print;
run ;

Proc sql num;
Select a.*, b.* from new1 a left outer join new2 b on a.id=b.id;
Quit;

data left;
merge new1 (in=a) new2 (in=b);
by id;
if  b then output;
proc print;
run ;

Proc sql num;
Select a.*, b.* from new1 a right outer join new2 b on a.id=b.id;
Quit;

[Kurt_Bremser]

Do not post pictures(!) of the log summary. Post the complete log text by copy/pasting it into a code box opened with the </> button.

[Amir]

Hi @BrahmanandaRao,

When I run your code, the error that is shown with the code in the log highlights the word num as the issue:

 121        Proc sql num;
                     ___
                     22
                     202
 ERROR 22-322: Syntax error, expecting one of the following: ;, CHECK, CODEGEN, CONSTDATETIME, DICTDIAG, DOUBLE, DQUOTE, ERRORSTOP, 

Removing num allows me to run the code without an error.

Kind regards,

Amir.

[tarheel13]

It's proc sql number if you want row numbers to be displayed. There is no proc sql num.