topic Re: What is the correct option and why? in SAS Programming

What is the correct option and why?

Nipun22 — Tue, 11 Jun 2024 16:23:27 GMT

Given the SAS data set SASDATA TWO:
SASDATA TWO
XY
- -

- -
The following SAS program is submitted:

data sasuser.one two sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata two;
run;

What is the result?

A. data set SASUSER.ONE has 5 observations
data set SASUSER. TWO has 5 observations
data set WORK. OTHER has 3 observations
B. data set SASUSER.ONE has 2 observations
data set SASUSER. TWO has 2 observations
data set WORK.OTHER has 1 observations
C. data set SASUSER.ONE has 2 observations
data set SASUSER. TWO has 2 observations
data set WORK.OTHER has 5 observations
D. No data sets are output.
The DATA step fails execution due to syntax errors.

Re: What is the correct option and why?

PaigeMiller — Tue, 11 Jun 2024 17:04:36 GMT

@Nipun22 wrote:

Given the SAS data set SASDATA TWO:

Invalid name for a data set, it cannot have a space in it. So ERROR right there. Or is that just a typo? Questions like this cannot have typos or you get syntax errors that weren't intended by the questioner, and we can't give a meaningful answer.

But please follow these instructions to share the data set with us (and no other way is acceptable).

If you want to know what SAS will do, run the code yourself, don't ask us, SAS will tell you definitively what happens.

Re: What is the correct option and why?

Tom — Tue, 11 Jun 2024 16:46:01 GMT

As shown that code cannot run.

First because the two input datasets, WORK.SASDATA and WORK.TWO do not exist.

Second because the dataset WORK.SASDATA listed on the OUTPUT statement is not listed on the DATA statement.

1    data sasuser.one two sasdata.three;
2    set sasdata two;
ERROR: File WORK.SASDATA.DATA does not exist.
ERROR: File WORK.TWO.DATA does not exist.
3    if x = 5 then output sasuser.one;
4    else output sasdata two;
                 -------
                 455
ERROR 455-185: Data set was not specified on the DATA statement.

5    run;

ERROR: Libref SASDATA is not assigned.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set SASUSER.ONE may be incomplete.  When this step was stopped there were 0 observations and 1 variables.
WARNING: Data set SASUSER.ONE was not replaced because this step was stopped.
WARNING: The data set WORK.TWO may be incomplete.  When this step was stopped there were 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
      real time           0.95 seconds
      cpu time            0.01 seconds

Re: What is the correct option and why?

Quentin — Tue, 11 Jun 2024 17:17:29 GMT

Do you have access to SAS? You will have a very hard time learning SAS, without being able to run SAS code as you learn. Even if you manage to pass a certification test based on learning from books and trainings, you'll have a hard time programming if you haven't actually used SAS. The good news is you can get access to SAS for free, so you can run SAS code as you learn. You can go to SAS OnDemand for Academics: https://www.sas.com/en_us/software/on-demand-for-academics.html . This is free access to SAS, for anyone who wants to learn SAS, even if you're not enrolled in a college or university. With that, you will be able to run some of this code yourself, and then explore the results. If the results are surprising to you or hard to understand, then you can ask about them in the community.

Re: What is the correct option and why?

Nipun22 — Tue, 11 Jun 2024 18:20:48 GMT

first of all, option D is not correct as you are saying that there is a space because that would be way too easy to dodge the question

secondly, having a space at a very obvious statements is easily understood that it is a typo

and last thing in the original question the input dataset is not mentioned question to be solved without that only

so if you could answer that would be great else kindly ignore the question please.

Re: What is the correct option and why?

Nipun22 — Tue, 11 Jun 2024 18:22:20 GMT

that's the thing question has to be solved without the input dataset.

Re: What is the correct option and why?

PaigeMiller — Tue, 11 Jun 2024 18:46:17 GMT

So show us the correct information with no typos. Then people (including me) here will be happy to help. Otherwise, we are guessing and making stuff up, and can't really help you.

Re: What is the correct option and why?

Quentin — Tue, 11 Jun 2024 18:32:42 GMT

In an exam they may ask you to solve the question without input dataset. But for learning purposes, you can create an input dataset that matches the question, and run the code from the question, and explore the results. And try different data and code than is in the question, to see how stuff works.

Re: What is the correct option and why?

Tom — Tue, 11 Jun 2024 18:38:53 GMT

I would think in general without knowing what the input (or inputs) are then option D is going to be the only one you can be certain is the answer. The other answers depend on what is in the input data.

Let's go through them one by one:

A. data set SASUSER.ONE has 5 observations, data set SASUSER. TWO has 5 observations,
data set WORK. OTHER has 3 observations

For that to happen the data statement would need to be:

data sasuser.one sasuser.two other ;

So that there are 3 output datasets. And the OUTPUT statements would need to either not mention any datasets (so that the observations is written to all of them) or only lists one or more of those datasets listed in the DATA statement. So A is impossible given the OUTPUT statements even if the DATA statement was fixed.

B. data set SASUSER.ONE has 2 observations, data set SASUSER. TWO has 2 observations, data set WORK.OTHER has 1 observations

This seems to have the same problem.

C. data set SASUSER.ONE has 2 observations, data set SASUSER. TWO has 2 observations, data set WORK.OTHER has 5 observations

This seems to have the same problem.

D. No data sets are output. The DATA step fails execution due to syntax errors.

This one is true because the dataset names listed on the OUTPUT statements do not match the dataset names listed on the DATA statement. Which is a syntax error and will cause the data step to not run.

Re: What is the correct option and why?

Nipun22 — Tue, 11 Jun 2024 18:45:50 GMT

yes exactly i found this question on a website and can be a SAS Certification question

Re: What is the correct option and why?

PaigeMiller — Tue, 11 Jun 2024 18:48:06 GMT

Ok, then the problem was so poorly stated by whoever made it up, that the only logical answer is D, the data step fails to execute (as explained by @Tom ).

Re: What is the correct option and why?

Kurt_Bremser — Tue, 11 Jun 2024 19:08:42 GMT

The only answer I can give you: forget this website as a resource for exam preparation.

Re: What is the correct option and why?

ballardw — Tue, 11 Jun 2024 19:09:06 GMT

The very first statement on that "page" or whatever that image comes from is just plain wrong.

It says "Given the data set SASDATA TWO"

That is an invalid name for a data set. The name could be SASDATATWO, SASDATA_TWO or even "SASDATA TWO"N but not as presented. And that same error is repeated in multiple places.

With that introduction I would say that the source of this question is unreliable and would not trust the answers for any question as the foundation information they are presenting is wrong.

I have to assume that your image is as presented. If the space appeared in only one place I might believe it is a typo but there is absolutely not way that code could write any observations to SASUSER.TWO as the exact characters SASUSER.TWO do not appear anywhere in the shown code.

@Nipun22 wrote:

yes exactly i found this question on a website and can be a SAS Certification question

Re: What is the correct option and why?

PaigeMiller — Tue, 11 Jun 2024 19:22:12 GMT

Same question was asked 9 years ago in the SAS communities.

https://communities.sas.com/t5/SAS-Programming/sas-base-question/td-p/237111

And here's the same question on Flash Cards (but with different data)

https://quizlet.com/413354973/all-sas-questions-216-flash-cards/

Re: What is the correct option and why?

Nipun22 — Tue, 11 Jun 2024 19:33:43 GMT

how did you find this?

by searching the content of the questions?

Re: What is the correct option and why?

ballardw — Tue, 11 Jun 2024 19:50:34 GMT

@Nipun22 wrote:

how did you find this?

by searching the content of the questions?

Google "Given the SAS data set SASDATA TWO:"

And there are dozens of places that someone (or a bunch of bots) have copied the exact same stuff.

Re: What is the correct option and why?

Nipun22 — Thu, 13 Jun 2024 14:32:55 GMT

what's your suggestions then? how should i prepare? and what if i find doubts in the online dumps?

Re: What is the correct option and why?

Kurt_Bremser — Thu, 13 Jun 2024 19:44:20 GMT

When you have questions about specific points, bring them here.

Hint: there might be a reason why good preparations are not free (as in beer).

Creating a bunch of good and valid exam questions takes work. The one you showed here is simply crap. From where did you get it?