I have  the following data   data test1; input sal hike; cards; 1000 2000 2000 3000 3000 4000 4000 5000 ; run; data test2; set test1; array q1[1] sal; array q2[1] hike; array q3[1]; do i=1 to 4; q3[i]=q1[i]-q2[i]; end; run;       I am gettng the following error:   216 data test1; 217 input sal hike; 218 cards; NOTE: The data set WORK.TEST1 has 4 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 223 ; 224 run; 225 data test2; 226 set test1; 227 array q1[1] sal ; 228 array q2[1] hike; 229 array q3[1]; 230 do i=1 to 4; 231 q3[i]=q1[i]-q2[i]; 232 end; 233 run; ERROR: Array subscript out of range at line 231 column 13. sal=1000 hike=2000 q31=-1000 i=2 _ERROR_=1 _N_=1 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1 observations read from the data set WORK.TEST1. WARNING: The data set WORK.TEST2 may be incomplete. When this step was stopped there were 0 observations and 4 variables. WARNING: Data set WORK.TEST2 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ... View more

Here am creating a macro  here am creating two datasets x1 x2 from s1 s1 since i cud not access s1  s2 directly in proc sql in macro,even in this way also  i cud  nt get the correct result,am getting error   ''File WORK.RUN.DATA does not exist'' .                %macro test_(test_,s1,s2); data x1; set &s1 run; data x2; set &s2; run; proc sql ; create table &test_ as select x1.classifications, x1.VSSTRESN as Active, x2.VSSTRESN as placebo,sum(x1.VSSTRESN,x2.VSSTRESN ) as total from x1,x2 where x1.classifications=x2.classifications; quit; %mend; even i cud nt access  the data in the following way also proc sql ; create table &test_ as select &s1.classifications, &s1.VSSTRESN as Active, &s2.VSSTRESN as placebo,sum(&s1.VSSTRESN,&s2.VSSTRESN ) as total from &s1,&s2 where &s1.classifications=&s1.classifications; quit;     %test_(test100,r1,r2);     cup u pls help me out. ... View more

i HAVE THE FOLLOWING DATASET:   DATA dem; INPUT SITEID $ COUNTRY $ INVNAM $ subid ; CARDS; 001 USA SRINU 101 001 USA RUBY 102 001 USA SAS 103 001 USA MEHAR 111 001 USA QLAS 104 002 USA SURI 105 002 USA KEERTI 106 002 USA DEEP 107 003 USA SATYA 108 004 USA XYZ 109 ; RUN; I need output as 001 USA SRINU,RUBY,SAS,MEHAR,QLAS 101 001 USA SRINU,RUBY,SAS,MEHAR,QLAS 102 001 USA SRINU,RUBY,SAS,MEHAR,QLAS 103 001 USA SRINU,RUBY,SAS,MEHAR,QLAS 111 001 USA SRINU,RUBY,SAS,MEHAR,QLAS 104 002 USA SURI,KEERTI,DEEP 105 002 USA SURI,KEERTI,DEEP 106 002 USA SURI,KEERTI,DEEP 107 003 USA SATYA 108 004 USA XYZ 109   ... View more

Hi I have the following data   dates 20170101 20160101 20150101     I need the out as   17-01-01 16-01-01 15-01-01       ... View more

Hii   I have the following data set   subid   names 001       ruby 001       ricky 001       subbu 002       kee 002       chai 003       deep 004       suri   I need output as subid    names 001       ruby,ricky,subbu 002       kee,chai 003       deep 004       suri       ... View more