data have; input (Var_A Var_B Date) (& $20.); cards; 1 120 02JAN2020 1 120 05JAN2020 231 CH 06FEB2020 231 CH 12FEB2020 231 CH 15FEB2020 139 SELF 15JAN2020 139 SELF 19JAN2020 139 SELF 2 3 07JAN2020 139 SELF 2 3 15FEB2020 139 SELF 41 09FEB2020 141 SELF 4g 15MAR2020 141 SELF 4g 21MAR2020 141 SELF5 14MAR2020 ; data want; set have; if Var_B='SELF' then var_c='SELF_MAIN'; else if Var_B=: 'SELF' then var_c='SELF_SUB'; else var_c=var_b; run; ... View more

@RandyStan wrote:   When I run the code; I get an error statement on the "DROP" part of the code Why withhold this information from us in your original post? Anyway, @Tom has explained what the error is.   But rarely do you need to split a data set like this. You could use a BY statement in whatever analyses you are doing, and then the splitting of the data set can be altogether avoided.   Even if you want to do separate analyses when VarA=1 or VarA=2, one data set suffices, and so you may be performing extra unnecessary work, and if this is a large dataset, splitting it like this takes up more storage and more execution time (well, that's also true if it is a small data set, but then you won't really notice the extra execution time). Example:   proc means data=have(where=(vara=1) Drop = VarF Rename = (VarM = VarMA VarN= VarNA)); /* more PROC MEANS statements */ run;   ... View more

Proc format ranges use the -  character to indicate a range is specified and use the < (and ONLY the < character) to indicate whether the value is included in the range or not 1 - 10     values 1 through 10 are in the range 1 <- 10   values from 1 to 10 EXCLUDING 1 are in the range 1 - <10  values from 1 to 10 excluding 10 are in the range 1 <-< 10 values from 1 to 10 but excluding both 1 and 10 are in the range.   A couple of special values are also available Low for the smallest non-missing value, High for the largest non-missing value you system uses. These can be useful when you aren't sure of an exact value   low -<0   all values less than 0 excluding 0 (i.e. all negative numbers) 50 <- high  all values greater than 50   And another special value range is OTHER where anything not explicitly included in some range is dumped: 1 - 10 ="range 1" 15-25 = "range 2" 30-43= "range 3" other = "everything else"  <= this would include missing unless you have specific assignment for missing ; You can mix ranges and lists of values in the same format as well.   Unless you really understand character comparisons do not expect ranges to work with character variables in general. Ranges can be used in character formats but the results are often not as expected. ... View more

Here some code could help.   ... View more

Proc summary will calculate the overall quantiles.   Example: proc summary data=have; var v1 v2 v3; output out=work.summary p10= p20= p30= p40= p50= p60= p70= p80= p90= /autoname; run; Will create the percentiles indicated. The variables will be named v1_<suffix of the percentile>. Put the variables you want on the var statement. Or don't and you will get percentiles of all the numeric variables. There is a technical concern about which definition may be used for the quantiles whic is controlled by the option QNTLDEF= <a value from 1 to 5>. The default is 5. The details have to do with boundaries for the quantiles and tie breakers.   If you want to know which decile a particular value falls into use Proc Rank with groups=10. Which will add a ranking variable with values of 0 to 9, 0 indicating the value is in the first decile and 9 in the 10th decile. proc rank data=have out=want groups=10; var v1 v2 v3; ranks rv1 rv2 rv3; run; The output data set will have the decile for v1 indicated in the variable rv1 and so forth. There is an option for the procedure TIES= that has parameter values of high, low, mean or dense which deals with how to assign ranks for tied values. The default is MEAN ... View more

Like this? data HAVE; do I=0 to 100; output; end; run; proc rank data=HAVE(where=(I ne 0)) groups=9 out=RANK; var I; ranks GRP ; run; data WANT; set HAVE(where=(I eq 0)) RANK(in=RANKED); GRP=sum(GRP,1)*RANKED; run;       ... View more

You can't mix PROC FREQ code with PROC FORMAT code. It should look like this:   proc format; value dim_groups 0-50='0-50' 51-76='51-76' ... ; /* You type the rest */ run; proc freq data=have; tables dim; format dim dim_groups.; run; I also have two Variables -- VARA and VARB.  I want to find the Average, MIN and MAX of those variables in each of these groups. proc summary data=have; var vara varb; class dim; format dim dim_groups.; output out=stats mean= min=min_vara min_varb max=max_vara max_varb; run; ... View more

Hi,   Among all nice, already provided, solutions the following also do the job:   data wday; input date date9.; format date date9.; cards4; 05AUG2019 06AUG2019 07AUG2019 08AUG2019 09AUG2019 13AUG2019 14AUG2019 16AUG2019 19AUG2019 ;;;; run; proc transpose data = wday out = wday (drop=_name_) prefix=wd; var date; run; data have; input ID_A : $ ID_B : $ date date9.; format date date9.; cards4; X A 05AUG2019 X A 07AUG2019 X A 13AUG2019 Y A 13AUG2019 Y A 16AUG2019 Y A 19AUG2019 M C 14AUG2019 ;;;; run; proc print; run; %let start=05AUG2019; %let end =19AUG2019; data want; array D[%sysevalf("&start."d):%sysevalf("&end."d)] _temporary_; sentinelA="A"; set wday; sentinelB="B"; array wdays sentinelA-numeric-sentinelB; do over wdays; D[wdays] = 1; end; do until (eof); set have end=eof; by ID_A notsorted; lag_date = ifn(first.ID_A, ., lag(date)); diff = -1; if date > lag_date > .z then do _N_ = lag_date to date; diff + d[_N_]; end; else diff = 0; output; end; stop; drop wd: sentinel: lag_date; run; proc print; run;   All the best Bart ... View more

Assuming the last value of varb in your example should be zero :   data want; count = 0; do until(last.id); set have; by id vara notsorted; if first.vara and vara = 0 then do; count + 1; varb = count; end; else varb = 0; output; end; drop count; run; ... View more

I think if you display your want in a clearer form: VarA Flag GroupRank_VARA 10 0 1 12 0 2 25 0 3 3 1 1 15 1 2 You want: proc rank data=have out= want groups=10; by Flag; var VarA; ranks GroupRank_VarA; run; Note the S in RANKS. Your code would have been throwing errors that maybe you should start with. And as with all BY statements you have to sort the data by the variables on the BY statement before use. Note that Proc Rank will create ranks of 0 to 9 when requesting groups=10. So if you really must have 1 to 10 you will need to take a pass through a data step to add 1. From the documentation for Proc Rank   GROUPS=number-of-groups assigns group values ranging from 0 to number-of-groups minus 1. ... View more

Similar to others: data want; set have; by id; _ldate=lag(date); _lvarA=lag(varA); if not(first.id) and not(_ldate le '01SEP2019'd le date) then lag_varA=_lvarA; drop _:; run; ... View more