Hello,
In one of the interview, I've been asked below question, I would appreciate if someone would dignify with Answer.
"SAS has requested first 100 observations from Database using pass through , However only 90 has come out , Now from where we can begin the investigation" ?
I think we can run the trace ? if yes what is the process for it ?
Regards,
Jai
Examine code used for the extract.
Look for any filters such as WHERE clause may reduce the expected results because of values of variables,
or GROUP BY creating summaries, joins or similar things that could reduce the data.
Also ensure that the source actually has 100 or more records to pull from.
Personally I would suggest (politely in an interview) that the question needs to be rephrased.
SAS has pulled out first 100 observations from Database using pass through
That phrasing implies that the 100 were actually pulled. If the question was more like:
SAS requested the first 100 observations from Database using pass through
Then the question makes more sense to me.
Your right, I've changed the Word from Pulled to Requested, So other people would not get confuse.
Regards,
Jai
Actually interviewer was more keen to know , from where the investigation can be start, Rather than the way we would fix them.
He was more emphasizing on Running the Trace, Please suggest with the process / options of running Trace.
Regards,
Jai
options sastrace=',,,d' sastraceloc=saslog; proc sql; ......... SQL code ............ quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.