SQL SELECT allows for creation of new field names using AS clause, as in

select fieldname as newfieldname

This works easily when the newfieldname is know when the code is written, but how can we cause the newfieldname to be a variable as in

newfieldname = "newname"
select fieldname into &newfieldname

All my attempts at macro substitution or other techniques have failed.
Is my objective possible?

Thanks for any help.

- Don