Algo

Solo disponible en BuenasTareas
  • Páginas : 3 (702 palabras )
  • Descarga(s) : 0
  • Publicado : 27 de abril de 2011
Leer documento completo
Vista previa del texto
%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...
tracking img