topic Re: what is wrong with the program in SAS Programming

what is wrong with the program

Amy0223 — Sat, 30 Nov 2019 19:53:34 GMT

Hi community, I'm not sure how to answer this question. Your help is much appreciated!

What, if anything, is wrong with the following programs? An ellipsis (...) indicates proportions of a statement that are not germane to the exercise.

data one; infile...;
length type 2;
input lab grp m1-m50;
run;

data two; infile...;
input lab grp type mx1-mx10;
run;

data merge;
merge two one;
by lab grp;
run;

Re: what is wrong with the program

unison — Sat, 30 Nov 2019 20:12:45 GMT

are 'one' and 'two' sorted by lab and grp? i.e.

proc sort data=one; by lab grp; run;
proc sort data=two; by lab grp; run;

*merge after here ...;

If this is not the issue, please include the log.

-unison

Re: what is wrong with the program

Kurt_Bremser — Sat, 30 Nov 2019 20:49:04 GMT

In the first step, variable type is defined but stays uninitialized. The length as such (2) is only valid on z/OS.

Re: what is wrong with the program

Amy0223 — Sat, 30 Nov 2019 22:27:46 GMT

Thank you for your help! Should we put length statement in data two instead of data one because the type variable is not in data one?

length type $2;

Re: what is wrong with the program

SASKiwi — Sat, 30 Nov 2019 23:42:38 GMT

Only code statements if there is a reason for them...

Re: what is wrong with the program

r_behata — Sun, 01 Dec 2019 01:11:40 GMT

Merge cannot be used as the name of the dataset since it is restricted keyword.

data merge;
merge two one;
by lab grp;
run;