kindly refer below subject for solution   "How to retain the Variable Format when PROC EXPORT TO EXCEL"   Thanks, Siva   ... View more

Yeah. you can do it with any algorithmic expression.   data have; input age $20.; dif=input(resolve(cats('%sysevalf(',age,')')),best.); cards; 18-24 15*30 29/54 ; run; ... View more

/*Set up the initial data set*/ data have ; input state $       city  $       pop     ; datalines ; AA AA 123 AA BB  46 AA CC  23 AA DD   8 AA EE 267 AA FF  19 BB GG 249 BB HH  64 BB II  44 BB JJ  72 BB KK 411 BB LL  55 ; proc sort data=have ; by state descending pop ; run ; /*Keep the top 4 cities by population*/ data have2 (drop=count) ; set  have ; by   state descending pop ; if   first.state then count = 0 ; count + 1 ; if count le 4 ; run ; /*create macro variables with the state names*/ proc sql noprint; select count(state) into :nost from (select distinct state from have2) ; quit ; %let nost = &nost ; proc sql noprint; select distinct state into :stvar1 - :stvar&nost from have2 ; quit ; /*Output a data set for each state*/ %macro loopoutput() ; %do i = 1 %to &nost ;     data &&stvar&i ;     set  have2 ;     where state = "&&stvar&i" ;     run ; %end ; %mend loopoutput ; %loopoutput ; ... View more

I am afraid this is not as easy. One way would be: /* Compute the number of members to sample for each movie and year */ proc sql; create table memberPick as select movie, year, round(0.1*count(distinct member)) as _nsize_ from have group by movie, year; quit; /* Select a random movie and year for each member */ data have0; set have; order = rand("uniform"); run; proc sort data=have0; by member order; run; data have1; set have0; by member; if first.member; drop order; run; /* Sample members for each movie and year */ proc sort data=have1; by movie year; run; proc surveyselect data=have1 sampsize=memberPick out=want outall; strata movie year; run; PG ... View more