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.

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.

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 there any differnce between proc means and proc summary?

5 Answers  

---

how to generate report for 0 observation dataset?

3 Answers   Mind Tree, Student,

---

How do you add a number to a macro variable?

2 Answers  

---

how does sas handle missing values in assignment statements? : Sas programming

0 Answers  

---

Code a PROC MEANS that shows both summed and averaged output of the data.

5 Answers  

---

i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance

2 Answers   Tech Mahindra,

---

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set.

10 Answers   Accenture,

---

What is _n_?

22 Answers  

---

Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

0 Answers  

---

what is the effect of the options statement errors=1? : Sas programming

0 Answers  

---

Name statements that are recognized at compile time only?

3 Answers   Accenture,

---

What is LAG function?How is it used? can any one explain

3 Answers   TRE, Verinon Technology Solutions,

---