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

1 Answers  

---

data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.

2 Answers  

---

Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables.

7 Answers   Accenture,

---

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

0 Answers  

---

Do you prefer Proc Report or Proc Tabulate? Why?

9 Answers   Oracle,

---

How to limit decimal places for the variable using proc means?

0 Answers  

---

6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK

1 Answers   IBM, SAS,

---

sas macros

12 Answers   TCS,

---

name several ways to achieve efficiency in your program? : Sas programming

0 Answers  

---

how to know the attributes of first five datasets in a library

2 Answers  

---

what is washout period?

3 Answers   Cognizant,

---

Explain how you can debug and test your SAS program?

0 Answers  

---