topic Re: how to correct the code in SAS Programming

how to correct the code

thanikondharish — Sat, 15 Sep 2018 11:42:07 GMT

Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44

data test ;
infile 'C:\Users\LENOVO\Desktop\test.txt' ;
input a $1-4 ;
if a='Ruth' then input idnum 10-11 ;
else input age 7-8 ;
run;

it gives only ruth what about idnum,age.

it shows missing values in age,numeric variables

Re: how to correct the code

Kurt_Bremser — Sat, 15 Sep 2018 12:12:07 GMT

You forgot to hold the row pointer with @.

And since the columns are not at fixed places, you mostly try to read blanks for numbers.

STRONG hint: when posting examples of external files, ALWAYS use the {i} button, as that subwindow keeps the vertical alignment as-is. The main posting window tends to eat successive blanks, or replace tab characters.