do you need to re-order the rows? if the rows where reordered would you get the answer you are expecting. Must all records be included or are there conditions where you are expected to drop the record.
... View more
do you have example SAS code that you have tried to assign attributes. Tell the full story, Learn by sharing what you already have tried. That is why your teachers always told you to show your work.
... View more
here is a sample of what I use: options noxwait noxsync mlogic; X "C:\Program Files\Microsoft Office\Office\EXCEL.EXE"; data _null_; x=sleep(5); run; filename cmds dde 'excel|system'; data _null_; length mystuff $250; file cmds; pre_book = '[open("'||"&temppath.\&workbook."||'")]'; put pre_book; run; filename outpre dde "Excel|&temppath.\[&workbook.]&sheet.!r1c1:r561c10" notab; /* put the information into the cells in the worksheet */ data _null_; file outpre notab; /* a lot of puts and x'09' */ run;
... View more
as @bobpep212 says change the second * to name and the answer is 7 for B but the code Errors. as is. data work.one;
input name$ years;
cards;
Joyce 9
John 4
John 2
jane 6
Tomas 8
;
data work.two;
input name$ years;
cards;
Joyce 31
John 42
Robert 25
Bob 22
Jeff 42
;
proc sql;
select Avg(years)
label="Average of Employment"
from work.one
where name in
(select *
from work.one
except corr
select name from work.two);
quit;
... View more
here is a data step that gives your requested results data have;
input ID $ var1 var2 coe1;
cards;
A 2 4 0.2
A NA/. NA/. 0.3
A 1 3 0.5
B 4 6 0.1
B 7 9 0.2
B 1 3 0.7
C 5 6 0.5
C 2 3 0.5
;
proc sort data=have out=have2;
by ID;
run;
data want(drop = var1_total var2_total coe1);
set have2;
by id;
if first.ID then
do;
var1_total = 0;
var2_total = 0;
end;
var1_total + var1;
var2_total + var2;
if last.ID then
do;
var1 = var1_total;
var2 = var2_total;
output;
end;
run;
... View more
if your records are fixed position this will work data have;
input @1 name $18. @19 city $;
cards;
myself,only here
you,and,i, there
stuff,1 nowhere
;
... View more
As @Tom puts it, token means many things. if those perimeters are consistent with English I would say that the token is user authorization to access the ulr. It could also be a specific directory at the ulr. Please post more information relevant to the macro and the calling statement.
... View more
