Interested to Buy Any Domain ? << Click Here >> for more details...
How to get any kind of data in SAS? Is it possible to take
data from notepad in SAS?
- 7 Answers
- 12882 Views
- GSK, TNS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / vasu
we can get the data into sas environment but while getting
the data into sas environment we should keep in mind that
whether the data is in alligined in proper order if not
then use some softwarw like edit plus.
After that we can get the data into sas by the following
ways
1. using datalines
2.using infile statement
3.using dde triplet
uing any one of the above we can get the any kind of
relational or non-relational data into sas.
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / krishna
yes . By using infile statement and options like dlm ,dsd
missover, trunover ,firstobs ,obs
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mr.b
Data sample_accounts;
INFILE "C:\Mydata\sample_accounts.txt";
INPUT Account 1-7 OpenDate $ 9-17 StatusCode $ 21-22
CreditLimit 25-29;
RUN;
tis will be as i know.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / krishna
In base sas
we can data from external data by
data <datasetname>;
infile 'path\file.txt';
run;
by procedure
proc import datafile='path\file.xls' out=<datasetname>
dbms=excel;
sheet='sheetname';
run;
proc import table=tablename out=<datasetname>
dbms=access;
database='path\file.mdb';
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
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;
filename myfile "C:\Mydata\sample_accounts.txt";
data qqq;
infile myfile dlm=' ';
input Account OpenDate $ StatusCode $ CreditLimit;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nsb
Yes, we can read the data from notepad just like reading
data from from any other file formats by using INFILE
statement.
infile "...\....\xyz.txt";
| Is This Answer Correct ? | 0 Yes | 1 No |
How would you include common or reuse code to be processed along with your statements?
Give an example where SAS fails to convert character value to numeric value automatically?
What is the difference between an informat and a format. Name three informats or formats.
What sas features do you use to check errors and data validation?
What is the general format of function in sas? : sas-grid-administration
Identify statements whose placement in the DATA step is critical?
Can you execute macro within another macro? : sas-macro
In PROC PRINT, can you print only variables that begin with the letter “A”?
I am looking to buy a sas advance book. So any one can guide me that which one i should buy.
At compile time when a SAS data set is read, what items are created?
Explain the message 'Merge has one or more datasets with repeats of by variables'.
HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
3 Answers Accenture, Novartis,
Teradata 
