Search Data Services
Meta Search
search across all the following databases:
Data Catalog
Data and documentation
KnowledgeBase
Common questions and answers.
Resources
Entire collection of data resources.
Latest Data News
Measuring Marriage & Divorce among Same-Sex Couples
Data Services Knowledge Base
Q:
Can a person use excel data in SAS?
A:
To use an excel file in SAS you will need to save the file as a '.csv' file. This is a choice in the 'Save As' pull-down menu. This will convert the file into a comma delimited file. In your SAS syntax you will need to define that file as having a comma delimiter. The program below defines the delimiter as a comma.
Data E;
infile 'book1.csv' dlm=',' missover;
input cage mage div;
proc freq;
tables cage mage;
run;