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

;

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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