SAS A00-215 Exam - Topic 13 Question 47 Discussion

Actual exam question for SAS's A00-215 exam

Question #: 47
Topic #: 13

[All A00-215 Questions]

Which PROC IMPORT step correctly creates the MYDATA,SALES data set from the SALES.SCV file?

Aproc import datafile=sales.csv dbms=csv
out='mydata.sales';
run;

Bproc import datafile='sales.csv' dbms=csv
out=mydata. sales;
run;

Cproc import data='mydata. sales' dbms=csv
out='mydata.sales';
run;

Dproc import data=mydata.sales dbms=csv
out=mydata.sales;
run;

Show Suggested Answer

Suggested Answer: B

The correct statement to import a CSV file into SAS and create a dataset is option B. The PROC IMPORT statement is used in SAS to read data from external files and create a SAS data set. Let's break down why option B is correct:

datafile= specifies the location and filename of the external data file. In this case, 'sales.csv' is the correct filename and format for a CSV file.

dbms=csv tells SAS that the format of the external data file is CSV (comma-separated values).

out=mydata.sales; specifies the name of the output SAS dataset. It consists of two parts: the libref mydata and the dataset name sales. This tells SAS to store the new dataset in a library called mydata with the dataset name sales.

Option A uses an incorrect syntax as it incorrectly specifies the data= option, which is not valid in this context. Also, the out= option is incorrectly quoted and terminated with a semicolon within the quotes.

Option C has a typo in the out= option (out=mydata.gales;), which incorrectly specifies the output dataset name. Additionally, it incorrectly specifies the data= option, which should actually be datafile=.

Option D has incorrectly quoted the out= option and uses a hyphen instead of an equals sign. Additionally, it does not use quotes around the filename, which may cause issues if the filename contains special characters or spaces.

Reference: SAS 9.4 documentation, specifically the PROC IMPORT statement: SAS Help Center: PROC IMPORT Statement

by Melinda at Jul 09, 2025, 06:36 PM

Limited Time Offer

25%

Off

Get Premium A00-215 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Peggy

3 months ago

D doesn't make sense, out should be a new dataset.

upvoted 0 times

...

Shala

3 months ago

I’m leaning towards option A, but I’m a bit confused about whether the dataset name should have a period or not.

upvoted 0 times

...

Joana

4 months ago

I feel like option C is definitely wrong because it uses 'data=' instead of 'datafile='.

upvoted 0 times

...

Ryann

4 months ago

I remember practicing PROC IMPORT, but I can't recall if the OUT statement needs to have a period in it like in option A.

upvoted 0 times

...

Macy

4 months ago

I think option B looks familiar, but I'm not sure if the quotes around 'sales.csv' are necessary.

upvoted 0 times

...

Leonida

4 months ago

Wait, is it really that simple?

upvoted 0 times

...

Tequila

4 months ago

A looks right to me!

upvoted 0 times

...

Dudley

4 months ago

Option C has me a bit stumped, I'm not sure why the DATA= and OUT= statements are structured that way.

upvoted 0 times

...

Meaghan

5 months ago

I think B is the correct one.

upvoted 0 times

...

Tasia

5 months ago

C has the wrong syntax, no way that's it.

upvoted 0 times

...

Deandrea

5 months ago

I'm leaning towards option B as well, the way the file name and output data set are specified looks cleaner to me.

upvoted 0 times

...

Alberto

5 months ago

Option D seems the most straightforward to me, just specifying the input and output data sets directly.

upvoted 0 times

...

Freeman

6 months ago

Hmm, I'm a bit confused by the quotes around the file name in option A. I'll need to double-check the syntax for that.

upvoted 0 times

...

Dana

6 months ago

I think option B looks right, the syntax seems to match what I've seen in the PROC IMPORT documentation.

upvoted 0 times

...

Nickolas

6 months ago

I'm pretty confident that Option A is the correct answer. The file name and output data set name are both specified correctly.

upvoted 0 times

...

Derrick

6 months ago

I'm a bit confused by the different ways the file and output data set names are specified in the options. I'll need to think this through carefully.

upvoted 0 times

...

Ozell

6 months ago

Option B looks good to me. The file name is enclosed in single quotes, and the output data set name is specified correctly.

upvoted 0 times

...

Norah

7 months ago

Hmm, I'm a little unsure about this one. I'll need to review the PROC IMPORT documentation to make sure I understand the proper way to reference the file and output data set.

upvoted 0 times

...

Myong

7 months ago

I think the key here is to pay close attention to the syntax and formatting of the PROC IMPORT statement. The file name and output data set name need to be specified correctly.

upvoted 0 times

...

Fatima

8 months ago

Oh, I see. That makes sense. Thanks for explaining.

upvoted 0 times

...

Alecia

8 months ago

Option C? Really? Putting the data set name in quotes twice? That's like trying to catch two flies with one chopstick. Let's stick to the basics, folks.

upvoted 0 times

Walton

7 months ago

A) proc import datafile=sales.csv dbms=csv out=\'mydata.sales\'; run;

upvoted 0 times

...

Miesha

8 months ago

Because the syntax for specifying the output data set is 'out=mydata.sales'.

upvoted 0 times

...

Fatima

8 months ago

Why do you think B is correct?

upvoted 0 times

...

Miesha

8 months ago

I disagree, I believe the correct answer is B.

upvoted 0 times

...

Shonda

8 months ago

Ah, the age-old debate of quoting versus not quoting. I say, why not just use Option B and call it a day? It's the middle ground, you know, like a good cup of coffee.

upvoted 0 times

...

Leonora

9 months ago

Hmm, Option A seems the most straightforward to me. The DATAFILE parameter has the file name, and the OUT parameter has the data set name in quotes. Simple and elegant!

upvoted 0 times

Leota

7 months ago

User 1: I think Option A is the correct one.

upvoted 0 times

...

Alida

7 months ago

User 3: I'm not sure, but Option A does seem to make sense.

upvoted 0 times

...

Emogene

7 months ago

User 2: Yeah, I agree. It looks simple and straightforward.

upvoted 0 times

...

Julio

7 months ago

User 1: I think Option A is the correct one.

upvoted 0 times

...

Fatima

9 months ago

I think the correct answer is A.

upvoted 0 times

...

Sean

9 months ago

I think Option D is the way to go. The DATA parameter should have the data set name without quotes, and the OUT parameter should have the data set name without quotes as well.

upvoted 0 times

...

Franchesca

9 months ago

Option B looks correct to me. The DATAFILE parameter should have the file name in quotes, and the OUT parameter should have the data set name without quotes.

upvoted 0 times

Becky

8 months ago

User 2: Yeah, I agree. The DATAFILE parameter needs quotes around the file name.

upvoted 0 times

...

Taryn

8 months ago

User 1: I think option B is the correct one.

upvoted 0 times

...