01-13-2012 08:55 AM
Just started to use Proc SQL.
Is it possible to get more informative messages in the log when running proc SQL code. It only seems to give the number of obs in the final output dataset but I would also like to see values for the input tables esp. when using joins and where clauses when reading the datasets in....still a DATA STEP man!
01-16-2012 05:41 AM
Thanks for the replies.
Had a look at the SAS documetation: http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/viewer.htm#a001360938.htm
but nothing there about getting information about how many input records were read in. I hope SASkiwi is not right and it is not possible..it would be useful to have this information in the log.
01-17-2012 11:30 AM
I suspect that there is not such an option. PROC SQL does not necessarily even read all the rows, nor would the underlying data base engine. You could use the DESCRIBE statement to get some information about the underlying tables.
01-18-2012 06:23 AM
Thanks for all your help guys
I think SAS users could really benefit from log info regarding how many obs where read in for each input table as often where clauses are attached to them when reading in them in
Have a good day