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 */ |
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.