topic Re: using datastep in New SAS User

using datastep

BrahmanandaRao — Tue, 28 May 2019 07:16:31 GMT

Hi Guys Good Morning I want output rows as columns and columns as rows from below dataset

but this output only using datastep not with proc transpose

data avg_WH; 
input Age $ 1-5 Weight $ 7-25 Height $ 26-42  ;
cards;
13yrs	100.0 lb (45.3 kg)	61.5" (156.2 cm)
14yrs	112.0 lb (50.8 kg)	64.5" (163.8 cm)
15yrs	123.5 lb (56.0 kg)	67.0" (170.1 cm)
16yrs	134.0 lb (60.8 kg)	68.3" (173.4 cm)
17yrs	142.0 lb (64.4 kg)	69.0" (175.2 cm)
18yrs	147.5 lb (66.9 kg)	69.2" (175.7 cm)
19yrs	152.0 lb (68.9 kg)	69.5" (176.5 cm)
20yrs	155.0 lb (70.3 kg)	69.7" (177 cm)
;
run;

Re: using datastep

Kurt_Bremser — Tue, 28 May 2019 07:11:44 GMT

Please post working data step code for example data. Your code gives me this log:

27         data avg_W&H;
                     _
                     22
                     200
ERROR 22-322: Syntaxfehler, erwartet wird eines der folgenden: ein Name, eine Zeichenkette in Hochkommata, (, /, ;, _DATA_, _LAST_, 
              _NULL_.  

ERROR 200-322: The symbol is not recognized and will be ignored.

28         input Age Weight Height  ;
29         cards;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.AVG_W may be incomplete.  When this step was stopped there were 0 observations and 3 variables.
WARNING: The data set WORK.H may be incomplete.  When this step was stopped there were 0 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds

As the name says, the proper tool for TRANSPOSING is proc TRANSPOSE.

Re: using datastep

PeterClemmensen — Tue, 28 May 2019 07:23:29 GMT

Why do you want to do something like this in a data step? You can do something like this

data avg_WH; 
input Age $ 1-5 Weight $ 7-25 Height $ 26-42 ; 
cards; 
13yrs 100.0 lb (45.3 kg) 61.5" (156.2 cm) 
14yrs 112.0 lb (50.8 kg) 64.5" (163.8 cm) 
15yrs 123.5 lb (56.0 kg) 67.0" (170.1 cm) 
16yrs 134.0 lb (60.8 kg) 68.3" (173.4 cm) 
17yrs 142.0 lb (64.4 kg) 69.0" (175.2 cm) 
18yrs 147.5 lb (66.9 kg) 69.2" (175.7 cm) 
19yrs 152.0 lb (68.9 kg) 69.5" (176.5 cm) 
20yrs 155.0 lb (70.3 kg) 69.7" (177 cm) 
; 
run;

data want(keep=var:);
   array _{3} $20 Age Weight Height;
   array var{8} $20;
   do i=1 to 3;
      do j=1 to 8;
         set avg_WH point=j;
         var[j]=_[i];    
      end;
      output;
   end;
   stop;
run;

Re: using datastep

BrahmanandaRao — Tue, 28 May 2019 07:33:55 GMT

Thank you