ViewTube

Info

Hello, my name is Dhruba. My channel encompasses all the challenging as well as basic questions I have come across in my career as a Data Scientist in the Financial Sector. My videos will cover interview questions primarily for SAS, SQL and Python. I am looking forward to sharing more content. Feel free to contact me if you have specific questions.

Stats

Joined Invalid Date

0 total views

Featured video

Channel Introduction

SAS Solutions

442 views

2 years ago

SAS Fundamentals

01. What are the data types in SAS? || SAS Interview Question and Solution.

01. What are the data types in SAS? || SAS Interview Question and Solution.

1,521 views

2 years ago

02. How do you copy SAS dataset to a new SAS Dataset? || SAS Interview Question and Solution.

02. How do you copy SAS dataset to a new SAS Dataset? || SAS Interview Question and Solution.

923 views

2 years ago

03. What is the difference between single and multiple set statements || SAS Interview Q/A.

03. What is the difference between single and multiple set statements || SAS Interview Q/A.

904 views

2 years ago

04. What are the differences between data step and proc step in SAS? || SAS Interview Q/A.

04. What are the differences between data step and proc step in SAS? || SAS Interview Q/A.

965 views

2 years ago

05. What do you mean by Informat and Format statement in SAS? || SAS Interview Question and Answer.

05. What do you mean by Informat and Format statement in SAS? || SAS Interview Question and Answer.

673 views

2 years ago

06. How to print specific number of records from a dataset? || SAS Interview Question and Answer.

06. How to print specific number of records from a dataset? || SAS Interview Question and Answer.

641 views

2 years ago

07. How do you rename existing SAS dataset name || SAS Interview Question and Solution.

07. How do you rename existing SAS dataset name || SAS Interview Question and Solution.

683 views

2 years ago

08. If no variables length are specified in a SAS program, what will be the default length? || SAS.

08. If no variables length are specified in a SAS program, what will be the default length? || SAS.

577 views

2 years ago

09. What do you mean by PDV(Program Data Vector)? || SAS Interview Question and Answer.

09. What do you mean by PDV(Program Data Vector)? || SAS Interview Question and Answer.

726 views

2 years ago

10. While subsetting data using WHERE and IF statement, which one is more efficient and why? || SAS.

10. While subsetting data using WHERE and IF statement, which one is more efficient and why? || SAS.

505 views

2 years ago

11. Which statement (Where or If) can be applied on temporary variable and why? || SAS Interview Q/A

11. Which statement (Where or If) can be applied on temporary variable and why? || SAS Interview Q/A

467 views

2 years ago

12. How do you check if there are duplicate records present in a SAS dataset? || SAS Interview Q/A.

12. How do you check if there are duplicate records present in a SAS dataset? || SAS Interview Q/A.

574 views

2 years ago

14. What are the commonly used character function in SAS? || SAS Interview Question and Answer.

14. What are the commonly used character function in SAS? || SAS Interview Question and Answer.

517 views

2 years ago

15. How do you remove unwanted special character from customer name ? || SAS Interview Q/A.

15. How do you remove unwanted special character from customer name ? || SAS Interview Q/A.

551 views

2 years ago

16. How to convert character variable to numeric variable in SAS ? || SAS Interview Q/A.

16. How to convert character variable to numeric variable in SAS ? || SAS Interview Q/A.

818 views

2 years ago

17. How to convert numeric variable to character variable in SAS? || SAS Interview Q/A.

17. How to convert numeric variable to character variable in SAS? || SAS Interview Q/A.

473 views

2 years ago

18. What are the commonly used numeric function in SAS ? || SAS Interview Question and Answer.

18. What are the commonly used numeric function in SAS ? || SAS Interview Question and Answer.

342 views

2 years ago

19. What are the commonly used Date function in SAS? || SAS Interview Question and Answer.

19. What are the commonly used Date function in SAS? || SAS Interview Question and Answer.

319 views

2 years ago

20. How can you pull four characters starting from third position of the given character variable?

20. How can you pull four characters starting from third position of the given character variable?

332 views

2 years ago

21. How can you create first and last name column separately from customer's full name? || SAS - Q/A

21. How can you create first and last name column separately from customer's full name? || SAS - Q/A

443 views

2 years ago

22. How can you save odd and even records of a dataset separately in SAS? || SAS Interview Q/A.

22. How can you save odd and even records of a dataset separately in SAS? || SAS Interview Q/A.

374 views

2 years ago

23. How can you extract last five characters from a character Variable? || SAS Interview Q/A.

23. How can you extract last five characters from a character Variable? || SAS Interview Q/A.

308 views

2 years ago

24. Due to covid, loan pay date extended by 18 month. How do you apply extension to every customer ?

24. Due to covid, loan pay date extended by 18 month. How do you apply extension to every customer ?

287 views

2 years ago

SAS Functions Series[Character, Numeric and Date] || SAS Interview Question and Answer

SAS Functions Series[Character, Numeric and Date] || SAS Interview Question and Answer

274 views

1 year ago

55:What do you mean by Indexes? Why and how do you create? || SQL Interview Question And Answer.

55:What do you mean by Indexes? Why and how do you create? || SQL Interview Question And Answer.

47 views

2 months ago

54:What do you mean by sequences? Why and how do you create? || SQL Interview Question and Answer.

54:What do you mean by sequences? Why and how do you create? || SQL Interview Question and Answer.

96 views

2 months ago

53: What is inline view and why do we use it? || SQL Interview Questionand Answer.

53: What is inline view and why do we use it? || SQL Interview Questionand Answer.

117 views

3 months ago

52: What do you mean by complex views? Why and how do you create? || SQL Interview Question & Answer

52: What do you mean by complex views? Why and how do you create? || SQL Interview Question & Answer

161 views

4 months ago

51: What do you mean by simple views? Why and how do you create? || SQL Interview Question & Answer.

51: What do you mean by simple views? Why and how do you create? || SQL Interview Question & Answer.

193 views

4 months ago

50:What are schema objects? Give some examples that are included by schema objects||SQL Interview QA

50:What are schema objects? Give some examples that are included by schema objects||SQL Interview QA

201 views

5 months ago

49:How does MINUS or EXCEPT operator work in SQL? Give a suitable example. || SQL Interview Q/A

49:How does MINUS or EXCEPT operator work in SQL? Give a suitable example. || SQL Interview Q/A

106 views

6 months ago

48:How does INTERSECT operator work in SQL? Give a suitable example. || SQL Interview Q/A.

48:How does INTERSECT operator work in SQL? Give a suitable example. || SQL Interview Q/A.

65 views

6 months ago

47:How does UNION ALL operator work in SQL? Give a suitable example. || SQL Interview Q/A.

47:How does UNION ALL operator work in SQL? Give a suitable example. || SQL Interview Q/A.

87 views

6 months ago

46:How does UNION operator work in SQL? Give a suitable example. || SQL Interview Question & Answer.

46:How does UNION operator work in SQL? Give a suitable example. || SQL Interview Question & Answer.

134 views

6 months ago

45:What are set operators in SQL? What are they and how does they work? || SQL Interview Q/A.

45:What are set operators in SQL? What are they and how does they work? || SQL Interview Q/A.

98 views

6 months ago

44:By using Orders & Customers tables create a report for all customers who have never placed order.

44:By using Orders & Customers tables create a report for all customers who have never placed order.

105 views

7 months ago