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

What is PROC in SAS?

604


What are the difficulties u faced while doing vital signs table or dataset?

1933


For clinical entire study how many tables will create approx?

1520


Explain what is SAS informats?

621


How many data types are there in SAS?

632






How do you delete duplicate observations in sas?

573


Describe a time when you were really stuck on a problem and how you solved it?

2201


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

633


In proc transpose and data step with arrays which one you pick?

2574


What is the maximum and minimum length of macro variable

652


What is the difference between reading data from an external file and reading data from an existing data set?

632


What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2004


What was the last computer book you purchased? Why?

1910


Explain how you can debug and test your SAS program?

565


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;

1965