Discuss SAS A00-215 Exam Topic 13 Question 47

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;

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

Get Premium A00-215 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

36 comments · newest first

Peggy 9 months ago

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

Shala 9 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.

Joana 10 months ago

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

Ryann 10 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.

Macy 10 months ago

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

Leonida 10 months ago

Wait, is it really that simple?

Tequila 10 months ago

A looks right to me!

Dudley 10 months ago

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

Meaghan 11 months ago

I think B is the correct one.

Tasia 11 months ago

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

Deandrea 11 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.

Alberto 11 months ago

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

Freeman 12 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.

Dana 12 months ago

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

Nickolas 12 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.

Derrick 1 year 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.

Ozell 1 year ago

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

Norah 1 year 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.

Myong 1 year 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.

Fatima 1 year ago

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

Alecia 1 year 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.

Walton 1 year ago

↳ replying to Alecia

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

Miesha 1 year ago

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

Fatima 1 year ago

Why do you think B is correct?

Miesha 1 year ago

I disagree, I believe the correct answer is B.

Shonda 1 year 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.

Leonora 1 year 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!

Leota 1 year ago

↳ replying to Leonora

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

Alida 1 year ago

↳ replying to Leonora

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

Emogene 1 year ago

↳ replying to Leonora

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

Julio 1 year ago

↳ replying to Leonora

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

Fatima 1 year ago

I think the correct answer is A.

Sean 1 year 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.

Franchesca 1 year 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.

Becky 1 year ago

↳ replying to Franchesca

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

Taryn 1 year ago

↳ replying to Franchesca

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

SAS A00-215 Exam - Topic 13 Question 47 Discussion