SAS Solutions
SAS Solutions
  • 93
  • 24 341
What happens when proc SQL processes a summary function without a group by clause ||SAS Interview QA
In this video, we discuss what happens when proc SQL processes a summary function without a group by clause.
Without group by clause for sum function, it displays all rows, and each row shows total record count. With group by clause, it displays summary statistics of grouping variable.
@SASInsights: yt.sassolutions@gmail.com
Presented by: Dhruba Joshi
zhlédnutí: 81

Video

How do you count non missing and missing record count for categorical variables || SAS Interview Q/A5:59How do you count non missing and missing record count for categorical variables || SAS Interview Q/A
How do you count non missing and missing record count for categorical variables || SAS Interview Q/A
zhlédnutí 76Před dnem
In this video, we discuss how to get non missing and missing record count for categorical variables. Non missing and missing categorical variable can be obtained by using proc freq procedure by providing missing option with table statement. @SASInsights: yt.sassolutions@gmail.com Presented by: Dhruba Joshi
How do you get selected statistics, missing, and most repeated value for numeric variables || SAS QA5:54How do you get selected statistics, missing, and most repeated value for numeric variables || SAS QA
How do you get selected statistics, missing, and most repeated value for numeric variables || SAS QA
zhlédnutí 162Před 21 dnem
In this video, we discuss how to get selected statistics, missing, and most repeated value for numeric variable from a given dataset. @SASInsights: yt.sassolutions@gmail.com Presented by: Dhruba Joshi
What are the differences between proc means and proc summary || SAS Interview Question And Answer7:55What are the differences between proc means and proc summary || SAS Interview Question And Answer
What are the differences between proc means and proc summary || SAS Interview Question And Answer
zhlédnutí 153Před měsícem
In this video, we discuss difference between proc means and proc summary procedure. @SASInsights: yt.sassolutions@gmail.com Presented by: Dhruba Joshi
What are the default statistics that Proc means procedure produce || SAS. interview Q/A7:07What are the default statistics that Proc means procedure produce || SAS. interview Q/A
What are the default statistics that Proc means procedure produce || SAS. interview Q/A
zhlédnutí 138Před měsícem
In this video, we discuss proc means procedure with default statistics and groupwise. statistics by using BY statement @SASInsights: yt.sassolutions@gmail.com Presented by: Dhruba Joshi
How do you transpose given specific variable from column to row || SAS Interview Question & Answer6:24How do you transpose given specific variable from column to row || SAS Interview Question & Answer
How do you transpose given specific variable from column to row || SAS Interview Question & Answer
zhlédnutí 142Před měsícem
In this video, we discuss proc transpose procedure with var statement and its application. @SASInsights: yt.sassolutions@gmail.com Presented by: Dhruba Joshi
How does ID Statement work while transposing data || SAS Interview Question and Answer6:08How does ID Statement work while transposing data || SAS Interview Question and Answer
How does ID Statement work while transposing data || SAS Interview Question and Answer
zhlédnutí 176Před 2 měsíci
In this video, we discuss proc transpose procedure with ID statement and its application. @SASInsights: yt.sassolutions@gmail.com Presented by: Dhruba Joshi
How do you reshape data structure from vertical to horizontal & vice versa || SAS INTERVIEW Q/A10:14How do you reshape data structure from vertical to horizontal & vice versa || SAS INTERVIEW Q/A
How do you reshape data structure from vertical to horizontal & vice versa || SAS INTERVIEW Q/A
zhlédnutí 197Před 2 měsíci
In this video, we discuss use of a sample proc transpose procedure where one record per id has changed multiple records per id and vice versa. @SASInsights: yt.sassolutions@gmail.com Presented by: Dhruba Joshi
How does except operator work with proc sql || SAS Interview Question And Answer4:51How does except operator work with proc sql || SAS Interview Question And Answer
How does except operator work with proc sql || SAS Interview Question And Answer
zhlédnutí 123Před 2 měsíci
In this video, we discuss how to combine two or more similar tables vertically so that we. get records exist in first table which do not exist in. second table. Except operator is used to get records from the one table which do not exist in another table. In this example we are going to pull all the records exist in dataset one which do not exist in dataset two. czcams.com/video/oGfI1XWUWHs/vid...
How does union all operator work with proc sql || SAS Interview Question and Answer4:41How does union all operator work with proc sql || SAS Interview Question and Answer
How does union all operator work with proc sql || SAS Interview Question and Answer
zhlédnutí 114Před 2 měsíci
In this video, we discuss how to combine two or more similar tables vertically with duplicate records(Keeping all duplicate records). Union all operator is used to join two or more tables vertically by column position not by column name, so common column in each select statement must be in the same order. It joins table vertically keeping all duplicate records. czcams.com/video/1eJl6ODe-jY/vide...
How does union operator work in proc sql/How to Join two tables vertically without duplicate rcs?4:48How does union operator work in proc sql/How to Join two tables vertically without duplicate rcs?
How does union operator work in proc sql/How to Join two tables vertically without duplicate rcs?
zhlédnutí 97Před 2 měsíci
In this video, we discuss how to combine two or more similar tables vertically without getting duplicate records(Removing duplicate records). Union operator is used to join two or more tables vertically by column position not by column name, so common column in each select statement must be in the same order. It joins table vertically removing duplicate records. @SASInsights: yt.sassolutions@gm...
How do you use data step merge to get same result as full join (from proc sql) || SAS Interview Q/A9:29How do you use data step merge to get same result as full join (from proc sql) || SAS Interview Q/A
How do you use data step merge to get same result as full join (from proc sql) || SAS Interview Q/A
zhlédnutí 81Před 2 měsíci
In this video, we discuss how to use data step merge to get same result as full join from proc sql. Employee and Department are two source table. It will produce same result from full join (Proc SQL) and Data step merge (A and B with IN option). How do you use data step merge to get same result as right join (from proc sql) || SAS Interview Q/A: czcams.com/video/vQjjMrkqJsA/video.html @SASInsig...
How do you use data step merge to get same result as right join (from proc sql) SAS Interview Q/A9:06How do you use data step merge to get same result as right join (from proc sql) SAS Interview Q/A
How do you use data step merge to get same result as right join (from proc sql) SAS Interview Q/A
zhlédnutí 123Před 3 měsíci
In this video, we discuss how to use data step merge to get same result as right join from proc sql. Employee and Department are two source table. It will produce same result from left join (Proc SQL) and Data step merge (If A and B with IN option). How do you use data step merge to get same result as left join (from proc sql) || SAS Interview Q/A: czcams.com/video/5i1IiR5VV9c/video.html @SASIn...
SAS Top 80 Interview Question and Answer:Part 2: Q31 - Q61 || SAS Interview Question And Answer0:39SAS Top 80 Interview Question and Answer:Part 2: Q31 - Q61 || SAS Interview Question And Answer
SAS Top 80 Interview Question and Answer:Part 2: Q31 - Q61 || SAS Interview Question And Answer
zhlédnutí 134Před 3 měsíci
SAS Q/A -Part 2:Q31-Q61: Video link: How do you create a report showing all name starting with ‘A’ followed by any four characters?: czcams.com/video/N6qkIYHMR7o/video.html What do you mean by subquery or inner query in proc SQL?: czcams.com/video/xZlgogGRigQ/video.html What are the different types of join used in proc SQL?: czcams.com/video/CrxnPcOU8iE/video.html How do you get manager's name ...
SAS Top 80 Interview Question and Answer:Part 1: Q01 - Q30 || SAS Interview Question and Answer0:36SAS Top 80 Interview Question and Answer:Part 1: Q01 - Q30 || SAS Interview Question and Answer
SAS Top 80 Interview Question and Answer:Part 1: Q01 - Q30 || SAS Interview Question and Answer
zhlédnutí 186Před 3 měsíci
SAS Top 80 Interview Question and Answer:Part 1: Q01 - Q30 |Video link: What are the data types in SAS?: czcams.com/video/_LdJSFDeHWQ/video.html How do you copy SAS dataset to a new SAS Dataset?: czcams.com/video/six1SLyy6kY/video.html What is the difference between single and multiple set statement?: czcams.com/video/LoWwtI-diXE/video.html What are the differences between data step and proc st...
How do you use data step merge to get same result as left join (from proc sql) || SAS Interview Q/A8:29How do you use data step merge to get same result as left join (from proc sql) || SAS Interview Q/A
How do you use data step merge to get same result as left join (from proc sql) || SAS Interview Q/A
zhlédnutí 190Před 3 měsíci
How do you use data step merge to get same result as left join (from proc sql) || SAS Interview Q/A
How do you use data step merge to get same result as inner join from--proc sql || SAS Interview Q/A11:45How do you use data step merge to get same result as inner join from--proc sql || SAS Interview Q/A
How do you use data step merge to get same result as inner join from--proc sql || SAS Interview Q/A
zhlédnutí 141Před 3 měsíci
How do you use data step merge to get same result as inner join from proc sql || SAS Interview Q/A
What are the differences between Join and Merge in SAS? Which one is more efficient || SAS Q/A5:30What are the differences between Join and Merge in SAS? Which one is more efficient || SAS Q/A
What are the differences between Join and Merge in SAS? Which one is more efficient || SAS Q/A
zhlédnutí 193Před 3 měsíci
What are the differences between Join and Merge in SAS? Which one is more efficient || SAS Q/A
What is the best approach to replace all missing character variable value by the word ‘Miss’ in SAS?11:54What is the best approach to replace all missing character variable value by the word ‘Miss’ in SAS?
What is the best approach to replace all missing character variable value by the word ‘Miss’ in SAS?
zhlédnutí 210Před 3 měsíci
What is the best approach to replace all missing character variable value by the word ‘Miss’ in SAS?
What is SAS Array and why do we use it? || SAS Interview Question and Answer7:09What is SAS Array and why do we use it? || SAS Interview Question and Answer
What is SAS Array and why do we use it? || SAS Interview Question and Answer
zhlédnutí 157Před 3 měsíci
What is SAS Array and why do we use it? || SAS Interview Question and Answer
How can you save distinct and duplicated records by a variable into two different datasets || SAS QA8:55How can you save distinct and duplicated records by a variable into two different datasets || SAS QA
How can you save distinct and duplicated records by a variable into two different datasets || SAS QA
zhlédnutí 190Před 3 měsíci
How can you save distinct and duplicated records by a variable into two different datasets || SAS QA
How can you create report having groupwise customers name separated by comma || SAS Interview Q/A7:31How can you create report having groupwise customers name separated by comma || SAS Interview Q/A
How can you create report having groupwise customers name separated by comma || SAS Interview Q/A
zhlédnutí 281Před 3 měsíci
How can you create report having groupwise customers name separated by comma || SAS Interview Q/A
How do you extract records having max and min salary from each department || SAS Interview Q/A7:30How do you extract records having max and min salary from each department || SAS Interview Q/A
How do you extract records having max and min salary from each department || SAS Interview Q/A
zhlédnutí 272Před 3 měsíci
How do you extract records having max and min salary from each department || SAS Interview Q/A
How do you remove duplicate records from a SAS dataset || SAS Interview Question and Answer13:43How do you remove duplicate records from a SAS dataset || SAS Interview Question and Answer
How do you remove duplicate records from a SAS dataset || SAS Interview Question and Answer
zhlédnutí 382Před 3 měsíci
How do you remove duplicate records from a SAS dataset || SAS Interview Question and Answer
SAS MACROS and Application || SAS Interview Question and Answer2:24:49SAS MACROS and Application || SAS Interview Question and Answer
SAS MACROS and Application || SAS Interview Question and Answer
zhlédnutí 244Před 3 měsíci
SAS MACROS and Application || SAS Interview Question and Answer
SAS DATA Import & Export || SAS Interview Question and Answer54:34SAS DATA Import & Export || SAS Interview Question and Answer
SAS DATA Import & Export || SAS Interview Question and Answer
zhlédnutí 153Před 4 měsíci
SAS DATA Import & Export || SAS Interview Question and Answer
SQL in SAS - Proc SQL || SAS Interview Question and Answer51:32SQL in SAS - Proc SQL || SAS Interview Question and Answer
SQL in SAS - Proc SQL || SAS Interview Question and Answer
zhlédnutí 455Před 4 měsíci
SQL in SAS - Proc SQL || SAS Interview Question and Answer
SAS Functions(Character, Numeric and Date) || SAS Interview Question and Answer38:49SAS Functions(Character, Numeric and Date) || SAS Interview Question and Answer
SAS Functions(Character, Numeric and Date) || SAS Interview Question and Answer
zhlédnutí 142Před 4 měsíci
SAS Functions(Character, Numeric and Date) || SAS Interview Question and Answer
SAS Fundamentals one || SAS Interview Question and Answer47:02SAS Fundamentals one || SAS Interview Question and Answer
SAS Fundamentals one || SAS Interview Question and Answer
zhlédnutí 199Před 4 měsíci
SAS Fundamentals one || SAS Interview Question and Answer
How to export categorical data in to a single excel worksheet with the category into different tab ?14:59How to export categorical data in to a single excel worksheet with the category into different tab ?
How to export categorical data in to a single excel worksheet with the category into different tab ?
zhlédnutí 205Před 4 měsíci
How to export categorical data in to a single excel worksheet with the category into different tab ?

Komentáře

  • @vipulkaushik2294
    @vipulkaushik2294 Před 2 měsíci

    Thank u sir ❣️

  • @vipulkaushik2294
    @vipulkaushik2294 Před 2 měsíci

    Sir ek series proc transpose p bna dijiye🙏🙏

    • @SASInsights
      @SASInsights Před 2 měsíci

      Hi Vipul, Thanks for your request. Please find procedure series: It will cover some of procedure step related questions. czcams.com/video/MqXJgk0qTt8/video.html

  • @vipulkaushik2294
    @vipulkaushik2294 Před 2 měsíci

    Thank you sir

  • @vipulkaushik2294
    @vipulkaushik2294 Před 2 měsíci

    Thank you sir

  • @vipulkaushik2294
    @vipulkaushik2294 Před 2 měsíci

    Nice sir...please make que on proc transpose 🙏.........you doing an amazing work

    • @SASInsights
      @SASInsights Před 2 měsíci

      Thank you for your comment. I am planning to post a procedure series. It will cover proc transpose related questions as well.

  • @prabhath60
    @prabhath60 Před 3 měsíci

    You have tremendous knowledge sir.. your videos are very informative and useful to crack any interview 🙏

  • @vipulkaushik2294
    @vipulkaushik2294 Před 3 měsíci

    Sir make a series on sas macro

    • @SASInsights
      @SASInsights Před 3 měsíci

      Please find SAS Macro Series : czcams.com/play/PLE5sZYvritsbNKjY7EGQdJsYyQbprVOVK.html

  • @vipulkaushik2294
    @vipulkaushik2294 Před 3 měsíci

    Thank u sir for motivating us.

  • @vipulkaushik2294
    @vipulkaushik2294 Před 4 měsíci

    Very helpful🙏

  • @user-pm1mg7si2x
    @user-pm1mg7si2x Před 4 měsíci

    Hi sir could you please upload at least 2 or 3 tutorials weekly? It's really helpful for us

    • @SASInsights
      @SASInsights Před 4 měsíci

      Hi, Thank you for your comment and suggestion. Sure, I will try to upload videos as your suggestion.

  • @sunilkumar-kp1ry
    @sunilkumar-kp1ry Před 5 měsíci

    good explanantion

  • @purushotham714
    @purushotham714 Před 5 měsíci

    Hi sir Thanks for your videos really helping me, please do also make some complex interview scenarios

    • @SASInsights
      @SASInsights Před 5 měsíci

      Hi Thank you for your comment. Hopefully Question#53 somehow will fulfil your requirement.

  • @purushotham714
    @purushotham714 Před 6 měsíci

    Sir,Can you make one video on arrays

    • @SASInsights
      @SASInsights Před 6 měsíci

      Thank you for your comment. Sure, I will cover array and do loop stuffs after SAS macro series.

  • @vijaykishore
    @vijaykishore Před 6 měsíci

    Thank you for your videos brother, can you make any video on live work environment or a sample project video. Thank you

    • @SASInsights
      @SASInsights Před 6 měsíci

      Thank you for your comment. Sure, after Q/A series I have planned to make sample project videos.

  • @user-pm1mg7si2x
    @user-pm1mg7si2x Před 6 měsíci

    Sir,please make a tutorial orderwise in the SAS, confused where I can start!

  • @BHARATHEEYUDU.
    @BHARATHEEYUDU. Před 6 měsíci

    Super explaination sir What if different variables from different datasets using set and merge statements Please make a vedio

    • @SASInsights
      @SASInsights Před 6 měsíci

      Thank you for your comment. Sure, I will make video on it.

  • @beauregardtrouser6038
    @beauregardtrouser6038 Před 7 měsíci

    "promosm" 🍀