Тёмный

SQL Interview Questions and Answers Part -3 | Proc SQL 

SAS World
Подписаться 3,4 тыс.
Просмотров 1,4 тыс.
50% 1

SQL Interview Questions and Answers Part -3 | Proc SQL
This Video contains Interview questions on Proc SQL.
Key Questions:
Time Topics
MM:SS
00:28 Data step merge and Proc SQL join which one is better?
05:00 What is Cartesian Product?
09:29 Write a query to display cartesian product as output?
09:52 How to limit numbers of rows in proc SQL display?
12:11 How to check if a Complex Proc SQL query has no syntax errorsd?
Contact details:
officialsasworld@gmail.com

Опубликовано:

 

7 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 10   
@rajuyadav-kt1xz
@rajuyadav-kt1xz Год назад
Nice. Keep it up.
@AshokKumar.6767
@AshokKumar.6767 Год назад
Nice
@bhupenderyadav2167
@bhupenderyadav2167 Год назад
Suprabbb 👍👍
@sasworld2021
@sasworld2021 Год назад
Thanks Bhupender.
@ramanyadav9034
@ramanyadav9034 Год назад
Good explanation, please make a video on set operators.
@_MANI_5
@_MANI_5 Год назад
Does sas can access bigdata or multiple pdf files at one time? In sas via joins can we join from multiple data to particular rows or fileds at one time?
@sasworld2021
@sasworld2021 Год назад
Yes, you can work with Big data. Also joins do the job of joining multiple rows from multiple datasets into one row.
@asm_adam
@asm_adam Год назад
In the video u have mentioned about "ETL,native SQL".Could u please explain about it in brief.does that mean another way to write in PROC SQL.Please explain.Tq.
@sasworld2021
@sasworld2021 Год назад
I have already created a video on explicit pass through, please follow the link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-k8FSNtZgP84.html
@asm_adam
@asm_adam Год назад
@@sasworld2021 Thanks for the reply.I will go through it.