Answer / sureshkv

data char;
set master;
keep _character_;
run;
data num;
set master;
keep _numeric_;
run;

Answer / chaudhary_1989

data a;
infile "C:Documents and SettingssasadmDesktopSASMacro est1.txt" firstobs=2;
input num1 num2 num3 c1$ c2$ num4 c3$;
run;

data b;
set a;
keep _numeric_;
run;

data c;
set a;
keep _character_;
run;

How to get any kind of data in SAS? Is it possible to take data from notepad in SAS?

7 Answers   GSK, TNS,

---

When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

2 Answers   Accenture,

---

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

2 Answers  

---

What are the difference between sas functions and procedures?

0 Answers  

---

What is the role of sas grid administrator? : sas-grid-administration

0 Answers  

---

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

0 Answers  

---

I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?

1 Answers  

---

For clinical entire study how many tables will create approx?

0 Answers   TCS,

---

Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   Oracle,

---

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,

---

How do you test for missing values?

0 Answers   Quintiles,

---

What do you feel about hardcoding?

4 Answers   Oracle,

---