topic Re: SAS program to read the nth observation from a dataset by file statement in SAS Programming

SAS program to read the nth observation from a dataset by file statement

rk7 — Wed, 06 Dec 2017 23:53:52 GMT

can anyone help me in writing the following program

* Using correct input option create a SAS data set named icecream using data file (Sales.dat);
* Use variables: Flavor, Location, BoxesSold
* Output only 5 observations starting with third observation.

Re: SAS program to read the nth observation from a dataset by file statement

novinosrin — Thu, 07 Dec 2017 00:11:54 GMT

data icecream;

set sales(firstobs=3 obs=7);

keep flavor location boxessold;

run;

or something like

DATA icecream;
INFILE 'c:\MyRawData\sales.dat';
INPUT (flavor location) ($) boxessold firstobs=3 obs=7;
RUN;

Re: SAS program to read the nth observation from a dataset by file statement

Reeza — Thu, 07 Dec 2017 00:10:40 GMT

Two ways:

FirstOBS and OBS via a data step

Or read it all in and filter afterwards using IF statements and _N_.

@rk7 wrote:

can anyone help me in writing the following program

* Using correct input option create a SAS data set named icecream using data file (Sales.dat);
* Use variables: Flavor, Location, BoxesSold
* Output only 5 observations starting with third observation.

Re: SAS program to read the nth observation from a dataset by file statement

rk7 — Thu, 07 Dec 2017 00:36:19 GMT

This is the code I have written

data icecream;
INFILE '/folders/myfolders/data/Sales1.dat';
INPUT flavor $10. location boxessold;
if _N_ = 3 to 8 then output;
end;
RUN;

proc print;
run;

This is the output I got

Obs flavor location

Chocolate	213	123
Chocolate	213	123
Chocolate	213	123
Chocolate	213	123
Chocolate	213	123
Chocolate	213	123
Vanilla	213	512
Vanilla	213	512
Vanilla	213	512
Vanilla	213	512
Vanilla	213	512
Vanilla	213	512
Pecan	415	242
Pecan	415	242
Pecan	415	242
Pecan	415	242
Pecan	415	242
Pecan	415	242
Choco 2	13	123
Choco 2	13	123
Choco 2	13	123
Choco 2	13	123
Choco 2	13	123
Choco 2	13	123
Strawberry	213	512
Strawberry	213	512
Strawberry	213	512
Strawberry	213	512
Strawberry	213	512
Strawberry	213	512
Coffee	415	242
Coffee	415	242
Coffee	415	242
Coffee	415	242
Coffee	415	242
Coffee	415	242
nuts	213	123
nuts	213	123
nuts	213	123
nuts	213	123
nuts	213	123
nuts	213	123
almonds	213	512
almonds	213	512
almonds	213	512
almonds	213	512
almonds	213	512
almonds	213	512
mint	415	242
mint	415	242
mint	415	242
mint	415	242
mint	415	242
mint	415	242
Fudge	213	123
Fudge	213	123
Fudge	213	123
Fudge	213	123
Fudge	213	123
Fudge	213	123
Peanut	213	512
Peanut	213	512
Peanut	213	512
Peanut	213	512
Peanut	213	512
Peanut	213	512
Pistachio	415	242
Pistachio	415	242
Pistachio	415	242
Pistachio	415	242
Pistachio	415	242
Pistachio	415	242
Cherries	213	123
Cherries	213	123
Cherries	213	123
Cherries	213	123
Cherries	213	123
Cherries	213	123
Berry	213	512
Berry	213	512
Berry	213	512
Berry	213	512
Berry	213	512
Berry	213	512
Toffee	415	242
Toffee	415	242
Toffee	415	242
Toffee	415	242
Toffee	415	242
Toffee	415	242

This time I attach the file sales1.doc

Re: SAS program to read the nth observation from a dataset by file statement

Reeza — Thu, 07 Dec 2017 01:01:33 GMT

Look at your log and post your log.

Also, you posted a bunch of information but didn't clarify what you're asking in this post, since your original question has answers.

@rk7 wrote:

This is the code I have written

data icecream;
INFILE '/folders/myfolders/data/Sales1.dat';
INPUT flavor $10. location boxessold;
if _N_ = 3 to 8 then output;
end;
RUN;

proc print;
run;

This is the output I got

Obs flavor location

Chocolate 213 123

Chocolate 213 123

Chocolate 213 123

Chocolate 213 123

Chocolate 213 123

Chocolate 213 123

Vanilla 213 512

Vanilla 213 512

Vanilla 213 512

Vanilla 213 512

Vanilla 213 512

Vanilla 213 512

Pecan 415 242

Pecan 415 242

Pecan 415 242

Pecan 415 242

Pecan 415 242

Pecan 415 242

Choco 2 13 123

Choco 2 13 123

Choco 2 13 123

Choco 2 13 123

Choco 2 13 123

Choco 2 13 123

Strawberry 213 512

Strawberry 213 512

Strawberry 213 512

Strawberry 213 512

Strawberry 213 512

Strawberry 213 512

Coffee 415 242

Coffee 415 242

Coffee 415 242

Coffee 415 242

Coffee 415 242

Coffee 415 242

nuts 213 123

nuts 213 123

nuts 213 123

nuts 213 123

nuts 213 123

nuts 213 123

almonds 213 512

almonds 213 512

almonds 213 512

almonds 213 512

almonds 213 512

almonds 213 512

mint 415 242

mint 415 242

mint 415 242

mint 415 242

mint 415 242

mint 415 242

Fudge 213 123

Fudge 213 123

Fudge 213 123

Fudge 213 123

Fudge 213 123

Fudge 213 123

Peanut 213 512

Peanut 213 512

Peanut 213 512

Peanut 213 512

Peanut 213 512

Peanut 213 512

Pistachio 415 242

Pistachio 415 242

Pistachio 415 242

Pistachio 415 242

Pistachio 415 242

Pistachio 415 242

Cherries 213 123

Cherries 213 123

Cherries 213 123

Cherries 213 123

Cherries 213 123

Cherries 213 123

Berry 213 512

Berry 213 512

Berry 213 512

Berry 213 512

Berry 213 512

Berry 213 512

Toffee 415 242

Toffee 415 242

Toffee 415 242

Toffee 415 242

Toffee 415 242

Toffee 415 242

This time I attach the file sales1.doc

Re: SAS program to read the nth observation from a dataset by file statement

rk7 — Thu, 07 Dec 2017 20:47:28 GMT

This worked

title 'dataset ICECREAM';
data iceceam;
infile '/folders/myfolders/data/Sales1.dat' firstobs=3 obs=7 ;
input flavor $11. location boxessold ;
run;

proc print ;
run;

Thanks for the effort.

Re: SAS program to read the nth observation from a dataset by file statement

Reeza — Thu, 07 Dec 2017 20:52:32 GMT

@rk7 That was @novinosrin answer to you yesterday. Marking your own answer as correct isn't appropriate in this situation.

Re: SAS program to read the nth observation from a dataset by file statement

rk7 — Thu, 07 Dec 2017 21:03:35 GMT

There is a mistake in the solution he offered. The firstobs and obs dataset options are declared in input statement where as it should be in infile statement. I have no problem in removing the solution tag if @novinosrin changes his answer.

Thanks

Re: SAS program to read the nth observation from a dataset by file statement

Reeza — Thu, 07 Dec 2017 21:04:36 GMT

Nope, fair enough. Thanks for clarifying 🙂

Re: SAS program to read the nth observation from a dataset by file statement

novinosrin — Thu, 07 Dec 2017 21:21:27 GMT

Hahaha, No worries. I'm here to learn like you are. Also being a graduate student, community credit is pale in comparison to how much i feel inferior when i notice people like reeza, art t, xia keshan , haikuo, chris nz, mkeintz, astounding etc with their slick answers. The next semester is what I am hoping to gain in a big way to be able to solve harder questions when I move on to take courses in Regression, principal components, time series and forecasting etc. Join the club if you like 🙂 . We are peers unlike the super list I mentioned above

Re: SAS program to read the nth observation from a dataset by file statement

rk7 — Thu, 07 Dec 2017 21:53:15 GMT

what a humble answer. loved it. It will remain an unanswered question

Re: SAS program to read the nth observation from a dataset by file statement

rk7 — Tue, 12 Dec 2017 22:35:37 GMT

It asks me to accept one of the following as answer. so I select the answer