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;

how to read character value without using substr function in sas ?

3 Answers  

---

calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15

6 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,

---

What are the efficacy variables in your study?

2 Answers   Accenture, Quintiles,

---

Name statements that are execution only.

4 Answers  

---

Why is SAS considered self-documenting?

1 Answers   Quintiles,

---

What is the use of %include statement?

0 Answers  

---

what are the considerations when picking a SAS/STAT procedure?

0 Answers   Accenture, Quintiles,

---

How would you remove a format that has been permanently associated with a variable? ________________

5 Answers   Quintiles, TCS,

---

What is the maximum length of the macro variable?

0 Answers  

---

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

0 Answers  

---

How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?

5 Answers  

---