topic Re: raw data file, cert question in SAS Programming

raw data file, cert question

Steelers_In_DC — Wed, 13 Mar 2013 16:56:00 GMT

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=

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,

Re: raw data file, cert question

ping — Wed, 13 Mar 2013 17:14:44 GMT

Among them, set is a closer answer.

Re: raw data file, cert question

Steelers_In_DC — Wed, 13 Mar 2013 17:29:19 GMT

Thanks,

Re: raw data file, cert question

Linlin — Wed, 13 Mar 2013 18:04:16 GMT

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

Re: raw data file, cert question

data_null__ — Wed, 13 Mar 2013 18:16:54 GMT

filename FT15F001 temp; 
parmcards; 
I am a data file created without SET.
;;;;

Re: raw data file, cert question

Linlin — Wed, 13 Mar 2013 18:25:46 GMT

OK, I changed my condition:

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

Re: raw data file, cert question

Steelers_In_DC — Wed, 13 Mar 2013 18:35:30 GMT

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

Re: raw data file, cert question

PGStats — Wed, 13 Mar 2013 21:23:01 GMT

, does Excel count as raw data?

Re: raw data file, cert question

Linlin — Wed, 13 Mar 2013 23:19:13 GMT

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

Re: raw data file, cert question

PGStats — Thu, 14 Mar 2013 01:38:14 GMT

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;