Wednesday 23 November 2016

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

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


Sample Data
---------------------------------------------------------------------

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

No comments:

Post a Comment