SAS tip of the day.

[SASMAN]

Have you used the data step debugger?<br>
If not, the next time you submit a data step that gives you those ugly ERRORs in the log or maybe when your data step gives you unexpected results, try the DEBUG option in the data step to envoke the debugger. There are a bunch of commands available from the online help that will help you use the debugger.<br>
Syntax to envoke the little bugger or should I say debugger:<br>
data libname.dsname / debug ; <br>
bla bla.....;<br>
<br>
Have fun.<br>
SASMAN

 

[mhw]

SASMAN,
Your name implies you are a heavy user of SAS. I'm using SAS 8.0 on an IBM mainframe submiting batch SAS jobs. I have 2 input flat files that I want to do an SQL JOIN on 2 particular columns of data in each file. Can this be done using SAS on the mainframe?
I found this code in the SAS online docs from the SAS institute but don't know if it will work running JCL batch jobs with flat files as input. I just want to know if I can use SQL functions with input files.
Any help would be appreciated.
Thanks,
MHW
proc sql;
create table proclib.newpay as
select * from proclib.paylist
union
select * from proclib.paylist2;