proc sql: can I "group by" a variable created in select procedure?

[xyxu]

Is the following procedure legitimate? Please note that variable month is generated by the procedure itself. I can run it without any error reported, but not sure if the results are perfectly what I want.

proc sql;
	create table want as 
	select name, intnx("month", date, 0, 'e') as month format yymmdd10.,  mean(var) as var_ave
	from have
	group by name, month 
	order by name, month;
quit;

[Shmuel]

You need use the descriptive word "calculated", Try

proc sql;
	create table want as 
	select name, intnx("month", date, 0, 'e') as month format yymmdd10.,  mean(var) as var_ave
	from have
	group by name, calculated month 
	order by name, calculated  month;
quit;

[xyxu]

It seems that the results do not change after adding it?

[Shmuel]

Please post sample of your input and its output to demonstrate where it should differ

[SASKiwi]

I suspect use of the keyword - calculated - is optional in your example as both versions work without error.

[ChrisNZ]

Since variable MONTH doesn't exist anywhere else, the keyword calculated can be omitted: it is obvious which MONTH you are referring to. Both queries yield the same result.

This calculated keyword is a powerful addition to ANSI SQL made by SAS.

Now if only SAS added other   useful     language    extensions     to SQL...