SAS Practical Interview Questions and Answers

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.

[@thiru9628]

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

[@bharatsingh-fu4rx]

Excellent, please make more videos like this.

[@riteshchivate9270]

Really good questions sir, would love more similar once

[@user-uk2kt9cy9r]

Good questions. Please do more practical questions .

[@PHARMAINTERVIEWSnm]

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

[@AshokKumar.6767]

Nice vid0es🙏👍❤🎉

[@shyamcathe1844]

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]

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

[@rohitsharma-hz2sf]

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

[@sasworld2021]

Sure

[@SantySimbaVlogs]

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]

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]

@@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;

[@vitthalsharma4275]

Excellent sir what is a roadmap to clear SAS interview for experience individuals

[@sasworld2021]

Kindly set up a sas interview session and I will guide you.

[@ipankajnegi]

data want;
set given;
if _n_

[@sasworld2021]

Very good

[@geddadavarma6715]

pls share solution for the Q4 using macros

[@dineshaavula953]

Data new (keep=j cnt rename=(cnt=runs j=over));
X=6;
DO J=1 to nobs;
Do i=1 to x;
Set old nobs=nobs;
Cnt+runs;
If i=x then output;
If i=1 then cnt=0;
End;
End;
Run;

[@Jaisrikrishna980]

Can you do vedio on sas9.4 installation for windows

[@sasworld2021]

Already have one. Please check.

[@bushanrajput7383]

Hii sir

[@sasworld2021]

Hi

[@rushikeshmuthane5249]

data x;
set y ;
over = ceil (ball/6) ;
run;
proc sql;
create table new as select over, sum(run) as total_run from x group by over ; quit;

[@user-uk2kt9cy9r]

can some one tell what is the result of the below:
%let a=b;
%let b=c;
%let c=d;
%let d=e;
%let e=f;
%put &&&&&a;

[@parvsharma8767]

c hoga

[@khalidraza8438]

F

[@parulsingh1697]

63, If u want &a in the last step.

[@parvsharma8767]

@@parulsingh1697 63 Kha s aa gya?

[@parulsingh1697]

@@parvsharma8767 I thought u r asking how many '& ' will be required to get %a at last ..... for this question ans will be 'c'.