Answer Posted / jyotshna

yes we can replace dataset into view

syntax:
data librefname.datasetname/view=librefnmae.datasetname;
run;
sample:
data aa/view=aa;
set sashel.class;
run;

explain what is data set in sas? : Sas-administrator

1036

---

How many data types are there in SAS?

1132

---

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.

2248

---

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1729

---

Explain the difference between nodup and nodupkey options?

1089

---

If a variable contains only numbers, can it be a character data type?

1141

---

what is function of retain statment

2083

---

What are the ways to do a “table lookup” in sas?

1076

---

how does sas handle missing values in procs? : Sas programming

1349

---

What does PROC print, and PROC contents do?

1277

---

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

1076

---

What are the applications primarily used by business analyst? : Sas-bi

1050

---

what is broad cast agent? : Sas-bi

1120

---

What is the difference between order and group variable in proc report?

1485

---

what r the job openings SAS for fresher graduates !

2502

---