topic Re: Missing Entries in New SAS User

Missing Entries

jaiganesh — Fri, 08 Mar 2019 18:57:56 GMT

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

Re: Missing Entries

ballardw — Fri, 08 Mar 2019 18:23:05 GMT

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.

Re: Missing Entries

jaiganesh — Fri, 08 Mar 2019 18:59:05 GMT

Your right, I've changed the Word from Pulled to Requested, So other people would not get confuse.

Regards,

Jai

Re: Missing Entries

jaiganesh — Fri, 08 Mar 2019 19:01:40 GMT

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

Re: Missing Entries

Ksharp — Sat, 09 Mar 2019 11:11:39 GMT

options sastrace=',,,d' sastraceloc=saslog;

proc sql;
.........
SQL code
............
quit;

Re: Missing Entries

BrahmanandaRao — Sat, 09 Mar 2019 15:44:12 GMT

Ksharp
I would say your are brilliant
Way of coding 👍