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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is sas enterprise intelligence architecture? : Sas-bi

544


What are the automatic variables for macro? : sas-macro

677


What are the advantages of using sas?

607


What is a macro routine?

2104


why is sas considered self-documenting? : Sas programming

682






How do dates work in sas?

645


what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

553


Are you involved in writing the inferential analysis plan? Tables specifications?

3480


how does sas handle missing values in a merge? : Sas programming

554


how to debug and test the sas program? : Sas-administrator

572


Hi, If anyone has base SAS certification dumps, please share.

1386


Explain append procedure?

636


How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

638


What is the maximum and minimum length of macro variable

654


What does the trace option do?

666