Answer Posted / krishna

In base sas
we can data from external data by

data <datasetname>;
infile 'path\file.txt';
run;

by procedure

proc import datafile='path\file.xls' out=<datasetname>
dbms=excel;
sheet='sheetname';
run;

proc import table=tablename out=<datasetname>
dbms=access;
database='path\file.mdb';
run;

Give an example where SAS fails to convert character value to numeric value automatically?

1090

---

name some data transformation used in sas di? : Sas-di

972

---

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.

2207

---

What are the difficulties u faced while doing vital signs table or dataset?

2396

---

What are the prime responsibilities of data integration administrator? : Sas-di

1072

---

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

1032

---

State the difference between INFORMAT and FORMAT ?

1109

---

Mention the validation tools used in SAS?

1181

---

What would you change about your job?

2389

---

What are common programming errors committed in sas

1150

---

How to convert a numeric variable to a character variable?

1210

---

what other sas products have you used and consider yourself proficient in using? : Sas programming

1115

---

How many data types are there in SAS?

1078

---

what do the mod and int function do? What do the pad and dim functions do? : Sas programming

1171

---

Mention how to limit decimal places for the variable using proc means?

1119

---