Algo
Páginas: 3 (702 palabras)
Publicado: 27 de abril de 2011
%IF %SYSFUNC(EXIST(&dsname)) %THEN %DO;
DROP TABLE &dsname;
%END;
%IF %SYSFUNC(EXIST(&dsname, VIEW)) %THEN %DO;
DROP VIEW &dsname;
%END;
%mend_SASTASK_DROPDS;
%LET _EGCHARTWIDTH=0;
%LET _EGCHARTHEIGHT=0;
/* -------------------------------------------------------------------
Code generated by SAS Task
Generated on: Tuesday, April 26,2011 at 16:51:21
By task: One-Way Frequencies
Input Data: SASUSER.QUERY1_FOR_APPEND_TABLE_0002
Server: Local
------------------------------------------------------------------- */PROC SQL;
%_SASTASK_DROPDS(WORK.SORT);
QUIT;
/* -------------------------------------------------------------------
Data set SASUSER.QUERY1_FOR_APPEND_TABLE_0002 does not need to be sorted.------------------------------------------------------------------- */
PROC SQL;%macro _SASTASK_DROPDS(dsname);
%IF %SYSFUNC(EXIST(&dsname)) %THEN %DO;
DROP TABLE &dsname;
%END;
%IF%SYSFUNC(EXIST(&dsname, VIEW)) %THEN %DO;
DROP VIEW &dsname;
%END;
%mend _SASTASK_DROPDS;
%LET _EGCHARTWIDTH=0;
%LET _EGCHARTHEIGHT=0;
/*-------------------------------------------------------------------
Code generated by SAS Task
Generated on: Tuesday, April 26, 2011 at 16:51:21
By task: One-Way Frequencies
Input Data: SASUSER.QUERY1_FOR_APPEND_TABLE_0002
Server:Local
------------------------------------------------------------------- */
PROC SQL;
%_SASTASK_DROPDS(WORK.SORT);
QUIT;
/*-------------------------------------------------------------------
Data set SASUSER.QUERY1_FOR_APPEND_TABLE_0002 does not need to be sorted.
------------------------------------------------------------------- */
PROC SQL;
CREATE VIEW WORK.SORT
ASSELECT ESTADO_TARJETA, ANO_BAJA FROM SASUSER.QUERY1_FOR_APPEND_TABLE_0002;
QUIT;
TITLE;
TITLE1 "One-Way Frequencies";
TITLE2 "Results";
FOOTNOTE;
FOOTNOTE1 "Generated by the SAS System...
Leer documento completo
Regístrate para leer el documento completo.