Please find the code.   data have; input var1 $20.; cards; Happy Sad Content None of the Above Happy Sad Content None of the Above Happy Sad Content None of the Above Happy Sad Content None of the Above Happy Sad Content None of the Above Happy Sad Content None of the Above Content Content Content Content Content Content ; run; data have; set have; rand_ord=RANUNI(8); if var1='Happy' then var1f=1; if var1='Sad' then var1f=2; if var1='Content' then var1f=3; if var1='None of the Above' then var1f=4; run; proc sort data=have; by var1f rand_ord; run; data want(drop=var1f1 var1f2); set have; if var1f=3 then do; if var1f1 ge var1f2 then do; var1nf=2; var1f2+1; end; else do; var1nf=1; var1f1+1; end; output; end; else do; var1nf=var1f; output; end; run;   Please let us know if it worked for you. ... View more

If you have strings then locate the decimal point and add the appropriate number of leading spaces. data have; input str :$10. @@; cards; 121 6.02 42 42 10.08 67 31 7.08 88 122 3.24 3.24 10.44 2.88 3.24 3.24 78 89 92 78 85 9.72 11 104 92 64 7.2 ; data want ; set have ; length varout $10.; format varout $char10.; loc = index(str,'.'); if loc=0 then loc=length(str)+1; varout=str ; if loc < 8 then varout=cat(repeat(' ',7-loc),varout); run; proc print; run; Obs str varout loc 1 121 121 4 2 6.02 6.02 2 3 42 42 3 4 42 42 3 5 10.08 10.08 3 6 67 67 3 7 31 31 3 8 7.08 7.08 2 9 88 88 3 10 122 122 4 11 3.24 3.24 2 12 3.24 3.24 2 13 10.44 10.44 3 14 2.88 2.88 2 15 3.24 3.24 2 16 3.24 3.24 2 17 78 78 3 18 89 89 3 19 92 92 3 20 78 78 3 21 85 85 3 22 9.72 9.72 2 23 11 11 3 24 104 104 4 25 92 92 3 26 64 64 3 27 7.2 7.2 2 ... View more

1. Is all these runs independent of each other? 2. Can you check your IO, CPU and memory consumption during one of the run. Running parallel is a tricky business, if your IO capacity is overloaded then you will have no benefit by creating parallel sessions. However it is very easy to create a child session and mange it in Base SAS. ... View more

I am guessing you want this.   data have; input date1:ddmmyy10. time1:time5. date2:ddmmyy10. time2:time5.; format datetime1 datetime20. datetime2 datetime20.; /*Unifroning datetime */ datetime1=(date1*24*60*60)+time1; /*Coverting Day to Time*/ datetime2=(date2*24*60*60)+time2; difference=intck('minute',datetime1,datetime2,'C'); cards; 12-09-2018 00:00 19-10-2018 00:00 01-11-2018 10:00 20-12-2018 23:00 ; run; Please let us know if it worked for you. ... View more

The Issue Description is not to the point. Can you describe what you have and what do you want as in table format. And provide any sample code if you have tried. ... View more

Isn't this the solution you looked for? @knveraraju91  ... View more