SQl code in SAS

[Smitha9]

Hi,

I have a SQL code and I havent worked on SQL before.

Can I run the SQL code in SAS? Are there any rules to run?

[PaigeMiller]

You can run PROC SQL or PROC FEDSQL in SAS.

But your question is very vague. Can you please show us the code you have?

[Reeza]

Not necessarily. SQL isn't a single language and most SQL implementations have their own functions. Basic queries such as Select * will run fine in any system however, MS SQL creates tables using INTO for example, while many others use CREATE TABLE. 

So you will very likely need to do some code conversion.

SAS does offer SQL Pass through, where it takes your SQL code and passes it directly to a server though. In that case, it will run as is. 

---

@Smitha9 wrote:

Hi,

I have a SQL code and I havent worked on SQL before.

Can I run the SQL code in SAS? Are there any rules to run?

---

[tarheel13]

you can use proc sql. but it is important to note that proc sql isn't fully SAS and isn't fully SQL either.