topic Re: Why there were only three obs in my output? dada as the attached. Thank you~ in SAS Studio

Why there were only three obs in my output? dada as the attached. Thank you~

jc3992 — Tue, 30 Jan 2018 22:19:51 GMT

data cars93ff2;
	infile '/folders/myfolders/cars93subfree.txt' termstr=CRLF;
	length Manufacturer $10;
	input Manufacturer $ Type $ Price MPG_city MPG_highway Horsepower Origin $;
run;
proc print data=cars93ff2;
run;

Re: Why there were only three obs in my output? dada as the attached. Thank you~

art297 — Tue, 30 Jan 2018 22:27:18 GMT

Add the firstobs option to your infile statement. i.e.:

	infile '/folders/myfolders/cars93subfree.txt' termstr=CRLF firstobs=2;

Art, CEO, AnalystFinder.com

Re: Why there were only three obs in my output? dada as the attached. Thank you~

Reeza — Tue, 30 Jan 2018 22:35:02 GMT

What does your log show?

@jc3992 wrote:

data cars93ff2;
	infile '/folders/myfolders/cars93subfree.txt' termstr=CRLF;
	length Manufacturer $10;
	input Manufacturer $ Type $ Price MPG_city MPG_highway Horsepower Origin $;
run;
proc print data=cars93ff2;
run;

Re: Why there were only three obs in my output? dada as the attached. Thank you~

jc3992 — Wed, 31 Jan 2018 00:23:35 GMT

data cars93ff2;
	infile '/folders/myfolders/cars93subfree.txt' termstr=CRLF;
	length Manufacturer $10;
	input Manufacturer $ Type $ Price MPG_city MPG_highway Horsepower Origin $;
run;
proc print data=cars93ff2;
run;

I succeeded, thanks! I did add firstobs before, but right after the path, now I changed the place and it worked! Thanks so much!