Thanks, I found the solution with some help from my friends :))
I did it this way:
data m.gender;
set cesgrdb2.Eben_out_vw (keep= created_date gender);
gender1=put(gender,1.); /*we specify the format and length of a new variable*/
run;
data m.gender1;
set m.gender;
if gender=1 then gender1='F';
if gender=2 then gender1='M';
run; *it works*;
data m.gender_year;
set Tmp1.gender1;
year=datepart(created_date);
format year date9.;
run;
data m.gender_year1;
set m.gender_year;
date=year(year);
run; */to get year in the table*/;
proc freq data=m.gender_year1;
Tables Date Gender1 /*it would be better to get a table the other way - Gender1*Date*/
Date*Gender1;
where date>=2002 and date<=2007;
run;*it works*;
... View more