SAS Practical Interview Questions and Answers

[@thiru9628]

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

[@bharatsingh-fu4rx]

Excellent, please make more videos like this.

[@jayasrikolli-y4n]

Good questions. Please do more practical questions .

[@riteshchivate9270]

Really good questions sir, would love more similar once

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

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

[@PHARMAINTERVIEWSnm]

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

[@asheermohammad3920]

what is the function of ceil here explain ?

[@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.

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

[@geddadavarma6715]

pls share solution for the Q4 using macros

[@Jaisrikrishna980]

Can you do vedio on sas9.4 installation for windows

[@sasworld2021]

Already have one. Please check.

[@ipankajnegi]

data want; set given; if _n_

[@sasworld2021]

Very good

[@bushanrajput7383]

Hii sir

[@sasworld2021]

Hi

[@jayasrikolli-y4n]

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'.

[@PradeepSingh-ho5ju]

SELECT over_number, SUM(runs_scored) AS total_runs FROM your_table_name GROUP BY over_number ORDER BY over_number;

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