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

;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 2642 views
  • 3 likes
  • 3 in conversation