Does sand absorb water?

Yes sand will absorb a small quantity of water. It is extremely small compared to the other soil particles (silt and clay). You can look for the Water Retention Curve for the specifics of the amounts of water that can be held by sand.