Looking for Ways to Only Read Specific Rows from a CSV File into SAS

[JackZ295]

Hi! Is there a way to read specific rows of a CSV file into SAS or to limit the number of rows being read from a CSV file into SAS? For example, if you had a data set with 1000 rows, but you just wanted to read in the first 800 rows, is there a way to do so? Any input regarding this would be much appreciated. Thanks so much! 

[SASKiwi]

Something like this should do it. Just adjust for the number of columns and the maximum length you want to read:

data temp (compress=yes);
   infile 'myfile.csv' dsd truncover firstobs=2 obs=800;
   length x1-x100 $200 ;
   input x1-x100;
run;

[JackZ295]

Thanks so much! I was actually wondering if it was possible to do it in a proc import procedure. My code is currently as follows: 

options MSGLEVEL=I;

options validvarname=v7;

proc import out=one

datafile='/home/user/Assessment/test_1.csv'

DBMS=csv replace;

getnames=yes;

run;

[SASKiwi]

Unfortunately I don't think there is a PROC IMPORT option for this. However, if you add this before running PROC IMPORT you should see a DATA step in the SAS log that you can copy back into the SAS editor to add the OBS = option:

options source;

[Patrick]

Proc Import generates and then executes a SAS data step (which you can see in the SAS log). 

You could set options obs=800 before proc import. This will lead for the generated data step to stop execution after row 800 is read.

You then set options obs=max; right after proc import.

[RD2]

Using Powershell answered by ChatGPT:  Import-Csv -Path "C:\path\to\csv\file.csv" | Select-Object -First 500 | Export-Csv -Path "C:\path\to\csv\first500.csv" -NoTypeInformation