topic Re: Data Input in SAS in SAS Programming

Data Input in SAS

JUMMY — Tue, 19 Feb 2019 18:22:01 GMT

How do I input data that is exactly as it is below in sas? I tried the command below but it didn't work. I want each group to have seven elements in a row.

data have;
input group $ ddd @@;
datalines;

A: 29 32 26 15 34 15 23
B: 11 30 34 13 27 24 21
C: 22 12 20 7 3 27 4
D: 16 21 13 6 0 9 25
E: 6 2 10 -3 8 1 -4
;

run;

Re: Data Input in SAS

novinosrin — Tue, 19 Feb 2019 18:34:19 GMT

do you mean this?

data have;
input group : $1. @;
do i=1 to 7;
input  ddd @;
output;
end;
drop i;
datalines;
A: 29 32 26 15 34 15 23
B: 11 30 34 13 27 24 21
C: 22 12 20 7 3 27 4
D: 16 21 13 6 0 9 25
E: 6 2 10 -3 8 1 -4
;
run;

Re: Data Input in SAS

novinosrin — Tue, 19 Feb 2019 18:35:59 GMT

or this ?


data have;
input group :$1. ddd1-ddd7 ;
datalines;
A: 29 32 26 15 34 15 23
B: 11 30 34 13 27 24 21
C: 22 12 20 7 3 27 4
D: 16 21 13 6 0 9 25
E: 6 2 10 -3 8 1 -4
;
run;

Re: Data Input in SAS

JUMMY — Tue, 19 Feb 2019 18:41:23 GMT

@novinosrin, is there a way it can be written out in horizontal form?

Re: Data Input in SAS

JUMMY — Tue, 19 Feb 2019 18:43:39 GMT

@novinosrin, how can I get rid of ddd1-ddd7? I prefer this way though?

Re: Data Input in SAS

novinosrin — Tue, 19 Feb 2019 18:44:29 GMT

I am still not clear with what you want as output?

Re: Data Input in SAS

novinosrin — Tue, 19 Feb 2019 19:22:00 GMT

wondering if you want something fancy

data have;
input group :$1.@;
array ddd(7);
input ddd{*} ;
datalines;
A: 29 32 26 15 34 15 23
B: 11 30 34 13 27 24 21
C: 22 12 20 7 3 27 4
D: 16 21 13 6 0 9 25
E: 6 2 10 -3 8 1 -4
;
run;

Re: Data Input in SAS

Ksharp — Wed, 20 Feb 2019 11:00:59 GMT

data have;
infile cards truncover;
input group $ ddd @;
do while(not missing(ddd));
 output;
 input ddd @;
end;
datalines;

A: 29 32 26 15 34 15 23
B: 11 30 34 13 27 24 21
C: 22 12 20 7 3 27 4
D: 16 21 13 6 0 9 25
E: 6 2 10 -3 8 1 -4
;

run;

Re: Data Input in SAS

gamotte — Wed, 20 Feb 2019 11:14:24 GMT

Hello,

Do you mean something like this ?

data have;
infile datalines dlm=":" dsd;
length group $1. ddd $ 50.;
input group ddd;
datalines;
A: 29 32 26 15 34 15 23
B: 11 30 34 13 27 24 21
C: 22 12 20 7 3 27 4
D: 16 21 13 6 0 9 25
E: 6 2 10 -3 8 1 -4
;
run;

If so, you are not doing the future you a favor by using a unique variable to store several values

as it makes data manipulation more difficult.