Please try codes below, data have; input jan feb mar apr may jun; cards; 1 2 3 4 5 0 9 8 7 0 6 5 4 5 2 5 0 9 9 0 9 8 7 6 run; data want(drop = i); set have; array mth _numeric_; do i = 1 to dim(mth); if mth(i) = 0 then tot = dim(mth)- i + 1; end; run; cheers, P.J ... View more

Another option for you, %let default_values=-999,-998,-997,999; Data X; input x1 x2 x3 x4$; cards; 123 234 345 A -999 212 999 S 453 543 -998 Q -998 768 -997 W ; run; proc transpose data = x out = x1; run; data x2( drop = COL:); set x1(rename= _NAME_ = val); array a _numeric_; length str $50; str = ""; do over a; if a in (&default_values) then str = catx(',', str, a); end; run; proc print data=x2;run; Happy Friday, PJ ... View more

Hope codes below would help, data temp; input a $ b $ c $ d ; datalines; a1 b1 red . a1 b1 blue . a1 b1 gren . a1 b1 yellow 123 a1 b2 white . a1 b2 red . a1 b2 blue . a1 b2 green 456 a1 b2 white . ;;;; run; proc sort data= temp; by a b descending d; run; data want(drop=dd); set temp; by a b descending d; retain dd; if first.b then dd= d; else d =dd; run; ... View more

3078 data a; 3079 a = 10; 3080 label a = "number"; 3081 b = vlabel(a); 3082 3083 run; NOTE: The data set WORK.A has 1 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 3084 3085 data _null_; 3086 set sashelp.vtable; 3087 where libname ="WORK" AND memname = upcase("a"); 3088 put "nu of var=" nvar; 3089 run; nu of var=2 ... View more

Your statement works perfect to me bother data step and proc sql. 97 data test; 98 format AdmitDT yymmddn8.; 99 do i = 1 to 365; 100 AdmitDT = today() - i; 101 output; 102 end; 103 run; NOTE: The data set WORK.TEST has 365 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 104 105 data t; 106 set test; 107 if AdmitDT > INTNX('Day', Today(), -181); 108 run; NOTE: There were 365 observations read from the data set WORK.TEST. NOTE: The data set WORK.T has 180 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 109 110 proc sql; 111 create table t1 as 112 select * from test 113 where AdmitDT > INTNX('Day', Today(), -181); NOTE: Table WORK.T1 created, with 180 rows and 2 columns. 114 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ... View more

Neil, I'm no familiar with surveyfreq. And if you want to get the percentages of each 'status' within a 'sex' group seperately. That means only one way, I think you can only define status in table statement. Otherwise status*sex should be two ways. As my understanding you have to write table statements twice, one for one way percentage calculation, and the other one fore getting estimates. Like below.. proc ..; tables status ... tables sex*status ...; PJ ... View more

Please try something like this to see if it works, I'm using 9.1.3 proc sql; select cats("NWK.",memname) into :dsn separated by " " from sashelp.vstable where libname ="NWK" ; quit; options obs=1; data all; set &dsn; run; %put &dsn=; ... View more

Do you mean the results like below ? sex=1 status=1 COUNT=43 PERCENT=36.134453782 sex=1 status=2 COUNT=76 PERCENT=63.865546218 sex=2 status=1 COUNT=33 PERCENT=62.264150943 sex=2 status=2 COUNT=20 PERCENT=37.735849057 Then please try by adding by sex; proc freq data=food; by sex ; tables status /nocum out=food1; weight wt; run; ... View more

Please try below; data a; input var1 $; cards; a a b c c c ; run; proc sql; create table b as select distinct var1, count(var1) as freq, divide(calculated freq,10) as ave from a group by var1; quit; ... View more

Please try this one. data a; input opendate anydtdte.; format opendate date9.; today = put(today(), date9.); mth = intck("month", opendate, today()); cards; 09-Nov-84 01-Jan-78 15-Jun-87 10-May-82 01-Nov-72 18-May-94 29-Apr-85 18-Jul-97 02-Feb-96 16-Aug-88 01-Nov-99 22-Jun-00 10-Aug-90 08-May-98 01-Jan-78 08-Oct-02 02-Jan-89 20-Feb-04 04-Apr-75 20-Aug-04 23-Jun-04 16-Jul-04 01-Jun-92 25-Aug-94 06-Mar-07 15-May-06 05-Mar-07 26-Aug-02 18-Nov-01 11-Jun-96 03-Dec-99 30-Jul-08 16-Apr-07 14-May-07 18-Jun-08 13-Jul-07 06-Dec-02 01-Jan-78 05-Oct-95 06-May-08 04-Sep-98 19-Sep-09 31-Oct-08 01-Nov-08 01-Oct-92 20-Sep-07 30-May-97 22-May-08 24-Jul-09 01-Dec-89 ; run; ... View more