BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
eagles_dare13
Obsidian | Level 7

When I run:

data test

   INFILE DATALINES DSD;

   INFORMAT varname $32.;

   INPUT varname $ var1;

   DATALINES;

"ALPHA",-3.64693629

"BETA1",-0.584778408

"BETA2",-0.808085584

;

run;

Why do I get 3 blank records as output?

1 ACCEPTED SOLUTION

Accepted Solutions
Bryan
Obsidian | Level 7

Also would want to remove blank lines between DATALINES: and ;, as shown below.

DATALINES;

"ALPHA",-3.64693629

"BETA1",-0.584778408

"BETA2",-0.808085584

;

View solution in original post

4 REPLIES 4
Haikuo
Onyx | Level 15

cause you missed a semi colon?

data test;

Don't worry, it happened to me millions of time Smiley Happy

Haikuo

eagles_dare13
Obsidian | Level 7

Thanks. I changed the example slightly and it still does not work after putting semi colon.

data test;

   INFILE DATALINES  DSD ;

   INFORMAT varname $32.;

   INPUT varname $ var1 var2 var3;

   DATALINES;

"test",,,1

"test",,624.5,1

"test",624.5,741.5,2

;

run;

Does not work as in only some fields are being read...not all.

Haikuo
Onyx | Level 15

Works for me:

data test;

INFILE DATALINES  DSD ;

INFORMAT varname $32.;

INPUT varname $ var1 var2 var3;

DATALINES;

"test",,,1

"test",,624.5,1

"test",624.5,741.5,2

;

run;

Capture.PNG

Bryan
Obsidian | Level 7

Also would want to remove blank lines between DATALINES: and ;, as shown below.

DATALINES;

"ALPHA",-3.64693629

"BETA1",-0.584778408

"BETA2",-0.808085584

;

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1970 views
  • 3 likes
  • 3 in conversation