topic Variables read in output data in New SAS User

Variables read in output data

San_0611 — Wed, 03 Oct 2018 14:54:30 GMT

Data One:

Name IDnum

Amy 125

Lily 652

John 452

Mark 123

Data Two:

Name IDnum

Amy 125

Lily 652

Amanda 452

Mark 123

data work.new;

set One Two;

run;

How many variables are there in output data set?

Options are like 3,4 Or program fails

Thanks in advance for help.

Re: Variables read in output data

Kurt_Bremser — Wed, 03 Oct 2018 15:04:49 GMT

Maxim 4: try it.

If it fails depends on the variable types. If they differ between the datasets, it'll crash.

Re: Variables read in output data

kiranv_ — Wed, 03 Oct 2018 15:05:31 GMT

another great option and this option helps us in learning. that is d) run the code with data you shown

Re: Variables read in output data

San_0611 — Wed, 03 Oct 2018 15:10:13 GMT

How to create Date sets One and Two which are given above in SAS
University edition?

Re: Variables read in output data

SuryaKiran — Wed, 03 Oct 2018 15:26:16 GMT

SET statement here will append both the datasets if they have same datatypes. If both has same datatypes then output will have (4+4) records.
Since you don't have that option I assume that datatypes doesn't match and hence you will get an error.

/* This will have warning because the lengths for IDnum are different */
data one;
infile datalines dlm=',' dsd missover;
input Name:$8. IDnum:$20.;
datalines; 
Amy,125
Lily,652
John,452
Mark,123
;
data two;
infile datalines dlm=',' dsd missover;
input Name:$8. IDnum $50.;
datalines; 
Amy,125
Lily,652
Amanda,452
Mark,123
;
data want;
set one two;
run;
/* This will throw an error because IDnum is defined as character in one dataset and numeric in another */
data one;
infile datalines dlm=',' dsd missover;
input Name:$8. IDnum;
datalines; 
Amy,125
Lily,652
John,452
Mark,123
;
data two;
infile datalines dlm=',' dsd missover;
input Name:$8. IDnum $50.;
datalines; 
Amy,125
Lily,652
Amanda,452
Mark,123
;
data want;
set one two;
run;

Re: Variables read in output data

kiranv_ — Wed, 03 Oct 2018 15:26:17 GMT

please check the below link

http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a003209907.htm

Re: Variables read in output data

San_0611 — Wed, 03 Oct 2018 15:31:23 GMT

How to create the data sets One and Two in SAS university edition to run the above code ?

I am Base SAS learner

Also if there are two variables in each data set which are same , then how the output data set new will have 4 variables ?

Please explain in brief.

Thanks,

Sanika

Re: Variables read in output data

San_0611 — Wed, 03 Oct 2018 15:37:04 GMT

My question is How many variables are there in output data set , not the number of records or observations.

Thanks,

Sanika

Re: Variables read in output data

ballardw — Wed, 03 Oct 2018 16:41:27 GMT

@San_0611 wrote:

How to create the data sets One and Two in SAS university edition to run the above code ?

I am Base SAS learner

Also if there are two variables in each data set which are same , then how the output data set new will have 4 variables ?

Please explain in brief.

Thanks,

Sanika

If you did not make any spelling errors in your original post I would ask 1) where you got the options 3, 4 or fail and 2) why wasn't 2 an option.

Are you claiming above that the "answer" is supposed to be 4? Then you have not provided sufficient information OR the source of your answer is incorrect.

Re: Variables read in output data

Kurt_Bremser — Thu, 04 Oct 2018 05:42:34 GMT

With two identically named variables in both input datasets, the answer is either "2" or "will fail". The second happens if identically named variables have different types. Different lengths can cause WARNINGs.

Re: Variables read in output data

San_0611 — Thu, 04 Oct 2018 07:15:13 GMT

This question is from my Base SAS certification exam, and my thinking about
the answer of the problem is also "2". ,but this option is not provided in
the question and I am really sure about it. That is why I answered it as
"program fails"
But I don't know whether it is correct or wrong answer .
There is the fourth option but I don't remember it exactly ,but I am sure
that was not "2".

So just want to confirm what is the correct answer .

Thanks.

Re: Variables read in output data

Kurt_Bremser — Thu, 04 Oct 2018 07:59:18 GMT

How are the datasets presented for this question? Are they provided electronically as SAS datasets, or as data step code with datalines? Just showing a visual example (like in your first post) is not sufficient at all, because that tells us nothing about variable attributes, which are crucial for the answer.

If all information you got is what you presented in your initial post, then the question is made up very badly, and you should report that.

Re: Variables read in output data

San_0611 — Thu, 04 Oct 2018 08:17:13 GMT

The question was shown as I said in first post just the two tables are
given for data set One and data set Two, there is no any dataline code or
nothing said about the type or length of variables,
As I remember the only difference in those two data sets is in the
observation number 3 in Variable name.

Thanks

Re: Variables read in output data

Kurt_Bremser — Thu, 04 Oct 2018 08:34:20 GMT

Then present the answer 2 with this code as proof:

data one;
input Name $ IDnum;
datalines;
Amy 125
Lily 652
John 452
Mark 123
;
run;

data two;
input Name $ IDnum;
datalines;
Amy 125
Lily 652
Amanda 452
Mark 123
;
run;

data want;
set one two;
run;

proc print data=want noobs;
run;

Result:

Name      IDnum

Amy        125 
Lily       652 
John       452 
Mark       123 
Amy        125 
Lily       652 
Amanda     452 
Mark       123

Two variables.

Re: Variables read in output data

San_0611 — Thu, 04 Oct 2018 08:38:13 GMT

Where can I send this as a proof of answer?

Re: Variables read in output data

Kurt_Bremser — Thu, 04 Oct 2018 08:41:04 GMT

@San_0611 wrote:
Where can I send this as a proof of answer?

No idea. I never took any SAS certification at all.

Re: Variables read in output data

San_0611 — Thu, 04 Oct 2018 08:50:13 GMT

Okay thanks for the help.
I really appreciate it 🙂