data countseries; set sashelp.countseries; year=year(date); run; proc sql; create table want as select year, sum(units) as sum from countseries group by year; quit; ... View more

We can use the date literals as below data output; set datarolling_ETFS; if rankdate<'30Jun2005'd then delete; run; ... View more

Please try below code   Data test; /* Creating new dataset */ set Student; /* Original data set */ Tot = sum(English , Hindi); Run; ... View more

I took the example sashelp.class and developed the code as per your requirement.   Please check and update as per your data and test   data class; set sashelp.class; array grades(2)$ heightgrade weightgrade; array result1(2) height weight; array result2(2) height2 weight2; do i = 1 to 2; if result1(i) ne . then result2(i)=round(result1(i),1); if result2(i)>90 then grades(i)='A'; else if 75<=result2(i)<=89 then grades(i)='B'; else if 60<=result2(i)<=74 then grades(i)='C'; else if .<result2(i)<60 then grades(i)='D'; end; run; ... View more

you need to add two more steps to your code to get the units     data VS; input usubjid weight weightu $ temp tempu $ hr hru $ visit $ dd mm yy; datalines; 100 102 KG 38 C 70 BEATS/MIN WEEK1 01 01 2000 100 225 KG 97 F 71 BEATS/MIN WEEK2 14 01 2000 100 112 KG 38 C 72 BEATS/MIN WEEK3 28 01 2000 100 102 KG 38 C 72 BEATS/MIN WEEK4 07 02 2000 101 220 KG 98.6 C 75 BEATS/MIN WEEK1 01 01 2000 101 102 KG 38 C 72 BEATS/MIN WEEK2 14 01 2000 101 104 KG 38 C 73 BEATS/MIN WEEK3 28 01 2000 ; run; proc sort data=vs out=sorted_vs; by usubjid visit dd mm yy; run; proc transpose data=sorted_vs out=transp_vs name=TESTCD prefix=results; by usubjid visit dd mm yy; var weight temp hr; run; proc transpose data=sorted_vs out=transp_vs2 name=TESTCD prefix=units; by usubjid visit dd mm yy; var weightu tempu hru; run; data all; merge transp_vs transp_vs2; by usubjid visit dd mm yy; run; ... View more