topic Re: Subsetting data - Enterprise Guide in SAS Procedures

Subsetting data - Enterprise Guide

gobejo — Thu, 26 Feb 2015 19:18:49 GMT

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

Re: Subsetting data - Enterprise Guide

Reeza — Thu, 26 Feb 2015 19:32:48 GMT

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.

Re: Subsetting data - Enterprise Guide

Doc_Duke — Fri, 27 Feb 2015 16:45:46 GMT

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.