Answer Posted / sureshkv

data char;
set master;
keep _character_;
run;
data num;
set master;
keep _numeric_;
run;

Name types of category in which SAS Informats are placed?

1098

---

do you prefer proc report or proc tabulate? Why? : Sas programming

939

---

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

1284

---

If you could design your ideal job, what would it look like?

2879

---

Explain the special input delimiters used in sas programming.

965

---

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1007

---

What does the trace option do?

1060

---

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.

2168

---

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1022

---

Differentiate between ceil and floor functions.

1108

---

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1245

---

What are the differences between sum function and using “+” operator?

1041

---

What is the command used to find missing values?

1047

---

What are the advantages of using sas?

1102

---

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2534

---