If you use the implicit method you can use the name you give the connection in your join sections. If you use the pass through method, you have to use the schema name for the joins. Also if you are using pass through you have to be aware of what kind of database you are connecting to and which functions it supports. the SAS datetime function will not work in a POSTGRESQL passthrough but will work in a ORACLE passthrough, you would have to do something like "cret_dt::timestamp::date" instead of datetime(cret_dt) for POSTGRESQL. However in a implicit connection, you can use all of the SAS built-in functions since its not an instance in another database. Amazing video.
Excellent way of explanation Kiran. I was asked in an interview where the scenario is - to join Database table with SAS table. I said we can do it only by Libname statement. Correct me if i am wrong. Please continue this ETL series. That will help us - Vinod
Amazing video very helpful, sir please make a video on how to use execute in dbms (oracle) and if we want to join on a huge datamart then how to write a syntax which will give output using minimum time
Please make videos on SAS date function with Format and Informat because it is confusing and also on SAS array, how does array in SAS work exactly. Another topic is like extraction of data between defined dates from tables having a data of whole year depending on certain criteria eg. Campaign management.
@@kiranvenna thanks Kiran. Do you have any exposure on sas/Hadoop connectivity and I/O operation Between each other?? If yes I would really love to see/read that bcs it's my week point as of now.
time 14:24, data set, with "where' - isn't this only picking up data that qualifies where conditions? I don't think this data step will move 200Million records. It only moves data meeting where conditions. this is why where condition is more efficient than if condition. correct me if I'm wrong.
so when someone use Libname statement to access , there is chance that query is processed in SAS. if data has to be processed in SAS, it should temporarily first move all the data from database to SAS. The data is then processed in SAS and finally where clause in data step moves the data permanently to SAS. To conclude, whenever data is processed in SAS, data has to be there in SAS in this case temporarily. Hope I have clearly explained you.
I have pros and cons of implicit and explicit. actually those points make up the difference between two, some important differences are 1.Implicit you use libname, explicit you use a connect statement. 2. Implicit you write SAS code and explicit you need to write DBMS specific code.
If you use the implicit method you can use the name you give the connection in your join sections. If you use the pass through method, you have to use the schema name for the joins. Also if you are using pass through you have to be aware of what kind of database you are connecting to and which functions it supports. the SAS datetime function will not work in a POSTGRESQL passthrough but will work in a ORACLE passthrough, you would have to do something like "cret_dt::timestamp::date" instead of datetime(cret_dt) for POSTGRESQL. However in a implicit connection, you can use all of the SAS built-in functions since its not an instance in another database. Amazing video.
Thank you and correct observation.
Nice explanation with simple examples. Thank you so much.
Explanation is really nice...voice is clear..very useful..
Excellent way of explanation Kiran. I was asked in an interview where the scenario is - to join Database table with SAS table. I said we can do it only by Libname statement. Correct me if i am wrong. Please continue this ETL series. That will help us - Vinod
Your answer was correct
Amazing explanation with brief content.
Great tutorial
Nice examples!
Amazing video very helpful, sir please make a video on how to use execute in dbms (oracle) and if we want to join on a huge datamart then how to write a syntax which will give output using minimum time
very useful
Amazing video..I have one doubt in SQL pass through facility
Can you please elaborate more on what path we need to mention in connection string
Helpful..Thank you!
Great explanation sir
Thanks for liking
Hi can I get your contact number to discuss sas course details
Please make videos on SAS date function with Format and Informat because it is confusing and also on SAS array, how does array in SAS work exactly.
Another topic is like extraction of data between defined dates from tables having a data of whole year depending on certain criteria eg. Campaign management.
wish I had seen your videos earlier then could have cracked my interview yesterday. Alas! I failed.
There will be another interview and you will crack it. Good luck.
@@kiranvenna thanks Kiran. Do you have any exposure on sas/Hadoop connectivity and I/O operation Between each other?? If yes I would really love to see/read that bcs it's my week point as of now.
Thanks
Can we use SAS functions in the SQL query written for DBMS in explicit SQL passthrough? The Sql query written after 'conection to Oracle'
As you are connecting to oracle, you are no longer have access to SAS environment.
@@kiranvenna thanks 🙂
time 14:24, data set, with "where' - isn't this only picking up data that qualifies where conditions? I don't think this data step will move 200Million records. It only moves data meeting where conditions. this is why where condition is more efficient than if condition. correct me if I'm wrong.
so when someone use Libname statement to access , there is chance that query is processed in SAS. if data has to be processed in SAS, it should temporarily first move all the data from database to SAS. The data is then processed in SAS and finally where clause in data step moves the data permanently to SAS. To conclude, whenever data is processed in SAS, data has to be there in SAS in this case temporarily. Hope I have clearly explained you.
Not familiar with terafata would it be the same logic as sql server
Mostly similar but Teradata has some additional features.
So is this enough to become SAS ETL Developer? I already have sas base and advance certification, thank you!
this are just some important points, but there are lot more topics like knowledge of data warehousing.
@@kiranvenna for example? And what's the main difference between BI/analyst vs ETL developer? Thanks!
Bi people are more focused on reporting
sir is it possible to retain charecer variables
yes, you can.
How to check syntax error in SQL pass through (both)
You can do it with SASTRACE options. check this link out. support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a000433982.htm
@@kiranvenna Thank you so much ;)
What execute function here
executes the code in parenthesis by oracle
Diff b/w explicit and implicit pls give some points wise
I have pros and cons of implicit and explicit. actually those points make up the difference between two, some important differences are 1.Implicit you use libname, explicit you use a connect statement. 2. Implicit you write SAS code and explicit you need to write DBMS specific code.
@@kiranvenna
Thank u sir please make vedio on indexes in datastep and proc sql
Detailed
Thanks