topic Export first 5 obs in SAS Programming

Export first 5 obs

Ronein — Tue, 06 Dec 2022 11:32:20 GMT

Hello

I want to export first 5 observations.

What is the way to do directly in proc export please?

Then I want also to export observations 6-10

What is the way to do directly in proc export please?

 PROC EXPORT data =sashelp.cars(Where=(_N_<=5)) outfile ="path/dd.csv";
run;

Re: Export first 5 obs

PaigeMiller — Tue, 06 Dec 2022 12:33:28 GMT

proc export data=sashelp.cars(obs=5) outfile ="path/dd.csv";
run;

_N_ only has meaning within a data step, it has no meaning elsewhere.

Re: Export first 5 obs

Astounding — Tue, 06 Dec 2022 13:26:29 GMT

To export observations 6 through 10:

proc export data=sashelp.cars (firstobs=6 obs=10) outfile ="folder/next5.csv";
run;

Re: Export first 5 obs

Tom — Tue, 06 Dec 2022 17:20:49 GMT

Use the OBS= and FIRSTOBS= dataset option.

sashelp.cars(obs=5)

sashelp.cars(firstobs=6 obs=10)

sashelp.cars(firstobs=11 obs=15)

...

Re: Export first 5 obs

webart999ARM — Wed, 07 Dec 2022 00:51:46 GMT

To export the first 5 observations using PROC EXPORT, you can use the following code:

PROC EXPORT data = sashelp.cars(where=(_N_<=5)) outfile="path/dd.csv";
run;

To export observations 6-10 using PROC EXPORT, you can use the following code:

PROC EXPORT data = sashelp.cars(where=(_N_>5) and (_N_<=10)) outfile="path/dd.csv";
run;

In both cases, you need to specify the name of the SAS dataset you want to export (in this case, sashelp.cars), the file path and name for the output CSV file (in this case, path/dd.csv), and the WHERE clause that specifies which observations you want to export.

Re: Export first 5 obs

Ronein — Wed, 07 Dec 2022 06:44:38 GMT

Sorry but your code give an error.
As it was said here we cannot use _N_ in proc export