First: please use some descriptive subjects than "proc sql". It would help to distinguish between your inquiries.
Second: what are you up to? Since you have severe more or less basic SQL questions I sugest that you take some formal training first, and then return to the forum more specific coding problems, or at least show the code you tried so far.
Data never sleeps