tell me about use of arrays in sas
Answer / vimal raj
SAS Array's main functionality is
when a same action has to be performed repeatedly for n number of similar variables, it is ideal to use array which will simplify the sas program and gives the efficient performance in running and also the look n feel is better
data readin;
set outdata;
array Q(20) Q1-Q20;
do i= 1 to 20;
if Q(i) = 6 then Q(i)= .;
end;
run;
| Is This Answer Correct ? | 4 Yes | 2 No |
how do we mail reports from SAS environment to our team leader
Tell different ways to create Macrovarible?
3 Answers Accenture, PharmaNet i3,
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.
what are the best practices to process the large data sets in sas programming? : Sas-administrator
WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?
what is the difference between proc means and proc tabulate?
What is the pound sign used for the DATA _NULL_?
Have you used macros? For what purpose you have used? : sas-macro
what are the benefits of data integration? : Sas-di
WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS.
Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
What are symget and symput? : sas-macro