Answer / 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

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.

Answer / krishna

yes . By using infile statement and options like dlm ,dsd
missover, trunover ,firstobs ,obs

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.

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;

Answer / naveen

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;

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";

Name statements that are execution only.

14 Answers   Accenture,

Describe the ways in which you can create a macro variable?

0 Answers  

differnce between 8.2 and 9.1.3

1 Answers  

AE datasets names? how many types?

0 Answers   Accenture,

How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;

2 Answers   HSBC,

What is Linear Regression?

0 Answers  

You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..

3 Answers  

How do you add a number to a macro variable?

3 Answers  

what is the difference between proc means and proc tabulate?

3 Answers   Cognizant, CTS,

WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?

3 Answers   Accenture,

What is the use of the %include statement?

0 Answers  

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

1 Answers