topic Re: first.variables in ODS and Base Reporting

first.variables

pkmkart — Fri, 30 Jan 2015 16:01:49 GMT

My data is like:

Id	year	month	response
100131	2014	3	0
100131	2014	3	1
100131	2014	4	0
100131	2014	4	0
100131	2014	5	0
100131	2014	5	0
100131	2014	5	0
100131	2014	5	0
100131	2014	5	0
100131	2014	5	0
100131	2014	5	1
100131	2014	5	1
100131	2014	5	1
100131	2014	5	1
100131	2014	5	1

I want to count the number of 0 response and number of 1 response for each month. i have sorted the data by id year month and response.

the output must be the following:

id	year	month	response	count
100131	2014	3	0	1
100131	2014	3	1	1
100131	2014	4	0	2
100131	2014	5	0	6
100131	2014	5	1	5

the code i have used is :

data step......

......

...

if first.month and first.response then count=0;

count+1;

if last.response then output;

but i am not getting the expected output..

please help me in fixing this.

thanks in advance..

Re: first.variables

data_null__ — Fri, 30 Jan 2015 16:12:49 GMT

Where is variable RESULT?

Without a variable RESULT in a BY statement there can be no FIRST.RESULT or LAST.RESULT

Re: first.variables

ballardw — Fri, 30 Jan 2015 16:15:55 GMT

proc freq data=have;

tables id*year*month*response/ list nopercent nocum;

run;

if you want a dataset as well add OUT=newdatasetname after the / above.

Re: first.variables

pkmkart — Fri, 30 Jan 2015 16:27:42 GMT

sorry it is the 'response' I have unknowingly written as result. may be the code goes like this;

if first.month and first.response then count=0;

count+1;

if last.response then output;

Re: first.variables

pkmkart — Fri, 30 Jan 2015 16:32:00 GMT

I got the same result in proc freq using similar code like urs. but I wanted to try in datastep if possible.

Re: first.variables

data_null__ — Fri, 30 Jan 2015 16:38:59 GMT

Leave off FIRST.MONTH from the first IF.

Re: first.variables

pkmkart — Fri, 30 Jan 2015 16:44:56 GMT

the problem with my data is that, not all the id will have 0 and 1 some times the value is only 0 for all the month, so during that time the 0 will be counted despite the month change. but what I want is the response count for each month when it is 0 and 1.. so i cannot omit the first.month

Re: first.variables

data_null__ — Fri, 30 Jan 2015 17:11:15 GMT

data response;
   input  id year month response;
   cards; 
100131
2014
3
0
100131
2014
3
1
100131
2014
4
0
100131
2014
4
0
100131
2014
5
0
100131
2014
5
0
100131
2014
5
0
100131
2014
5
0
100131
2014
5
0
100131
2014
5
0
100131
2014
5
1
100131
2014
5
1
100131
2014
5
1
100131
2014
5
1
100131
2014
5
1
;;;;
   run; 
proc print; 
   run; 
data counts;
   set response;
   by id month;
   array c[0:1] _temporary_; 
   if first.month then do; c[0]=0; c[1]=0; end; 
   c[response]+1; 
   if last.month then do; 
      do response=0,1; 
         count = c[response];
         output; 
         end; 
      end; 
   run; 
proc print; 
   run;