表格1怎么生成表格2？

code	date	int
1	20010102
1	20010103
1	20010105	0
1	20010106
2	20010102
2	20010103
2	20010104	0
2	20010105
2	20010106
2	20010107	0
2	20010108
2	20010109
code	date	int
1	20010102
1	20010103
1	20010105	0
1	20010106	1
2	20010102
2	20010103
2	20010104	0
2	20010105	1
2	20010106	2
2	20010107	0
2	20010108	1
2	20010109	2

向高手致敬！

1. data raw;
   
2.         infile datalines missover;
   
3.         input code date yymmdd8. int;
   
4.         format date yymmdd10.;
   
5. datalines;
   
6. 1 20010102
   
7. 1 20010103
   
8. 1 20010105 0
   
9. 1 20010106
   
10. 2 20010102
    
11. 2 20010103
    
12. 2 20010104 0
    
13. 2 20010105
    
14. 2 20010106
    
15. 2 20010107 0
    
16. 2 20010108
    
17. 2 20010109
    
18. ;
    
19. data out(drop=int rename=(temp=int));
    
20.         set raw;
    
21.         by code;
    
22.         if first.code then call missing(temp);
    
23.         temp=ifn(int=0,-1,temp);
    
24.         if not missing(temp) then temp+1;
    
25. run;

复制代码

？？？？？？

IFN Function介绍
Returns a numeric value based on whether an expression is true, false, or missing.

IFN(logical-expression, value-returned-when-true, value-returned-when-false <,value-returned-when-missing>)


MISSING Function
Returns a numeric result that indicates whether the argument contains a missing value.

Syntax

MISSING(numeric-expression | character-expression)

Arguments
numeric-expression specifies a numeric constant, variable, or expression.
character-expression specifies a character constant, variable, or expression.

CALL MISSING Routine
Assigns missing values to the specified character or numeric variables.

Syntax

CALL MISSING(varname1<, varname2, ...>);

Arguments

varname specifies the name of SAS character or numeric variables.

早上有一个相似的程序。

学习了ifn函数。