topic Re: count occurrences of of variable values and assign label to in SAS Programming

occurrences of of column values

RTelang — Wed, 21 Sep 2016 14:03:25 GMT

Hello am trying to write a code to see if the column column value counts are below a user-defined value then the value is replaced with a user defined value.

%macro Lfreq(indsn=,variable=);

proc freq data = &indsn;
tables &variable;
run;

%mend;
%Lfreq(indsn=myfile.freq2,variable=name);

Re: count occurrences of of variable values and assign label to

Astounding — Mon, 19 Sep 2016 11:29:19 GMT

What are you trying to replace? Replace the count that prints in the table? Or create a data set with the original variable being replaced?

Re: count occurrences of of variable values and assign label to

error_prone — Mon, 19 Sep 2016 11:30:21 GMT

Why do you want a macro?

Lables are attached to variables not values. You can use a format togehter with an output-procedure to mark counts below a threshold.

proc freq data=sashelp.class;
   tables Age / out=work.forum;
run;

%let threshold = 2;

proc format;
   value AgeCountMarker
      LOW - &threshold = 'yellow'
      %eval(&threshold + 1) - HIGH = 'lightgreen'
   ;
run;

proc print data=work.forum;
   var Age;
   var Count / style(column)={background=AgeCountMarker.};
run;

Re: count occurrences of of variable values and assign label to

RTelang — Wed, 21 Sep 2016 13:58:42 GMT

@Astounding i want to replace the value.

Re: count occurrences of of variable values and assign label to

RTelang — Wed, 21 Sep 2016 14:04:39 GMT

@error_prone want to check the occurrences of column variable values.

Re: count occurrences of of variable values and assign label to

Astounding — Mon, 19 Sep 2016 14:50:52 GMT

This doesn't show me what the outcome should be. You will need to provide an example of the results that you want.

Re: count occurrences of of variable values and assign label to

ballardw — Mon, 19 Sep 2016 14:59:27 GMT

Show some input data and expected results.

Re: count occurrences of of variable values and assign label to

RTelang — Wed, 21 Sep 2016 07:56:43 GMT

Re: count occurrences of of variable values and assign label to

Astounding — Mon, 19 Sep 2016 16:05:50 GMT

OK, that result is possible. It may cause some confusion later, after your values have been replaced. But it is possible. This example assumes you are dealing with a character variable:

%macro change_value (indsn=, variable=, outdsn=, label=, threshold=);

proc sort data=&indsn;

by &variable;

run;

proc freq data=&indsn;

tables &variable / noprint missing out=counts (keep=&variable count);

run;

data &outdsn;

merge &indsn counts;

by &variable;

if count <= &threshold then &variable="&label";

drop count;

run;

%mend change_value;

%change_value (indsn=have, variable=name, outdsn=want, label=PQ, threshold=2)

It's untested, but should be OK. Give it a shot we'll find out.

Re: count occurrences of of variable values and assign label to

Ksharp — Tue, 20 Sep 2016 03:04:15 GMT

data test;
input name$10.;
retain dummy ' ';
cards;
lily
lily
lily
kate
kate
sam
sam
sam
;
run;

proc sql;
create table want(drop=dummy) as
select *,case when(count(*) gt 2) then 'PQ' else name end as want length=40
 from test
  group by name;
quit;