wt is a-z and a--z?
Answers were Sorted based on User's Feedback
Answer / veerendar alugola
you can see the below example for a-z:
data ptcde;
input ptid $ test1 test2 test3 test4;
cards;
1102 56 65 66 70
1103 55 85 62 77
1104 85 71 59 66
1105 55 100 120 61
1106 90 58 65 63
;
run;
data abc;
set ptcde;
a=mean(of test1-test4);
run;
when you use a-z it will consider only the range variables.
You can find the below example for a--z;
data ptcde;
input ptid $ test1 abc def test4;
cards;
1102 56 65 66 70
1103 55 85 62 77
1104 85 71 59 66
1105 55 100 120 61
1106 90 58 65 63
;
run;
data abc;
set ptcde;
a=mean(of test1--test4);
run;
when you use a--z it will consider all the variables
irrespective of the series.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / suneetha
If we consider 'a' as lower limit and 'z' as upper limit,
a-z is used to refer numeric variables and a--z is used to
refer to character variables.
| Is This Answer Correct ? | 15 Yes | 7 No |
Answer / aravind9882
'a-z' means sas considers only alpha characters between a
to z where as 'a--z' means, sas considers a to z watever it
may b in between.
| Is This Answer Correct ? | 7 Yes | 4 No |
how can you import .csv file in to sas? : Sas programming
Code a PROC MEANS that shows both summed and averaged output of the data.
Explain by-group processing?
Please write codes to merge two datasets and keep every record in the first dataset.
Give e an example of..
what is the difference between SET and MERGE?
What’s the difference between var b1 – b3 and var b1 — b3?
What is the use of divide function?
What are Dashboard reports?And significance of these in analysis?
/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
There is a field containing a date. It needs to be displayed in the format “ddmonyy” if it’s before 1975,”dd mon ccyy” if it’s after 1985, and as ‘disco years’ if its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT.