Answer Posted / enr

To create csv file,we have to open notepad.then ,declaring
the variables.then save the file.like enr.csv
SYNTAX: proc import datafile='external file'
out=<dataset name> dbms=csv replace;
getnames=yes;
proc print data=<dataset name>
run;
eg:proc import datafile='E:\enr.csv'
out=sai
dbms=csv replace;
getnames=yes;
proc print data=sai;
run;

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

1186

---

I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

2152

---

what is the difference between infile and input? : Sas-administrator

1143

---

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2126

---

what is the difference between nodup and nodupkey options? : Sas programming

1190

---

What are the scrubbing procedures in sas?

1006

---

What is the maximum length of the macro variable?

1181

---

why is sas data integration studio important? : Sas-di

1034

---

what are 5 ways to perform a table lookup in sas? : Sas-administrator

1237

---

How would you determine the number of missing or nonmissing values in computations?

1069

---

Explain data step in SAS

1098

---

Difference between SAS STATA & SPSS?

1119

---

For what purpose would you use the RETAIN statement?

1524

---

how to debug and test the sas program? : Sas-administrator

1036

---

Name some categories in sas 9? : sas-grid-administration

977

---