yesterday
Tecla1
Quartz | Level 8
Member since
10-19-2018
- 87 Posts
- 17 Likes Given
- 1 Solutions
- 2 Likes Received
-
Latest posts by Tecla1
Subject Views Posted 403 yesterday 413 yesterday 446 yesterday 447 yesterday 537 yesterday 705 12-18-2024 10:14 AM 736 12-18-2024 08:41 AM 751 12-18-2024 08:34 AM 755 12-18-2024 08:32 AM 765 12-18-2024 08:23 AM -
Activity Feed for Tecla1
- Posted Re: Da Access SQL a SaS on SAS Programming. yesterday
- Posted Re: Da Access SQL a SaS on SAS Programming. yesterday
- Posted Re: Da Access SQL a SaS on SAS Programming. yesterday
- Posted Re: Da Access SQL a SaS on SAS Programming. yesterday
- Posted Da Access SQL a SaS on SAS Programming. yesterday
- Liked SAS Communities wins recognition for use of data and insights! for ChrisHemedinger. 01-24-2025 03:00 AM
- Posted Re: populate a variable wiìth number if a condition is verified on SAS Programming. 12-18-2024 10:14 AM
- Liked Re: populate a variable wiìth number if a condition is verified for Tom. 12-18-2024 10:14 AM
- Posted Re: populate a variable wiìth number if a condition is verified on SAS Programming. 12-18-2024 08:41 AM
- Posted Re: populate a variable wiìth number if a condition is verified on SAS Programming. 12-18-2024 08:34 AM
- Posted Re: populate a variable wiìth number if a condition is verified on SAS Programming. 12-18-2024 08:32 AM
- Liked Re: populate a variable wiìth number if a condition is verified for Tom. 12-18-2024 08:31 AM
- Posted Re: populate a variable wiìth number if a condition is verified on SAS Programming. 12-18-2024 08:23 AM
- Posted populate a variable wiìth number if a condition is verified on SAS Programming. 12-18-2024 07:21 AM
- Posted Re: numeric missing values - export in excell on SAS Programming. 12-18-2024 03:28 AM
- Liked Re: numeric missing values - export in excell for PeterClemmensen. 12-18-2024 03:27 AM
- Posted Re: numeric missing values - export in excell on SAS Programming. 12-18-2024 03:18 AM
- Posted numeric missing values - export in excell on SAS Programming. 12-18-2024 03:15 AM
- Posted Re: labels on New SAS User. 11-26-2024 09:17 AM
- Posted Re: labels on New SAS User. 11-26-2024 09:16 AM
-
Posts I Liked
Subject Likes Author Latest Post 10 1 3 1 1 -
My Liked Posts
Subject Likes Posted 2 12-16-2021 08:56 AM
yesterday
... INNER JOIN (select a,c,c from x.y) q_ultimi_ia_3 ON ...
What mean "x.y"
Tnks
Tecla
... View more
yesterday
Tnks,
"q_ultimi_ia_3 " is not a table , is another query.
In Access is possible to use query like a "Matriosca" in SaS can I do that?
Tnks a lot.
Tecla
... View more
yesterday
Hi, many tnks for your kindly help, I try with ChatGPT and I receive a Good Replay. The problem are the query who recall some other query, so in the same time Access run al querys in the same time as :
Where q_ultimi_ia_3 is another query. In a SQL can I recall another SQL?
"...................
INSERT INTO IA_base ( iau_id, azie_id, uop_cod, iab_amb, iau_dui, iab_vui, iab_pui, iab_ggt ) SELECT interventi_audit.iau_id, interventi_audit.azie_id, interventi_audit.uop_cod, 3 AS Espr2, interventi_audit.iau_dui, interventi_audit.iau_vro, giudizi_audit.gia_per, ExcelDays365(CDate([data]),[iau_dui]) AS gg FROM (interventi_audit LEFT JOIN giudizi_audit ON interventi_audit.iau_vro = giudizi_audit.[gia_val]) INNER JOIN q_ultimi_ia_3 ON (interventi_audit.azie_id = q_ultimi_ia_3.azie_id) AND (interventi_audit.uop_cod = q_ultimi_ia_3.uop_cod) AND (interventi_audit.iau_dui = q_ultimi_ia_3.iau_dui) AND (interventi_audit.dataa = q_ultimi_ia_3.dataa) ORDER BY interventi_audit.iau_dui DESC;
.................."
Tnks a lot !.
Tecla
... View more
yesterday
Good morning,
I have to translate a series of Access queries in SaS, in particular I don't know how to translate the queries that call other queries... is there a translator available?
Many tnks for your kindly help.
Tecla
... View more
12-18-2024
08:41 AM
Hi Tom, I see well your first replay. Tnks a lot. Tecla
... View more
12-18-2024
08:34 AM
Hi Tom, i need the format but it's non important for the result !! I have a question: why "first." wasn't a good solution? Tnks a lot !!
... View more
12-18-2024
08:32 AM
Hi Tom many tnks for your kindly help!!! after your replay everything seems so simple !!! I tnks all community for the help everityme it give.... have a nice new Year !!!
... View more
12-18-2024
08:23 AM
Hi bluefish, many tnks, you are rigth, I was trying more solution but I know what you have explained so well... Now i try your kindly solution ....
... View more
12-18-2024
07:21 AM
Hi to all,
I need you another time...
In the case a variable is not populate i need to put a number that is the maxmum of the variable +1. I try with this:
PROC SORT DATA= &nome_tab6.&load_date_g._3;
BY descending TBU_NUMREK ;
DATA &nome_tab6.&load_date_g._4;
SET &nome_tab6.&load_date_g._3;
format c bestd5.;
RETAIN C;
c=first.TBU_NUMREK;
IF NOT MISSING(TBU_NUMREK) THEN TBU_NUMREK=TBU_NUMREK;
ELSE TBU_NUMREK=C+1;
RUN;
TBU_5CODUF
TBU_NUMREK
00845
7681
06064
7682
06084
7683
00687
7684
08534
7685
08535
7686
08540
7687
08545
??????
08550
08555
08560
08565
08570
08575
08580
08585
08590
... View more
12-18-2024
03:28 AM
Thank you very much Peter!! The whole community is always very helpful and kind... I wish everyone a very happy new year!!
... View more
12-18-2024
03:18 AM
Hi, Tnks,
ods excel file="&outputname." options(autofilter="1-6" sheet_name="&sheetname.");
proc print data=&libname..&dataname. label; run;
ods excel close;
... View more
12-18-2024
03:15 AM
Hello everyone,
is it possible to avoid exporting the "dot" in empty numeric cells to excell?
Thank you very much,
Tecla
... View more