topic Re: Proc sql output in SAS Programming

Proc sql output

BrahmanandaRao — Mon, 05 Jul 2021 11:42:24 GMT

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;

Re: Proc sql output

Kurt_Bremser — Mon, 05 Jul 2021 12:33:37 GMT

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.

Re: Proc sql output

Amir — Mon, 05 Jul 2021 13:48:35 GMT

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.

Re: Proc sql output

tarheel13 — Mon, 05 Jul 2021 20:51:28 GMT

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