About Thalitacosta

Thalitacosta · ‎10-11-2021

I have 2 tables (A and B) with the columns: In A: Leaf, Total, Prob_A In B: Leaf, Total, Prob_B I need to join these 2 tables (in C), but when I do "full join" by "proc sql", it's returning: In C: Leaf, Total, Prob_A, Prob_B But only the variable "Leaf" is the key, the "Total" has diferente values. How to return the "Total" from th 2 tables? Thus: C: Leaf, Total_A, Total_B, Prob_A, Prob_B

Thalitacosta · ‎09-08-2021

I made the following graph, but I want to do it in line format. What code to use? proc sgplot data=nv pctlevel=group; vbar month/ stat=pct seglabel; run;

Thalitacosta · ‎09-06-2021

I have the variable "date" whose format is in "03APR2020:00:00:00.000", but I want to make a new variable "dt" using only "202004". What code can I use? Code below is wrong: data tabl1; set tabl; dt = year(date) + month(date); run;

Thalitacosta · ‎09-06-2021

I have the variable "date" whose format is in yyyymmdd, but I want to make a new variable "year_month" using only yyyymm. What code can I use?

Thalitacosta · ‎09-06-2021

I have a date variable, but I need to unite all that are part of the same month. What code to use?

Thalitacosta · ‎08-24-2021

The code below is returning 0 for all values below 0, including missing values. How to count missing values separately? proc sql; create table xxx as select *, case when pd < 0 then 0 else case when pd>= 1.3220535 then 1.3220535 else pd end end as pd_new*/ from tab ; quit;

Thalitacosta · ‎08-19-2021

I have many variables in database called AT_1, AT_2, AT_3, ..., AT_599, AT_600, and I want to add them up and insert a variable in the same database called "sum_AT". Variables: AT_1 = 0 or 1, .... , AT_600 = 0 or 1

Thalitacosta · ‎08-06-2021

I have a big database, with the variables: leaf, lgd, in_default. I need a table of frequencies that give the average lgd per sheet na in_default. And also the total percentage of dissipation per sheet. I need it, for example: LEAF IN_DEFAULT=0 IN_DEFAULT=0 ALL IN_DEFAULT PERCENT MEAN(LGD) 1 2 0 2 22% 0,33 2 1 2 3 33% 0,25 3 2 2 4 45% 0,325 ALL 5 4 9 DATABASE I HAVE: LEAF LGD IN_DEFAULT 1 0,15 0 2 0,25 1 3 0,35 1 3 0,23 0 2 0,27 1 3 0,31 1 3 0,41 0 2 0,22 0 1 0,51 0

Thalitacosta · ‎08-05-2021

The variable "in_default" has the observations 0 and 1. In results, table "Proportion (risk) Difference Test" calculates for "in_default" equal to 0. Is there how to obtain this table for "in_default" equal to 1? Follow the code I used: proc freq data=test; weight pd; tables leaf*in_default / riskdiff(equal var=null); run;

Thalitacosta · ‎08-02-2021

Why are you only doing the operations until the FOLHA=5? data base1; set base; if segmento_final ~= "varejo classic" and qtde_parcela < 6.5 then folha = 1; else if segmento_final ~= "varejo classic" and 6.5 <= qtde_parcela < 18.5 then folha = 2; else if segmento_final ~= "varejo classic" and 18.5 <= qtde_parcela and escore_348 < 230 then folha = 3; else if segmento_final ~= "varejo classic" and 18.5 <= qtde_parcela and 230 <= escore_348 < 320.5 then folha = 4; else if segmento_final ~= "varejo classic" and 18.5 <= qtde_parcela and 320.5 <= escore_348 then folha = 5; else if segmento_final = "varejo classic" and 6.5 > qtde_parcela and 130.5 > escore_348 then folha = 6; else if segmento_final = "varejo classic" and 6.5 > qtde_parcela and 130.5 <= escore_348 < 255.5 then folha = 7; else if segmento_final = "varejo classic" and 6.5 > qtde_parcela and escore_348 >= 255.5 then folha = 8; else if segmento_final = "varejo classic" and 6.5 <= qtde_parcela < 18.5 and escore_348 < 157.5 then folha = 9; else if segmento_final = "varejo classic" and 6.5 <= qtde_parcela < 18.5 and 157.5 <= escore_348 < 267.5 then folha = 10; else if segmento_final = "varejo classic" and 6.5 <= qtde_parcela < 18.5 and 267.5 <= escore_348 then folha = 11; else if segmento_final = "varejo classic" and 18.5 <= qtde_parcela and escore_348 < 172.5 then folha = 12; else if segmento_final = "varejo classic" and 18.5 <= qtde_parcela and 172.5 <= escore_348 < 295.5 then folha = 13; else folha = 14; run;

Thalitacosta · ‎07-29-2021

I used only N: Proc tabulate data=base; class month leaf type_client; table month*leaf, type_client*n ; run; But now I need to add the total (all) at the end of each line (sum of the observations of 0 and 1). So it looks like this: type_client 0 1 month leaf N N ALL 1 3 21188 529 21717 1 5 25208 1066 26274

Thalitacosta · ‎07-29-2021

Perfect! The code helped me. Sorry for the spelling mistakes, I don't know english, I'm Brazilian.

Thalitacosta · ‎07-29-2021

From the code:: proc freq data=base; by month; tables type_client*leaf / out=data1; run; I created the table below, but I need it to have the following variables: month, leaf, count_type_client (if 0), count_type_client (if 1). That is, I need to separate the variable "type_client" into two columns, if 0 and if 1. OUTDATA created: month type_client leaf count percent 1 0 3 21188 19.59 1 0 5 25208 23.31 1 0 7 7566 6.99 1 1 3 529 0.49 1 1 5 1066 0.98 1 1 7 522 0.48 2 0 3 23253 16.94 2 0 5 39683 28.91 2 0 7 12354 9.00 2 1 3 632 0.46 2 1 5 2044 1.49 2 1 7 871 0.63

Thalitacosta · ‎07-29-2021

Bom dia! A partir do código: proc freq data=base; by mês; tables tipo_cliente*folha / out=data1; run; Criei a tabela a seguir, mas preciso que ela fique com as seguintes variáveis, respectivamente: mes, folha, count_tipo_cliente (se for 0), count_tipo_cliente (se for 1). Ou seja, preciso separar a variável "tipo_cliente" em duas colunas, caso seja 0 e caso seja 1. OUTDATA criada: mes tipo_cliente folha count percent 1 0 3 21188 19.59 1 0 5 25208 23.31 1 0 7 7566 6.99 1 1 3 529 0.49 1 1 5 1066 0.98 1 1 7 522 0.48 2 0 3 23253 16.94 2 0 5 39683 28.91 2 0 7 12354 9.00 2 1 3 632 0.46 2 1 5 2044 1.49 2 1 7 871 0.63

Thalitacosta · ‎07-27-2021

B

Online Status	Offline
Date Last Visited	‎01-03-2024 10:45 AM

Select variables dataset

Re: INTNX

INTNX

Proq freq out

proc append - length

Create variable

SUM OUTPUT DATA

Re: proc anova

Re: proc anova

Re: proc anova

Re: SUM OUTPUT DATA

Re: SORT

Re: MACRO

Re: PROC MEANS

Re: Table

Re: Organizar tabela

proc sql

Line Graph

Date

Date

Date

Missing in proc sql

Analyzes

Percent e Freq

Proportion (risk) Difference Test

If/ then

Re: Organizar tabela

Re: Organizar tabela

Organizar tabela

Organização de tabela

Re: Dinamica Webinar: Saindo do Excel entrando no mundo SAS