How to sort the variable "rating" so that the value "AA" is first than "A"? Because my results are coming out like this: A01 A02 A03 AA01 AA02 AA03 B01 B02 B03 C01 C02 C03   CODE: proc sql; create table resul_perf as select date, varl, qtde_def, case when def = 1 then sum(qtde_def)-qtde_def end as qtde_good, sum(qtde_def) as qtde_total from perf group by DATE,variavel having def = 1; run;     ... View more

I have a "MOD" period that goes from OCt/2019 to Dec/2019 and another "OOT" period that goes from Jan/2020 to MAR/2020.   How do I call these values only once? Because in the code I have, I need to declare it in "LET" and at the end of the macro another six times.   %let dt1_mod_start = 201910; %let dt2_mod_end = 201912; %let dt1_oot_start = 202001; %let dt2_oot_end= 202003;   %MACRO PSI (dt);   data dtbase1; set dtbase; if &dt1_mod_start. <= put(dta,yymmn6.) <= &dt2_mod_end. then period = "MOD"; else if &dt1_oot_start. <= put(dta,yymmn6.) <= &dt2_oot_end. then period = "OOT"; else period = "OTHER"; run;   proc sql; create table perf_&dt. as select dta format yymmn6. as date, period, leaf, in_default, count(*) as total from dtbase1 where put(dta,yymmn6.) in ("&dt.") group by date,period,leaf,in_defaul; quit; %mend; %PSI (201910); %PSI (201911); %PSI (201912); %PSI (202001); %PSI (202002); %PSI (202003);   ... View more

How to put the following statistics in output data:   proc means data=&bib..&base. n sum min p1 p5 p10 p25 p50 p75 p90 p95 p99 max mean missing; var &vari.; run;   ... View more

I have an "X" and "Y" database, in which they were supposed to be the same, but in "X there are more observations than in "Y". To better understand how observations over "X", I want to create a new database wich just those observations. Does anyone know the codes to do this? ... View more

I have two date variables that I need to format the variable "dt" has the "DDMMYY10." format; and the variable "dt_current" has the "E8601DT26.6" format. When I do the code below, the variable "dt_current" does not return the format I want. What format should I use? proc sql; create table NV2 as select DT format=monyy5., DT_CURRENT format=monyy5. from NV1; quit; ... View more

I have two date variables that I need to format: - the variable "dt" has the "DDMMYY10." format; and - the variable "dt_current" has the "E8601DT26.6" format. When I do the code below, the variable "dt_current" returns missing. What format should I use? proc sql; create table NV2 as select DT format=monyy5., DT_CURRENT format=monyy5. from NV1; quit; ... View more

I have two date variables that I need to format: - the variable "dt" has the "DDMMYY10." format; and - the variable "dt_current" has the "E8601DT26.6" format. When I do the code below, the variable "dt_current" returns missing. What format should I use? proc sql; create table NV2 as select DT format=monyy5., DT_CURRENT format=monyy5. from NV1; quit; ... View more

I need to create in a table the results below for each month. Should I make a macro: Like?   %let dt = ("202006"); proc sql; create table calc2 as select DATE, '00'n, default, total, sum(default) as total_def, default / sum(default) as dist_def from calc1 where put(DATE,yymmn6.) = &dt.; quit;   ... View more

I have a variable "date" in the format "jun20" (MONYY5.). I'm creating a new table, doing some calculations per month, but I can"t select just for months. What to do?   proc sql; create table calc2 as select DATE, '00'n, no_default, default, total, sum(default) as total_no_d, sum(no_default) as total_def, default / sum(default) as dist_no_d, no_default / sum(no_default) as dist_def from calc where DATE = 'JUN20'; quit;   ... View more