Answer / singh.naveen409

Process-1
FIle-Import Data-Next-Browse-ok-finish

Process-2
filename myfile "file location path.extension";
data qqq;
infile myfile;
input ......................;
run;


In the place of this .............just right down variable
name;

If you have csv file then;
process:-
proc inport out=work.auto1 filename " path of file which you
want to read.csv"
dbms=csv replace;
getnames=yes;
run;

What do the put and input function do?

0 Answers  

---

Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?

2 Answers  

---

if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record

4 Answers   HSBC,

---

explain the main difference between the nodup and nodupkey options? : Sas-administrator

0 Answers  

---

For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

0 Answers  

---

for what purpose would you use the retain statement? : Sas programming

0 Answers  

---

What are the difference between the sas data step and sas procs?

0 Answers  

---

Mention few ways with which a “table lookup’ is done in sas programming.

1 Answers  

---

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.

1 Answers  

---

How to get part of string form the source string without using sub string function in SAS?

3 Answers  

---

firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?

1 Answers  

---

"What is the difference between proc sort nodup and proc sort nodupkey?"

2 Answers  

---