I am not completely sure what you are asking here, but yes it is possible to raise a sinewave so that it is always above 0v but still a sine shape.
Have a look at my attached sketch.
You could also make the sinewave completely negative by reversing the diode.
There are limits to this technique,
there will be a little bit of offset about one diode drop (0.6v), which may not be a problem depending on what you want to use the signal for.
Also, if you want to use this signal as a clock for something, you will have to use something with a Schmitt circuit or a comparator as Eric has suggested in order to give a fast rise time to the clock. Otherwise you may get some strange effects due to noise and the slow risetime of the sinewave.