topic Re: SAS Macro for top 10 and last 10 values for variable in SAS Programming

SAS Macro for top 10 and last 10 values for variable

deepankeranand — Mon, 22 Aug 2016 21:40:34 GMT

Hi Everyone,

I require a sas macro for returning:

top 10 and last 10 values of a numeric variable (Assume variable is not sorted).
alphabetically top 10 and last 10 values of a character variable

Thanks

Regards,

Re: SAS Macro for top 10 and last 10 values for variable

Reeza — Mon, 22 Aug 2016 21:42:08 GMT

Why a macro?

What have you tried so far?

Re: SAS Macro for top 10 and last 10 values for variable

ballardw — Mon, 22 Aug 2016 22:29:44 GMT

What do you return if there are fewer than total observations?

Do missing or blank values get included?

Can the top 10 and bottom 10 overlap (fewer than 20 observations);

Define "top": largest (problematic for character) most frequent, alphabetic order(probematical for numeric).

Re: SAS Macro for top 10 and last 10 values for variable

Ksharp — Tue, 23 Aug 2016 03:18:26 GMT

%macro top_end(data=sashelp.cars , var=make);
data want;
 set &data(keep=&var) nobs=nobs;
 if _n_ le 10 or 
    _n_ =nobs-9 or 
    _n_ =nobs-8 or
    _n_ =nobs-7 or
    _n_ =nobs-6 or
    _n_ =nobs-5 or
    _n_ =nobs-4 or
    _n_ =nobs-3 or
    _n_ =nobs-2 or
    _n_ =nobs-1 or
    _n_ =nobs ;
run;
proc print noobs;run;
%mend;

%top_end()

Re: SAS Macro for top 10 and last 10 values for variable

deepankeranand — Thu, 15 Sep 2016 05:12:00 GMT

Hi Xia,

Your macro gives us top 10 and bottom 10 values of a variable. Just three more enhancements:

1. Please can you add another option in the macro to make the n top and bottom values needed. for eg: for n=20, n=5, n=15, etc.

2. If there are missing values, delete the missing values.

3. Add the n% percentage option, for eg: pick top 10% and bottom 10% of values.

Thanks

Regards,

Re: SAS Macro for top 10 and last 10 values for variable

Reeza — Thu, 15 Sep 2016 05:17:31 GMT

@deepankeranand wrote:

Hi Xia,

Your macro gives us top 10 and bottom 10 values of a variable. Just three more enhancements:

1. Please can you add another option in the macro to make the n top and bottom values needed. for eg: for n=20, n=5, n=15, etc.

2. If there are missing values, delete the missing values.

3. Add the n% percentage option, for eg: pick top 10% and bottom 10% of values.

Thanks

Regards,

Please try something, post what you've tried and what isn't working.

As phrased this isn't a request for help its a 'do my work'. If you need this type of service consider hiring a consultant.

Re: SAS Macro for top 10 and last 10 values for variable

Ksharp — Thu, 15 Sep 2016 09:36:38 GMT

As Reeza pointed out. Will you pay me some money ?


%macro top_end(data=sashelp.air , var=date,n=10,percent=);
%if %length(&percent) %then %do;
 %let dsid=%sysfunc(open(&data));
 %let nobs=%sysfunc(attrn(&dsid,nlobs));
 %let dsid=%sysfunc(close(&dsid));
 %let n=%sysevalf(&nobs*&percent,i);
%end;
data want;
 set &data(keep=&var) nobs=nobs;
 if _n_ le &n or 
    _n_ ge nobs-&n+1 ;
run;
proc print noobs;run;
%mend;

%top_end()
%top_end(percent=0.1)