BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Steelers_In_DC
Barite | Level 11

Hello.  I am sitting for the base cert tomorrow and in my review I come across the following question.  I am skeptical that this is correct:

Which of the following keywords is used to create a raw data file?

A) filename

B) libname

C) infile

D) set

Answer=

D

I can create a raw data file without a set statement so I didn't think this was correct.  I was thinking it would be the 'file' statement, or possibly 'put'.  Any insight to this question would be very helpful.

Thank You,

1 ACCEPTED SOLUTION

Accepted Solutions
ping
Fluorite | Level 6

Among them, set is a closer answer.

View solution in original post

9 REPLIES 9
ping
Fluorite | Level 6

Among them, set is a closer answer.

Steelers_In_DC
Barite | Level 11

Thanks,

Linlin
Lapis Lazuli | Level 10

How could you create a raw file without SET statement (excluding proc export)?  Best of the luck with your exam!

data_null__
Jade | Level 19
filename FT15F001 temp;
parmcards;
I am a data file created without SET.
;;;;
Linlin
Lapis Lazuli | Level 10

OK, I changed my condition:

How would you create a raw file from a sas dataset without using SET statement (excluding proc export)?

PGStats
Opal | Level 21

, does Excel count as raw data?

PG
Linlin
Lapis Lazuli | Level 10

By my definition, only files with extension .dat and .txt.:smileysilly:

PGStats
Opal | Level 21

I tried using the OLEDB and ODBC engines to create text files (.csv) but that didn't work.

The only way I can think of is :

ods listing file="Consultations\SAS Community\Reports\test.txt" style=normalPrinter;

options nodate nonumber formchar="|----|+|---+=|-/\<>*";

title;

proc sql;

select * from sashelp.class;

quit;

ods listing close;

PG

PG
Steelers_In_DC
Barite | Level 11

Linlin, I see your point but that's not the way the original question is worded.

sas-innovate-wordmark-gradient-background 3.pngSAS Innovate

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 9 replies
  • 5659 views
  • 0 likes
  • 5 in conversation