topic read SAS data in SAS Programming

read SAS data

pchen002 — Thu, 28 Sep 2017 08:06:10 GMT

Given the SAS data set SASDATA TWO:

SASDATA TWO
XY
----
52
31
56
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?

Not sure why the answer is

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

Thanks!

Re: read SAS data

Kurt_Bremser — Thu, 28 Sep 2017 08:14:07 GMT

Your question is not coherent. There is no dataset "other" mentioned in the datastep at all.

STRONG HINT:

run examples yourself to make sure that you present working code here, this is more or less a bad joke.

Re: read SAS data

ballardw — Thu, 28 Sep 2017 14:42:02 GMT

AS written this line:

set sasdata two;

indicates that you are combining two different data sets Sasdata AND two, which by default would both be in the WORK library.

Your code does not actually show a reference to SASUSER.TWO or Other.

The periods in the data set names are crucial to accurate code as the . separates the library name, the bit before the . which is a storage location and the actual dataset name, the bit after the period.