One simple approach: data y1; input data $ count; cards; d1 100 d2 500 d3 800 d4 60 ; quit; proc sql; create table y2 as select "total" as data, sum(count) as count from y1; quit; data final; set y1 y2; run; Hope this helps !! ... View more

You can select what ever variables you want. ... View more

Try this !! data y1; input cat_1 $ cat_2 $ numbers; cards; A B 2 A B 3 A B 3 A B 4 A B 2 A B 2 A B 2 A B 1 B B 2 B B 3 B A 2 B A 4 ; run; proc sort data=y1;by cat_1 cat_2;run; data y2; set y1; by cat_1 cat_2; if first.cat_2=1 then do; retain x 1; x=numbers-1; end; x=(numbers)*x; run; ... View more

data y1; input id LPCT $; cards; 1 sam0 2 alex5 3 jason0 ; run; data y2; set y1; required_output=substr(lpct,length(lpct),1); run; Hope this helps !! ... View more

Try this data h1; input a1 $ a2 $; cards; random Emerson random Olive random Inglewood High Montessori High CALIVA ; run; proc sort data=h1;by a1;run; data h2; set h1; by a1; retain c 0; c+1; if first.a1 then do; c=1; end; if a1='random' then do; final='SRL' || trim(put(c,z3.)); end; else if a1='High' then do; final='PRL' || trim(put(c,z3.)); end; run; Hope this helps !! ... View more

I know you got many answers. I just tried it and got a simpler solution. data h1; input port $ year qtr stock  $ amount; cards; p1 2000 1 s1 100 p1 2000 1 s2 200 p1 2000 1 s3  50 p1 2000 1 s4 100 p1 2000 2 s1 150 p1 2000 2 s3 100 p1 2000 2 s4 100 p1 2000 3 s1 200 p1 2000 3 s3 100 p1 2000 3 s4 150 p1 2000 3 s5 100 ; run; data h2(keep = stock amount_1); set h1; if qtr=1; rename amount=amount_1; run; proc sort data=h1;by stock;run; proc sort data=h2;by stock;run; data h3; merge h1(in=a) h2(in=b); by stock; if a; final_amt=amount-amount_1; run; Hope this helps ! ... View more

I felt the problem interesting and tried it using a macro. I took a dataset f1 with 10 observations and divided it into two parts each having 5 observation. Note: This macro will work for any number of partitions, just specify the total no of data sets needed( in this case 2) and total no of observations in each data set( in this case 5).           If you want to create 50 datasets with 5000 observations replace my values and I believe in a single run you can generate 50 datasets. options mprint; data f1; input id; cards; 1 2 3 4 5 6 7 8 9 10 ; run; %macro yesh(a); %do i=1 %to &a; %let k=%eval((&i-1)*5);  /* Lower Limit*/ %let g=%eval(&i*5);  /* Upper limit*/ data a_&i; set f1; if _n_<=&g and _n_ >= &k then output; run; %end; %mend; %yesh(2)  /* Total number of partitions*/ Hope this helps !! ... View more

One more approach using Substr and Index function. data y1; input name $ 1-40; cards; FIGLIULO,MARGARET Apple WHEELER,TANYA WALDRON,VIVIAN A ; run; data y2; set y1; firstname= substr(name,1,index(name,',')-1); lastname=substr(name,index(name,',')+1,index(name,' ')-index(name,',')-1); middlename=substr(name,index(name,' '),index(name,'')); run; ... View more