SAS Solutions
SAS Solutions
  • 96
  • 27 680
How to split live master data coming from different countries to country wise dataset ? SAS Q/A
In this video we discuss a sample project2 where we use live dataset (Order_Data)
Suppose you are having live Data, Orders coming from different countries. Write a Macro to split this master Data into smaller Datasets depending on the Unique values of each countries.
How do you import excel data into SAS dataset? || SAS Interview Question and Answer: ua-cam.com/video/Cr1VJMQkxYU/v-deo.html
Note : For project2 sample dataset please send request by email.
@SASInsights: yt.sassolutions@gmail.com
Presented by: Dhruba Joshi
Переглядів: 182

Відео

SAS Sample Project 1- Using Test_Data(Store_Data.xlsx) Macro code for report || SAS Interview Q/A34:50SAS Sample Project 1- Using Test_Data(Store_Data.xlsx) Macro code for report || SAS Interview Q/A
SAS Sample Project 1- Using Test_Data(Store_Data.xlsx) Macro code for report || SAS Interview Q/A
Переглядів 26914 днів тому
In this video we discuss a sample project using given excel data. We solve following three task. 1. Consider variable Order_Date is the Date of Order Placed. Write a Macro that will Display the Report of all the Sales Conducted on Daily Basis. 2. Consider Same Test_Data, Write a Macro to get summarized report on any particular year. 3. Consider the Same Test_Data. You have 3 Types of Orders -Or...
As a data analyst what is you first approach on your given task || SAS Interview Question & Answer6:33As a data analyst what is you first approach on your given task || SAS Interview Question & Answer
As a data analyst what is you first approach on your given task || SAS Interview Question & Answer
Переглядів 20721 день тому
In this video, we discuss how to start data analysis task step by step. Steps are: 1. Import data to SAS Environment 2. Use proc sql; and count total records 3. Count distinct records 4. Use proc contents procedure to get number of variable , variable length, and variable types. 5. Use proc means with N, Min, Max, Mean, Nmiss option, 6. Proc freq with missing option, 7. Keep/Drop option for sub...
What happens when proc SQL processes a summary function without a group by clause ||SAS Interview QA6:55What happens when proc SQL processes a summary function without a group by clause ||SAS Interview QA
What happens when proc SQL processes a summary function without a group by clause ||SAS Interview QA
Переглядів 186Місяць тому
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
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
Переглядів 177Місяць тому
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
Переглядів 225Місяць тому
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
Переглядів 211Місяць тому
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
Переглядів 1802 місяці тому
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
Переглядів 1792 місяці тому
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
Переглядів 2112 місяці тому
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
Переглядів 2403 місяці тому
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
Переглядів 1453 місяці тому
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. ua-cam.com/video/oGfI1XWUWHs/v-d...
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
Переглядів 1453 місяці тому
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. ua-cam.com/video/1eJl6ODe-jY/v-de...
How does union operator work in proc sql/How to Join two tables vertically without duplicate rcs?4:47How 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?
Переглядів 1233 місяці тому
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
Переглядів 1023 місяці тому
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: ua-cam.com/video/vQjjMrkqJsA/v-deo.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
Переглядів 1393 місяці тому
How do you use data step merge to get same result as right join (from proc sql) SAS Interview Q/A
SAS Top 80 Interview Question and Answer:Part 2: Q31 - Q61 || SAS Interview Question And Answer0:38SAS 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
Переглядів 1854 місяці тому
SAS Top 80 Interview Question and Answer:Part 2: Q31 - Q61 || SAS Interview Question And Answer
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
Переглядів 2414 місяці тому
SAS Top 80 Interview Question and Answer:Part 1: Q01 - Q30 || SAS Interview Question and Answer
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
Переглядів 2104 місяці тому
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
Переглядів 1534 місяці тому
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
Переглядів 2114 місяці тому
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?
Переглядів 2274 місяці тому
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
Переглядів 1624 місяці тому
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
Переглядів 2014 місяці тому
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
Переглядів 3034 місяці тому
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
Переглядів 2934 місяці тому
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
Переглядів 4324 місяці тому
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
Переглядів 2754 місяці тому
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
Переглядів 1634 місяці тому
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
Переглядів 5584 місяці тому
SQL in SAS - Proc SQL || SAS Interview Question and Answer

КОМЕНТАРІ

  • @vipulkaushik2294
    @vipulkaushik2294 9 годин тому

    Nice explanation sir....could you please explain implicit and explicit in proc sql

  • @Evan-ig2gs
    @Evan-ig2gs 11 днів тому

    Can you make one video, how to create aCRF and define.xml, please?

  • @kalyansrikanth1991
    @kalyansrikanth1991 16 днів тому

    hi can you provide the dataset of this sample project

    • @SASInsights
      @SASInsights 16 днів тому

      For dataset , please share your email to :yt.sassolutions@gmail.com.

  • @vipulkaushik2294
    @vipulkaushik2294 18 днів тому

    I am excited to watch next video👌👌.......Great work sir👍

    • @SASInsights
      @SASInsights 17 днів тому

      Thank you for your comment!

  • @vipulkaushik2294
    @vipulkaushik2294 3 місяці тому

    Thank u sir ❣️

  • @vipulkaushik2294
    @vipulkaushik2294 3 місяці тому

    Sir ek series proc transpose p bna dijiye🙏🙏

    • @SASInsights
      @SASInsights 3 місяці тому

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

  • @vipulkaushik2294
    @vipulkaushik2294 3 місяці тому

    Thank you sir

  • @vipulkaushik2294
    @vipulkaushik2294 3 місяці тому

    Thank you sir

  • @vipulkaushik2294
    @vipulkaushik2294 3 місяці тому

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

    • @SASInsights
      @SASInsights 3 місяці тому

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

  • @prabhath60
    @prabhath60 4 місяці тому

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

    • @SASInsights
      @SASInsights 4 місяці тому

      Thanks for your comment!

  • @vipulkaushik2294
    @vipulkaushik2294 4 місяці тому

    Sir make a series on sas macro

    • @SASInsights
      @SASInsights 4 місяці тому

      Please find SAS Macro Series : ua-cam.com/play/PLE5sZYvritsbNKjY7EGQdJsYyQbprVOVK.html

  • @vipulkaushik2294
    @vipulkaushik2294 4 місяці тому

    Thank u sir for motivating us.

  • @vipulkaushik2294
    @vipulkaushik2294 4 місяці тому

    Very helpful🙏

    • @SASInsights
      @SASInsights 4 місяці тому

      Thanks for your comment.

  • @GrapeWine-u5m
    @GrapeWine-u5m 5 місяців тому

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

    • @SASInsights
      @SASInsights 5 місяців тому

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

  • @sunilkumar-kp1ry
    @sunilkumar-kp1ry 6 місяців тому

    good explanantion

    • @SASInsights
      @SASInsights 5 місяців тому

      Thank you for your feedback.

  • @purushotham714
    @purushotham714 6 місяців тому

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

    • @SASInsights
      @SASInsights 6 місяців тому

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

  • @purushotham714
    @purushotham714 7 місяців тому

    Sir,Can you make one video on arrays

    • @SASInsights
      @SASInsights 7 місяців тому

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

  • @vijaykishore
    @vijaykishore 7 місяців тому

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

    • @SASInsights
      @SASInsights 7 місяців тому

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

  • @GrapeWine-u5m
    @GrapeWine-u5m 7 місяців тому

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

  • @BHARATHEEYUDU.
    @BHARATHEEYUDU. 7 місяців тому

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

    • @SASInsights
      @SASInsights 7 місяців тому

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

  • @beauregardtrouser6038
    @beauregardtrouser6038 8 місяців тому

    "promosm" 🍀