hi ... here are a couple alternatives to the already posted solutions ... data x; input date : date9. firm  share_outstanding ; datalines; 1jan85   1   2.2         2jan85   2   3.2                   3jan85   3   1                  1feb85   1   3                 2feb85   2   4        3feb85   3   5   ; proc sql; create table want as select date format=monyy., firm,  share_outstanding, mean(share_outstanding) as portmktcap from x group by put(date,monyy.) order by date; quit; and ... data have; input date port_no return liquidity; cards; 1985  1   2.5  3 1985  2   2.8  3.2 1985  3   2.3  3.4 1986  1   3.2  2.3 1986  2   3.5  2.1 1986  3   2.4  1.8 ; proc summary nway data=have (rename=(return=port_return liquidity=port_liquidity)); class date; output out=want (drop=_type_ _freq_) idgroup(out[3](port_return port_liquidity)=); run; ... View more

Thanks for support can we select the date insted of system date the report can be generated for any month the date should vary march to march ... View more

Hi linlin, I can't post my excel as its in my project linlin, but its the same where i have asked the question. Thanks ... View more

Do a googling on 'SAS Hash', you will find tons of sugi papers on this topic, that is at least how I started. Plus SAS online documentation and practice, you will have a taste of it before you know it. Regards, Haikuo ... View more

Thank you -- I did put the attributes cnd cndv cnddd on a separate line and it took it.  The 80 character position must have been the issue.  Thanks again.  ... View more

Some clarification ... Macro variables and SAS data variables are altogether different things. Examples of automatic variables: _N_ and _ERROR_ in the DATA step, _TYPE_ and _FREQ_ in PROC SUMMARY/MEANS. The items which S. listed are not automatic variables. Rather, they are shorthand notations which expand to be lists of zero or more variables (which are generally not automatic variables). In fact, _NUMERIC_ excludes automatic variables when it is expanded. sambasiva.ravuri@tcs.com wrote: Thanks for quick response Ballardw. I got some of Automatic Variables info and am just sharing for the same. _ALL_ Lists the values of all macro variables.specifies all variables that are currently defined in the current DATA step. _AUTOMATIC_ Lists the values of all automatic macro variables _USER_ Lists the values of all user-defined macro variables _NUMERIC_ specifies all numeric variables that are already defined in the current DATA step. _CHARACTER_ specifies all character variables that are currently defined in the current DATA step. Regards, S Ravuri. ... View more

$10. will be your date as character. you would not be able to do any date operations on this variable. However mmddyy10. is date which is numeric in nature. ... View more

PGStats Yes. I have understood what your code mean . I wonder why I can't realize so simple shortcut. It seems that Computer is not always better than human's brain.Anyway it is better than mine. Congratulations! Regards. Ksharp ... View more