Home > Data Services > Catalog . Restricted Data . Census . ACS

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

RSS Feed icon

Counting Same-Sex Couples

The Antidote for “Anecdata”: A Little Science Can Separate Data Privacy Facts from Folklore

Big Data: NYC Taxi Cab Trips

Getting A More Accurate Count Of Arab Americans

Measuring Race in the Census: Its Fluid

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;

Related Question Groups: