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
what is sas enterprise intelligence architecture? : Sas-bi
What are the automatic variables for macro? : sas-macro
What are the advantages of using sas?
What is a macro routine?
why is sas considered self-documenting? : Sas programming
How do dates work in sas?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
Are you involved in writing the inferential analysis plan? Tables specifications?
how does sas handle missing values in a merge? : Sas programming
how to debug and test the sas program? : Sas-administrator
Hi, If anyone has base SAS certification dumps, please share.
Explain append procedure?
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?
What is the maximum and minimum length of macro variable
What does the trace option do?