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
Can you execute a macro within a macro? Describe. : sas-macro
What is the difference between order and group variable in proc report?
Explain what is SAS informats?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
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
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
what is hash files in sas and why we are using this one in sas?
how the sas basic syntax style described? : Sas-administrator
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
Explain why double trailing @@ is used in input statement?
How long can a macro variable be? A token? : sas-macro
what is operational data and operational system? : Sas-di
Mention how to limit decimal places for the variable using proc means?
what does the run statement do? : Sas programming
what r the job openings SAS for fresher graduates !