LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2012, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 20 Jan 2012 17:24:37 -0200
Reply-To:     Ricardo Gonçalves da Silva
              <ricardo.gsilva@BANCOVOTORANTIM.COM.BR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ricardo Gonçalves da Silva
              <ricardo.gsilva@BANCOVOTORANTIM.COM.BR>
Subject:      RES: Data Truncation
Comments: To: oloolo <dynamicpanel@YAHOO.COM>
In-Reply-To:  <201201201921.q0KFhRaV019090@waikiki.cc.uga.edu>
Content-Type: text/plain; charset="iso-8859-1"

Hi Guys! Thanks a lot!! Works!

-----Mensagem original----- De: oloolo [mailto:dynamicpanel@YAHOO.COM] Enviada em: sexta-feira, 20 de janeiro de 2012 17:21 Para: SAS-L@LISTSERV.UGA.EDU; Ricardo Gonçalves da Silva Assunto: Re: Data Truncation

since your data is already sorted, for the simplest case, you can calculate the cut off number of records for both first 0.1% and last 0.1% (99.9% quantile) data new; set urdata nobs=ntotal; retain t1 t2 0; if _n_=1 then do; t1=int(ntotal*0.001); t2=int(ntotal*0.999); end; if _n_>t1 & _n_<t2 then output; run; On Fri, 20 Jan 2012 16:45:23 -0200, =?iso-8859-1?Q? Ricardo_Gon=E7alves_da_Silva?= <ricardo.gsilva@BANCOVOTORANTIM.COM.BR> wrote:

>Hi, > >Any hint in how can I drop the 0,1% first observations (negatives) and >the 0.1% last observations (positives) of my dataset, after sorted by my interest variables (real domain). >Thanks >Rick > >Esta mensagem e seus anexos podem conter informa��es confidenciais >ou privilegiadas. Se voc� n�o � o destinat�rio, n�o est� autorizado a utilizar o material para qualquer fim. Solicitamos que voc� apague a mensagem e avise imediatamente o remetente. O conte�do desta mensagem e seus anexos n�o representam necessariamente a opini�o e a inten��o da empresa, n�o implicando em qualquer obriga��o ou responsabilidade por parte desta. > >This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. The contents of this message and its attachments do not necessarily express the opinion or the intention of the company, and do not imply any legal obligation or responsibilities from this company.

Esta mensagem e seus anexos podem conter informações confidenciais ou privilegiadas. Se você não é o destinatário, não está autorizado a utilizar o material para qualquer fim. Solicitamos que você apague a mensagem e avise imediatamente o remetente. O conteúdo desta mensagem e seus anexos não representam necessariamente a opinião e a intenção da empresa, não implicando em qualquer obrigação ou responsabilidade por parte desta.

This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. The contents of this message and its attachments do not necessarily express the opinion or the intention of the company, and do not imply any legal obligation or responsibilities from this company.


Back to: Top of message | Previous page | Main SAS-L page