What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 131 Stack Exchange communities.

The Proc*C embedded C language extends Oracle databases.

The PROC SQL language queries SAS data.

For some reason, the SO tag covers Proc*C instead of PROC SQL.

I'm no expert on either technology, but it seems to me that a Proc*C tag should be created. That would open up the PROC-SQL tag for SAS questions.

P.S. This meta question is a response to this SO question.

share|improve this question
    
The embedded SQL pre-processor by Oracle is called Pro*C and not Proc*C! –  maxschlepzig Sep 14 '13 at 9:42

2 Answers 2

up vote 2 down vote accepted

AFAIK, the proc-sql tag has been used pretty much exclusively for SAS questions since it was first introduced. Also, a large % of SAS questions do indeed relate to the 'sql procedure' (proc sql;)

So I'm going with the following 'answer' - YES, the proc-sql tag IS incorrectly used with Pro*C!

share|improve this answer
    
In that case, it's perhaps the tag wiki that is wrong –  Andomar Aug 6 '13 at 19:29
    
agreed, and I have proposed an update - which is awaiting review –  RawFocus Aug 6 '13 at 19:29
    
Any way I could find your edit? When I search the review queue, it says: There are no items for you to review, matching the filter "[proc-sql]" –  Andomar Aug 6 '13 at 19:33
    
Hmm - I only did it earlier today, must have disappeared! Have submitted a more detailed description now.. –  RawFocus Aug 6 '13 at 19:44
2  
Approved your tag edit, and created a new proc-c tag! If you find time to enrich the proc-sql tag with some example code and a link to SAS documentation that would be great. –  Andomar Aug 6 '13 at 19:48
    
Code examples and documentation links added :-) –  RawFocus Aug 6 '13 at 19:57

The embedded sql pre-processor by Oracle is called Pro*C and NOT Proc*C.

Thus, it is just plain wrong to introduce proc-c as new tag for Pro*C.

Unfortunately, the proc-c tag was already created - but no questions are tagged with it. It should be removed for the stated reasons.

Currently, there are 49 questions tagged with proc-sql and oracle.

On the other hand there are 45 questions tagged with proc-sql and sas.

Thus, the proc-sql tag is NOT exclusively used for SAS questions.

Looking at the revision history of the tag proc-sql the description is only about SAS usage - but when browsing the tag wiki, the old Oracle Pro*C info is displayed. Probably because of suggested edits.

A better alternative to resolve the proc-sql mess:

  • introduce a new tag pro-c for Oracle Pro*C related questions (proc is already used for a Ruby construct of the same name, but pro-c is currently not in use)

Anyway, when doing such changes, the one doing them should also be responsible for migrating all the old Pro*C questions!

share|improve this answer
1  
[pro-c] cannot be introduced, clashes with [proc]. I created [oracle-pro-c] and started retagging. –  Mat Sep 14 '13 at 9:58

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .