topic Re: SQl code in SAS in New SAS User

SQl code in SAS

Smitha9 — Wed, 15 Jun 2022 17:03:51 GMT

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?

Re: SQl code in SAS

PaigeMiller — Wed, 15 Jun 2022 17:08:58 GMT

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?

Re: SQl code in SAS

Reeza — Wed, 15 Jun 2022 17:21:33 GMT

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?

Re: SQl code in SAS

tarheel13 — Thu, 16 Jun 2022 11:45:21 GMT

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