Can converting a proc sql code in sas make some difference .My concern is time
as I have a long code in proc sql it takes more than half an hour to run.
if not how can I save my time?
Maaz,
As the whole program is SQL, why can't you recode it to run completely inside Teradata? Teradata is designed to run SQL efficiently, so why not let it get on with it.
Currently you are doing the following using PROC SQL:
Doing the same steps all in Teradata using Pass-Thru will take SAS out the equation altogether.
What does your code look like?
Without seeing any code its hard to say. Certainly in some circumstances SQL can be more resource intensive than a datastep or procedure variety. There are also other options however which may speed things up, for instance filtering data earlier so you only take in the rows you need, indexing data etc. Its quite hard to say though without any information.
Try the advice given in
before considering converting to a SAS program.
th
this is a small sample of code like this I have to run many more code which are more lenthy than this . the data is in Teradata and creating the table in tera data as well
Maaz,
As the whole program is SQL, why can't you recode it to run completely inside Teradata? Teradata is designed to run SQL efficiently, so why not let it get on with it.
Currently you are doing the following using PROC SQL:
Doing the same steps all in Teradata using Pass-Thru will take SAS out the equation altogether.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.