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;

Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation

1 Answers   SAS,

---

Name statements that are recognized at compile time only?

3 Answers   Accenture,

---

what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?

1 Answers  

---

Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?

1 Answers   Icon,

---

Describe 5 ways to do a “table lookup” in SAS?

0 Answers  

---

what is the difference between proc report and proc format?

7 Answers   CTS,

---

what are validation tools that are used in sas? : Sas-administrator

0 Answers  

---

In PROC PRINT, can you print only variables that begin with the letter “A”?

8 Answers  

---

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

0 Answers  

---

How would you include common or reuse code to be processed along with your statements?

3 Answers   Accenture,

---

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.

0 Answers  

---

what are scrubing procedures in SAS?

1 Answers   Oracle,

---