Help using Base SAS procedures

Subsetting data - Enterprise Guide

Reply
Contributor
Posts: 28

Subsetting data - Enterprise Guide

Hi,

I have a .csv file of 1.5 million records. I was wondering if there is a way of subsetting only the first 200 records, just to see how the data looks.

Thanks,

Thomas

Super User
Posts: 17,868

Re: Subsetting data - Enterprise Guide

Lots of ways.

If you're importing via proc import or data step you can use

options obs=200;

*code to import;

options obs=max;

If you're on Unix or via powershell look at the head command of the file to display the first few lines.

Trusted Advisor
Posts: 2,113

Re: Subsetting data - Enterprise Guide

When you open a dataset to look at it in EGuide, there is a default number of records that it reads (I think 1000).  You can change the default under tools --> options.

Ask a Question
Discussion stats
  • 2 replies
  • 144 views
  • 0 likes
  • 3 in conversation