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

Can you execute a macro within a macro? Describe. : sas-macro

853


What is the difference between order and group variable in proc report?

1109


Explain what is SAS informats?

821


What are the best sas programming practices for handling very large datasets? : sas-grid-administration

753


If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

805


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1507


what is hash files in sas and why we are using this one in sas?

1924


how the sas basic syntax style described? : Sas-administrator

787


Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1673


Explain why double trailing @@ is used in input statement?

783


How long can a macro variable be? A token? : sas-macro

928


what is operational data and operational system? : Sas-di

838


Mention how to limit decimal places for the variable using proc means?

829


what does the run statement do? : Sas programming

769


what r the job openings SAS for fresher graduates !

2185