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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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