En PROC SQL hay dos parámetros que pueden ser útiles cuando estamos escribiendo un código muy grande.
NOEXEC es útil si desea verificar la sintaxis de sus declaraciones SQL sin ejecutar las declaraciones.
FEEDBACK especifica si PROC SQL muestra sentencias PROC SQL en el registro SAS después de que se expanden las referencias de vista o si se realizan otras transformaciones de la sentencia.
Esta opción tiene los siguientes efectos:
Ejemplo:
PROC SQL NOEXEC FEEDBACK;
SELECT* FROM SASHELP.CARS;
Quit;
Log:
79 80 PROC SQL NOEXEC FEEDBACK; 81 SELECt * FROM SASHELP.CARS; NOTE: Statement transforms to: select CARS.Make, CARS.Model, CARS.Type, CARS.Origin, CARS.DriveTrain, CARS.MSRP, CARS.Invoice, CARS.EngineSize, CARS.Cylinders, CARS.Horsepower, CARS.MPG_City, CARS.MPG_Highway, CARS.Weight, CARS.Wheelbase, CARS.Length from SASHELP.CARS; NOTE: Statement not executed due to NOEXEC option. 82 83 Quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds
84 85 /* region: Generated postamble */ |
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.