topic Re: Help please in SAS Programming

Explanation for code - reading a text file

Saurav — Wed, 31 Aug 2016 11:34:58 GMT

for given data:

11 john  1 77
11 88    2 james
22 bobby 1 55
22 89    2 opey

also , i coded as follows, though program works perfect, but I want to know why ((then input @1 id @4 score @12 name $5. @12 name $5. @10 source 1.;)) requires direct pointing , even id variable requires it?

dm"log;clear;output;clear";

DATA result2;
input @10 source 1.@; *recording in input buffer source ;

if source = 1 then input @1 id @4 name $5. @12 score @12 score @10 source 1. ;
if source = 2 then input @1 id @4 score @12 name $5. @12 name $5. @10 source 1.;

datalines;
11 john  1 77
11 88    2 james
22 bobby 1 55
22 89    2 opey
;

RUN;

PROC PRINT data = result2 noobs;
var source id name score;
RUN;

[Edit by Kurt Bremser] Moved program text to code window, corrected datalines so they match the input statement column pointers

Re: Help please

Kurt_Bremser — Wed, 31 Aug 2016 11:23:45 GMT

After the first input statement, that stays in the same input line because of the trailing @, the column pointer stays where it was after reading source.

Therefore, the column pointer must be set to the beginning of the line before attempting to read id.

Re: Explanation for code - reading a text file

Kurt_Bremser — Wed, 31 Aug 2016 11:28:29 GMT

PS you could simplify your code like that:

data result2;
input @10 source 1. @1 @; *recording in input buffer source ;
if source = 1 then input id @4 name $5. @12 score @12 score @10 source 1. ;
if source = 2 then input id @4 score @12 name $5. @12 name $5. @10 source 1.;
datalines;
11 john  1 77
11 88    2 james
22 bobby 1 55
22 89    2 opey
;
run;

Re: Explanation for code - reading a text file

Reeza — Wed, 31 Aug 2016 11:29:41 GMT

You input file a fixed width file so each variable starts at a specified column. Consider how it handles a name such as John Paul.

It has two layouts sending on source column. I think your input statements for source is incorrect as you read name/score twice.

Your sample data posted doesn't reflect this because of formatting in forum most likely.