A dwarf is possessed, how can I find what he wants

I would suggest using a manager noble and the management screen (j, m) where you can queue up tasks. I find it useful to do thinks like:

• Queue 15 barrel
• Queue 15 brew drinks

And jobs that are managed are automatically re-assigned if they fail for any reason including lack of resources. So in this case the brew drinks would be re-assigned until the barrels are available to complete them.

Note that these tasks will process in parallel.

Firstly, do you have a hospital? If not, build one, even if it is just a bed somewhere random. (Your dining hall would actually be a pretty good place)

Even though you don't have any dwarfs that are trained in those skills, it doesn't mean they can't do them. It just means they'll suck. So pick a dwarf who isn't busy and activate the medical skills on him and deactivate all the rest. He should run and get the dwarf and carry him back to the hospital bed.

Make sure you have buckets and prepared meals. Wounded dwarfs who can't feed themselves need to be feed by other dwarfs. Buckets provide drinks, and prepared meals provide food. I think just any food can be given to a wounded dwarf, but I've always had the most luck with prepared meals.

Finally, wait. Either the dwarf you esoterically assigned to be a doctor will patch your dwarf back together (assuming you have a traction bench, cast powder, and crutches) or he'll keep him alive until a more skilled dwarf comes to save the day.