Answer Posted / chiranjeevi

Informat:
1)It should appear only datastep.
2)it is used for SAS special instructions to read the
special data values.it can be used either in the input
statements,else by using a separate statement called 'informat'.

syntax:informat<variable name>>type of informat>
or
input<variable name><type of informat>
format:
1)it should appear only proc step.
2)it is used to write or print the special data values in
the output window.
syntax:format<variable name><type of format>.

informats:1)date formats
a)datew.
b)ddmmyyw.
c)commaw.
d)percent(%)
formats and informats both are same only.

Explain by-group processing?

784

---

i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2145

---

how do you test for missing values? : Sas programming

782

---

what are 5 ways to perform a table lookup in sas? : Sas-administrator

988

---

What is a put statement?

919

---

for whom is sas data integration studio designed? : Sas-di

735

---

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.

2024

---

What do you know about sas data set?

803

---

What would you change about your job?

2134

---

What is the SAS data set?

888

---

How does proc sql work?

826

---

explain the difference between proc means and proc summary?

870

---

What can you learn from the SAS log when debugging?

1115

---

how could you generate test data with no input data? : Sas programming

879

---

Give e an example of..

1834

---