About GuillermoPH

GuillermoPH · ‎06-19-2018

Hi SAS VA community! I'm dealing with a situation that is driving me nuts: when I choose to export data from a VA report to Excel, it messes up with date formats. For example, I have this graph I need to export in order to work with the data, it has a date variable named FECTERMINADO which in EG I set its format as datetime27.6; in VA it is formatted as MMMYYYY. When I export it to Excel I get a bunch of ##'s. I've tried everything but I keep failing on keeping the format... 😞 Please, any help will be much appreciated! Thanks in advance, regards;

GuillermoPH · ‎03-12-2018

Thanks a lot Bruno_SAS! It worked beautifully, I used the second option since I'm working on queries. Regards,

GuillermoPH · ‎03-12-2018

Hi! I'm trying to filter a data set that contains information from 2010 until yesterday. However, the goal here is to filter only data from the last month, i.e., suppose i have transactions from 10jan2018:18:29:45 to 11mar2018:14:23:39, and i only need those from 01feb2018:0:0:0 to 01mar2018:0:0:0. How can I do this? Notice I already used prompts but since this is going to be an automatic report, i need to have it hard coded without waiting for a user response in the middle of the project. Any help will be much appreciated!

GuillermoPH · ‎09-27-2017

Hello everyone! I'm trying to use the EXPORT Procedure, my coding looks like this: %let fecha = %sysfunc(date(),date9.); PROC SQL; CREATE TABLE WORK.Resumen_&fecha(label="RESUMEN") AS SELECT t1.CLAVECDR, /* Calificación */ (SUM(t1.RESULTADO)) FORMAT=PERCENT9.1 LABEL="Calificación" AS 'Calificación'n FROM WORK.RESULTADOS t1 GROUP BY t1.CLAVECDR; QUIT; proc export data=work.resumen_&fecha outfile="C:\Users\guiperez\Desktop\CEREBRO\Proveedores\Proyectos Especiales\Calificación CDRs" dbms=xls; quit; But everytime Irun it I get the exact same error: It's driving me nuts! I've been surfing the web for an answer but so far nothing seems to work... 😕 Any help will be much appreciated!

GuillermoPH · ‎09-18-2017

Yes, exactly what I was looking for! Just had to do a minor change in the coding (I already had the info sorted the way I wanted): data acumula; set ms_cdr; by EstadoCDR; retain Acumulado_MS; if first.EstadoCDR then Acumulado_MS = sum(0, ms_cdr); else Acumulado_MS = sum(Acumulado_MS, ms_cdr); run; Thanks a lot! You saved me 🙂

GuillermoPH · ‎09-18-2017

I'm using the GUI but I could write it down in code.

GuillermoPH · ‎09-18-2017

Hi! I'm trying to aggregate the following by EstadoCDR, buy i haven't been able to produce the desired result. Here's an example of how my DB looks like: In the end, i'd like to have this new column: Any help will be much appreciated! Regards,

GuillermoPH · ‎03-30-2017

Hello! I'm trying to calculate the difference between two dates but i don't want to take into account Sundays, how can this be done? eg. Say i'm trying to find the days between March, 2nd and March, 9th; the output should be '6'. Any help will be much appreciated. Greets,

GuillermoPH · ‎02-24-2017

I only had to change the format, it was quite easy actually. Thanks a lot!

GuillermoPH · ‎02-23-2017

Hello everyone! This is my first day as a VA Designer and i'm having trouble with Range Sliders. I'm trying to put in it a date called 'Fecha Expedicion' but it is in DATETIME format; what i need it is to be in a YYYYMM-ish format. For example: if i have '13 de Septiembre de 2010 06:58:43' it should be '2010Sep' or 'Sep2010', the order is not important; this way i'm expecting the slider to go trough complete months and not through days. Is there a way to do this in VA? I'm currently using the 6.3 version. Thanks in advance!

GuillermoPH · ‎05-27-2016

I get no matches because certainly I'm doing something wrong in my coding, that's why i'm asking for help. My previous reply has what the output should look like.

GuillermoPH · ‎05-27-2016

Yes, there are no matches. The result output should look like this: UNIDAD (FROM TABLE A) UNIDAD (FROM TABLE B) MARCA (FROM TABLE B) CS FORD F-350 CHASIS CABINA KT CS FORD F-450 CHASIS CABINA KTP XL PLUS TDI 6.4L AUT., 02 OCUP. FORD CS FORD F-350 CHASIS CABINA KT CS FORD F-450 CHASIS CABINA KTP XL PLUS TDI 6.4L STD., 02 OCUP. FORD CS FORD F-350 CHASIS CABINA KT CS FORD F-450 CHASIS CABINA KTP XL PLUS V10 6.8L AUT., 02 OCUP. FORD CS FORD F-350 CHASIS CABINA KT CS FORD F-450 CHASIS CABINA KTP XL PLUS V10 6.8L STD., 02 OCUP. FORD I assume if I use DISTINCT there would be only 1 row, however it'd look something like that.

GuillermoPH · ‎05-27-2016

Sure, sample data as text: First table: UNIDAD TR KENWORTH T 600 B 42" NISSAN TSURU GSII PLUS CS NISSAN CHASIS CABINA LARGO PY TOYOTA TACOMA TRD DOBLE CAB GMOTORS ACADIA V/P 4X4 MBENZ E-300 V6 SEDAN ADVANTGAR MBENZ GLK 300 CGI OFF ROAD SPO MBENZ SPRINTER 415 WAGON C/A T HYUNDAI / HYUNDAI GRAND I10 GL VW "EL NUEVO" JETTA A4 EUROPA CHEVROLET EXPRESS VAN SERVPUB RENAULT DUSTER EXPRESSION 4X2 CS FORD F-350 CHASIS CABINA KT FORD EXPLORER XLT 3.5L 290HP V DODGE NITRO SLT 4X2 Second table: UNIDAD MARCA CS FORD F-350 KTP XL CH 2P V8 6.2L 2WD AC 3.5TON AUT., 03 OCUP. FORD CS FORD F-350 KTP XL PLUS CH 2P V8 6.2L AC 3.5TON STD., 03 OCUP. FORD CS FORD F-350 KTP XL PLUS CH 2P V8 6.2L EFI AC R17 AUT., 02 OCUP. FORD CS FORD F-350 KTP XLT CH 2P V8 6.2L 2WD 3.5TON STD., 03 OCUP. FORD CS FORD F-450 CHASIS CABINA KTP 6.7L V8 TDI AUT., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA KTP XL PLUS TDI 6.4L AUT., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA KTP XL PLUS TDI 6.4L STD., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA KTP XL PLUS V10 6.8L AUT., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA KTP XL PLUS V10 6.8L STD., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA S.D XL A/AC DIESEL STD., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA SUPER DUTY XL A/AC STD., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA SUPER DUTY XL BA STD., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA SUPER DUTY XL DIESEL STD., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA SUPER DUTY XL GAS LP STD., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA SUPER DUTY XL STD., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA XL V10 A/AC BA STD., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA XL V10 C/A AC STD., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA XL V8 C/A AC DIESEL STD., 02 OCUP. FORD CS FORD F-450 CHASIS CABINA XL V8 DIESEL AUT., 02 OCUP. FORD Thanks!

GuillermoPH · ‎05-27-2016

Thanks ballardw, maybe i should've been more precise: the data you see in A is part of what i have in B. In some cases yes, it is user entered however the major part is "trimmed" but not to the same length (it varies, not sure why). Eg. from A you would get " TR KENWORTH T 600 B 42" " in the first row; in B it would look like " TR KENWORTH T 600 B 42" STD., 02 OCUP. ", If I do a manual search using a query and filtering UNIDAD contains TR KENWORTH T 600 B 42", it works perfectly. Of course I can't do this process 250k+ times manually not sure if i explained myself... sure there's a way i can do this automatically

GuillermoPH · ‎05-27-2016

Hi everyone! I'm a new user of EG and i'm fascinated with the capabilities of the tool. Rigth now i'm working on two datasets, the first one (A) is 250k+ rows and 25 columns, the second one (B) is around 25k rows and only 2 columns. I'm trying to do sort of a VLOOKUP, getting info from B that matches A and put it in C (new table) but there's two things: i haven't found a way of joining them the easy way (using queries); the other one I tried doing it programming but i'm not an expert in this language. This is what i've tried, in separate, but doesn't seem to be working: PROC SQL; CREATE TABLE C AS SELECT DISTINCT t1.UNIDAD, t2.unidad as unidad1, t2.marca FROM QUERY_FOR_PAGOSPROVEEDORES t1 LEFT JOIN MARCAS_Y_UNIDADES1 t2 ON (t1.UNIDAD LIKE t2.UNIDAD); QUIT; proc sql; create table test as select t1.UNIDAD, t2.UNIDAD from work.query_for_pagosproveedores t1, work.marcas_y_unidades1 t2 where upcase(marcas_y_unidades1.UNIDAD) contains upcase(query_for_pagosproveedores.UNIDAD); quit; Also, a couple of images from both A and B datasets: How can i do this? Thanks in advance, any help will be much appreciated! NOTE: data in A repeats. I'm using SAS EG 5.1 (64-bit).

Online Status	Offline
Date Last Visited	‎06-21-2018 11:05 AM

Trouble keeping date format when exporting to Excel

Re: Filter last month

Filter last month

ERROR: Physical file does not exist, /sas/Config/Lev1/SASApp/

Re: Cumulative frequency

Re: Cumulative frequency

Cumulative frequency

Difference between two dates

Re: Manipulate dates to convert them into ranges

Manipulate dates to convert them into ranges

Re: MONNAME(MONTH(tbl.field_name))

Re: Filter last month

Re: ERROR: Physical file does not exist, /sas/Config/Lev1/SASApp/

Re: Cumulative frequency

Re: Difference between two dates

Trouble keeping date format when exporting to Excel

Re: Filter last month

Filter last month

ERROR: Physical file does not exist, /sas/Config/Lev1/SASApp/

Re: Cumulative frequency

Re: Cumulative frequency

Cumulative frequency

Difference between two dates

Re: Manipulate dates to convert them into ranges

Manipulate dates to convert them into ranges

Re: How do I compare two datasets using string variables?

Re: How do I compare two datasets using string variables?

Re: How do I compare two datasets using string variables?

Re: How do I compare two datasets using string variables?

How do I compare two datasets using string variables?