hello, I need to print the table description (here "cars" ) into a log file. my problem is that log file holds more than the script like this" NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds" " But what I would like to obtain in the log file is : create table SASHELP.CARS( label='2004 Car Data' bufsize=16384 ) ( Make char(13), Model char(40), Type char(8), Origin char(6), DriveTrain char(5), MSRP num format=DOLLAR8., Invoice num format=DOLLAR8., EngineSize num label='Engine Size (L)', Cylinders num, Horsepower num, MPG_City num label='MPG (City)', MPG_Highway num label='MPG (Highway)', Weight num label='Weight (LBS)', Wheelbase num label='Wheelbase (IN)', Length num label='Length (IN)' ); proc printto log="/home/ldap/mellouna/log_macro_scrip_tables.txt" new; run;
proc sql;
describe table sashelp.cars ;
quit;
... View more