SAS Practical Interview Questions and Answers

Подписаться 3,3 тыс.

Просмотров 1,8 тыс.

50% 1

SAS Practical Interview Questions and Answers
This video contains SAS performance based interview questions and answers.
Key Questions:
Time Topics
MM:SS
00:37 Q1. Write a program to create new dataset with only Last 3 observations of source dataset dynamically.
04:37 Q2. What will happen if we run below code.
06:14 Q3. Make the changes in the below program so that both where statements should work.
08:38 Q4. Write a program to calculate runs scored in each over.

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

25 фев 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 30

@PHARMAINTERVIEWSnm 19 дней назад

proc sql; create table total_run as select ceil(ball/6) as over, sum(run) as runs from ds group by over; quit;

@thiru9628 2 месяца назад

Nice videos Sir .. we learnt alot from your videos...

@bharatsingh-fu4rx 2 месяца назад

Excellent, please make more videos like this.

@user-uk2kt9cy9r 2 месяца назад

Good questions. Please do more practical questions .

@riteshchivate9270 2 месяца назад

Really good questions sir, would love more similar once

@AshokKumar.6767 2 месяца назад

Nice vid0es🙏👍❤🎉

@shyamcathe1844 2 месяца назад

proc sql; create table grouped_data as select ceil(ball/6) as over, sum(coalesce(run, 0)) as total_run from ungrouped_data group by ceil(ball/6); quit;

@harsharani6194 2 месяца назад

use unique funtion to expected output ---- unique(ceil(ball/6))as over,

@rohitsharma-hz2sf 2 месяца назад

Can you make a video on sas macros practical experience wise questions

@sasworld2021 2 месяца назад

Sure

@SantySimbaVlogs 2 месяца назад

proc format; value balls 1-6="1 over" 7-12="2 over" 13-18="3 over"; run; proc means data=cricket sum; class balls; var runs; format balls balls.; run;

@sasworld2021 2 месяца назад

Good Attempt. However suppose if balls are 600 then you have to hardcode 100 overs in formats. So this approach will not work dynamically, as total balls can be changed. So try solving this using only one data step. You can use underscore N underscore with combination of mod function.

@SantySimbaVlogs 2 месяца назад

@@sasworld2021 how about this proc sql; create table have as select ceil(balls/6) as overs, sum(runs) as runs from cricket group by ceil(balls/6); quit; data have2; set have; by overs; if first.overs then output; run;