Algo

Páginas: 3 (702 palabras) Publicado: 27 de abril de 2011
%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;%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.

Conviértase en miembro formal de Buenas Tareas

INSCRÍBETE - ES GRATIS