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

American Community Survey (ACS) Data Products Survey

Big Data in 1848

ACS Median Earnings by Detailed Occupation

Big Government and Big Data

PAA President Ruggles wants you to write a letter

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: