Answer Posted / sas29

Data sample_accounts;
INPUT Account 1-7 OpenDate $ 9-17 StatusCode $ 21-22
CreditLimit 25-29;
CARDS;
1234670 11-Sep-04 Z 2000
1234671 12-Sep-04 3000
1234672 13-Sep-04 Z 2500
1234673 14-Sep-04 T 3200
1234674 15-Sep-04 8000
run;


method1
--------------------------
Data sample_accounts;
INFILE "C:\Mydata\sample_accounts.txt";
INPUT Account 1-7 OpenDate $ 9-17 StatusCode $ 21-22
CreditLimit 25-29;
RUN;

method 2
-----------------------------------
filename sacc "D:\Mydata\sample_accounts.txt";
Data sample_accounts;
INFILE sacc ;
INPUT Account 1-7 OpenDate $ 9-17 StatusCode $ 21-22
CreditLimit 25-29;
RUN;

method 3;
use proc import:

method 4:
use proc cimport for xpt files into sas

what is function of retain statment

1978

---

I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2655

---

Describe the ways in which you can create macro variables?

1113

---

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

1087

---

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

2317

---

What does the trace option do?

1056

---

What are the features of base sas system?

1017

---

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

2578

---

how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2705

---

if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

1349

---

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1017

---

What does the RUN statement do?

1257

---

What is maximum storage capability of SAS?

1354

---

Intern stastical programmer written test

682

---

explain about sas business intelligence? : Sas-bi

1077

---