What is difference between (a-z) and (a--z)
Answers were Sorted based on User's Feedback
Answer / basha
var a-z : this shows error message because it does not have
any numeric suffix
var a1-a5: it diplays variables a1 to a5
i.e it only shows variable ranges
var a--z : it displays a to z it includes variables between
a to z
ex;
data k;
input a b c z;
datalines;
1 2 3 4
5 6 7 8
;
proc print;
var a--z;
run;
proc print;
var a-z; >>>>>>this shows error:numuric is not there
run;
| Is This Answer Correct ? | 26 Yes | 4 No |
Answer / lucyl
data k;
input a1 a2 a4 a3;
datalines;
1 2 3 4
5 6 7 8
;
run;
proc print data=k;
var a1-a3;
run;
proc print data=k;
var a1--a3;
run;
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / satish kumar.v
IF you have given this
data k;
input a1 a2 a4 a3;
datalines;
1 2 3 4
5 6 7 8
;
proc print;
var a1--a4;
run;
proc print;
var a1-a4;
run;
the order is taken as priority when ever the a4 occurs then
it will stops processing in the case of a1--a4 i.e it will
display only 3 variables (a1 a2 a4) where as in second case
a1-a4 it will display all the 4 variables with 2 records
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / trishna
var a1-a5: It diplays variables a1 to a5
like: a1 a2 a3 a4 a5
mean i.e it only shows variable ranges.
var a--z : displays a to z it includes variables between
a to z
like: a c d e y z
mean a--z
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / niks
IF THE SEQUENCE OF VARIABLES IS..
a1 b1 c1 a2 b2 c2 a3 b3 c3.... then ... if a1-a3 is given.. it will consider variables..a1 a2 a3..only.. according to their numerical sequence... BUT ....if a1--a3
is given... then it will consider the variables ...a1 b1 c1 a2 b2 c2 a3...according to their positions...
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna
a-z menas display the value from a-z(a b c d e f.......z)
a--z menas display th value from a b cz
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rajaanku11
Your question is not clear, I am assuming a, z as variable
names.
In the input statement
Input a-z; It is a number range list from a to z.
input a--z; is the name range list between a to z.
| Is This Answer Correct ? | 3 Yes | 5 No |
Answer / aruna
a,z as variables names.
In the input statement
input a-z; it is a variables from a to z
input a--z; it is also the range from a to z variables
| Is This Answer Correct ? | 3 Yes | 13 No |
The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?
Where do you use proc means over proc freq?
what is enterprise guide? What is the use of it? : Sas programming
How do you read in the variables that you need?
What is the function of Stop statement in a SAS Program?
Which is Best Institute for learning SAS BASE & SAS BI in Hyderabad? Can anyone suggest me ?
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
Enlist the syntax rules followed in sas statements.
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
where will go the observations that were deleted by delete statement?
Diff between proc sql merge and join?
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.