How to get any kind of data in SAS? Is it possible to take
data from notepad in SAS?
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
| Is This Answer Correct ? | 28 Yes | 0 No |
Post New Answer View All Answers
How can I remove header from output data set?
how do you pull data from equifax?tell me the process?
Approximately what date is represented by the SAS date value of 730?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
what is the primary data source for the wrs? : Sas-bi
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
What are the different types of sas functions?
Explain the difference between informat and format with an example.
What are the new features included in the new version of SAS Programming Language?
How do you use the do loop if you don’t know how many times you should execute the do loop?
Mention what is PROC in SAS?
What is the difference between one to one merge and match merge? Give an example.
what is snowflake schema? : Sas-di
How we can call macros with in data step? : sas-macro
how to read the variables in sas? : Sas-administrator