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 PROC in SAS?
What are the difficulties u faced while doing vital signs table or dataset?
For clinical entire study how many tables will create approx?
Explain what is SAS informats?
How many data types are there in SAS?
How do you delete duplicate observations in sas?
Describe a time when you were really stuck on a problem and how you solved it?
what is operational data and operational system? : Sas-di
In proc transpose and data step with arrays which one you pick?
What is the maximum and minimum length of macro variable
What is the difference between reading data from an external file and reading data from an existing data set?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
What was the last computer book you purchased? Why?
Explain how you can debug and test your SAS program?
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;