About fri0

fri0 · ‎04-03-2019

I copied the second table to a table in the work library and the query works... This has no sense to me, if the problem would be space, I couldn't make a copy of any table right?

fri0 · ‎04-03-2019

HI, I'm doing a left join using a proc sql but I get this error: ERROR: Sort key definition failure. This is a query that I've executed before without no problems: proc sql; create table work.data as select a.codunicocli, b.codclavecic, b.apepatcli, b.apematcli, b.nbrcli from work.febrero as a left join ods_v.md_cliente as b on a.codunicocli=b.codunicocli; quit; Any suggestion to solve it? Thanks! PD. I'm using SAS Enterprise Guide 7.1

fri0 · ‎08-02-2018

Hi draycut, I checked the keylegend statement, got better output, but I have the same problem when I included the markerattrs option. After many changes, I realize that the problem appears when you use pct as measure for the size marker, I changed it to mm and the legend appears. Thanks!!!

fri0 · ‎08-02-2018

Hi! 1. Justo to show the legend next to the graph, I don't want to have label over the markers. Is there a better way?. 2. Ok, It's needed a previous template. Thanks!

fri0 · ‎08-02-2018

Hi, I'm using EG 7.12 and I have a problem when I use markerattrs. (NBRSUCAGE is the variable with the label names for the graph legend) Using this code, the legend appears: proc sgplot data=stats.cuadro; scatter x=var16_17 y=ING17 /group=NBRSUCAGE name="ag"; discretelegend "ag" / title="Agencias"; title "Variación 2016- 2017 vs Ingresos"; run; But, when I agree the markeratrrbs option, the legend disappears: proc sgplot data=stats.cuadro; scatter x=var16_17 y=ING17 /group=NBRSUCAGE markerattrs=(symbol=circlefilled size=3pct) name="ag"; discretelegend "ag" / title="Agencias"; title "Variación 2016- 2017 vs Ingresos"; run; How could I maintain the changes without losing the legend? Also, It would be a plus if there is any way to have different symbols for markers without coding a previous template. Thank you very much!

fri0 · ‎03-05-2018

It totally works! Thanks you very much!

fri0 · ‎03-02-2018

Hi! if you said it for the words 'ing', 'dem' and 'ofe', it's just to probe the code. But I couldn't get those prints.

fri0 · ‎03-02-2018

Hi! I'm trying to use this macro, but I have a problem with the first "If" conditional, it's like SAS doesn't read the if, and jump all the marked part in the code. Could anyone please tell me what is wrong in the code? (The line 96 has the category Ingreso for the clase column) Thanks in advance! %macro recorre; proc sql noprint; SELECT count(*) INTO :total FROM WORK.DATA_DIA; quit; %Do I = 96 %to 96; proc sql noprint; SELECT tipo, clase, horanum INTO :n_tipo, :n_clase, :n_hora FROM WORK.DATA_DIA where n = &I; quit; %put &n_clase; *Begin error; %if &n_clase = 'Ingreso' %then %do; %put 'ing'; %if &n_tipo = 'Demanda' %then %do; %put 'dem'; %end; %else %do; %put 'ofe'; %end; *End error; %end; %put Fin; %End; %mend recorre; %recorre;

fri0 · ‎02-19-2018

Hi, I googled about retain to build my code, but it's not perfect yet... This is my code so far: data data_lay2; set data_lay1; by fecha hora; retain lapse compra cod dif 0; if hora>=lag(hora) then do; if tipo='Demanda' and clase='Ingreso' then compra+1; if codigo ne lag(codigo) then cod+1; dif=intck('second',lag(hora),hora); if lapse=. then lapse=0; lapse=lapse+dif; if compra>=5 and cod>=5 and tipo='Oferta' then flag=1; end; if lapse>50 then lapse=0 and compra=0 and cod=0 and dif=0; run;

fri0 · ‎02-14-2018

Yes, a indicator variable in the same row that the opposite category appears.

fri0 · ‎02-13-2018

Hi, I need your help to count values of a variable but with a condition based on time ranges of another variable. This is my data: Date Time Type 01-dic 08:00:10 Demanda 01-dic 08:00:13 Demanda 01-dic 08:00:14 Oferta 01-dic 08:00:16 Oferta 01-dic 08:00:19 Demanda 01-dic 08:00:24 Demanda 01-dic 08:00:24 Oferta 01-dic 08:00:30 Demanda 01-dic 08:00:31 Demanda 01-dic 08:00:34 Oferta 01-dic 08:00:34 Oferta 01-dic 08:00:41 Demanda 01-dic 08:00:42 Demanda 01-dic 08:00:53 Demanda 01-dic 08:00:53 Demanda 01-dic 08:00:53 Demanda 01-dic 08:01:02 Oferta 01-dic 08:01:02 Oferta 01-dic 08:01:12 Demanda 01-dic 08:01:12 Demanda 01-dic 08:01:17 Oferta 01-dic 08:01:21 Oferta 01-dic 08:01:24 Demanda 01-dic 08:01:29 Oferta 01-dic 08:01:35 Oferta 01-dic 08:01:39 Demanda 01-dic 08:01:39 Oferta 01-dic 08:01:39 Oferta 01-dic 08:01:42 Demanda I have to find in 50 seconds time ranges, if there are 5 or more "Demanda" Category and a "Oferta" just after that or also the opposite case, 5 o more "Oferta" followed by a "Demanda". Please I have no experience with loops or arrays, I tried to code a loop, but I do not how to make a reference to previous values of another variable. I would really appreciate if you could explain me the lines in your code to understand each step. Thank you very much!

fri0 · ‎11-24-2017

Thank you! I will have to change my code.

fri0 · ‎11-24-2017

Hi, I have a problem using a date with monyy5 format. I created the from a ddmmyy10. using this code: FECHA2=put(fecha,monyy7.); /*FECHA2 is the original date variable with ddmmyy10. format*/ MES=input(fecha2,monyy7.); /*MES is my variable for an only month year date*/ format MES monyy5.; /*Format for my new date variable*/ After that, I have a variable that only has month and year, but my problem is when I want to do a select distinct. For example, for the original date variable has two dates in april: 10/04/2017 and 18/04/2017. The new variable shows apr17 for both obs. When I run a select distinct query, it should appear only 1 obs showing apr17 (the rest of the variables are the same), but this not happens... I think internally SAS keeps the day of the date? How could I created a date variable that only has month and year? Thanks in advance!

fri0 · ‎07-27-2016

Nop, the objective is identify group of clients based in their money movement and number of operations. Using the replacement node, I could find 3 clusters... well at least is something jejejej

fri0 · ‎07-27-2016

Yes, I ran a scatterplot and I could see about 3-4 groups, but, I just ran a density graph because I think the scatterplot could be a little tricky. The groups that I saw don't have son many observations as I thought... =( Please, could you check the attached images and give me your opinion please? Edit.PS. Do you know about Range standarization? When is a good idea to use it?

Online Status	Offline
Date Last Visited	‎04-03-2019 08:45 PM

Re: Error trying to make a left join

Error trying to make a left join

Re: Problem with legend in scatterplot

Re: Problem with legend in scatterplot

Problem with legend in scatterplot

Re: Macro doesn't read the conditional

Re: Macro doesn't read the conditional

Macro doesn't read the conditional

Re: Loop with conditional range

Re: Loop with conditional range

Re: Macro doesn't read the conditional

Re: Macro doesn't read the conditional

Re: Macro doesn't read the conditional

Re: Macro doesn't read the conditional

Re: Loop with conditional range

Re: Error trying to make a left join

Error trying to make a left join

Re: Problem with legend in scatterplot

Re: Problem with legend in scatterplot

Problem with legend in scatterplot

Re: Macro doesn't read the conditional

Re: Macro doesn't read the conditional

Macro doesn't read the conditional

Re: Loop with conditional range

Re: Loop with conditional range

Loop with conditional range

Re: SAS Date MONYY problems

SAS Date MONYY problems

Re: Improve K-Means results

Re: Improve K-Means results