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 are the benefits of data integration? : Sas-di
Describe the function and untility of the most difficult SAS macro that you have written.
what is the function of catx syntax? : Sas-administrator
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
What is the difference between order and group variable in proc report?
explain what is factor analysis? : Sas-administrator
How are numeric and character missing values represented internally?
Explain substr function?
Name any two sas spawners? : sas-grid-administration
What is a macro routine?
explain the proc in sas? : Sas-administrator
what is the difference between nodup and nodupkey options? : Sas programming
What is the difference between SAS functions and procedures?
What is a method to debug and test your SAS program?
Explain what Proc glm does?