cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Tecla1
‎05-19-2025
  • 88 Posts
  • 19 Likes Given
  • 1 Solutions
  • 2 Likes Received

Re: DIFFERENZE TRA RIGHE SUCCESSIVE

by Quartz | Level 8 in SAS Programming
‎12-16-2021 08:56 AM
2 Likes
‎12-16-2021 08:56 AM
2 Likes
Many Tnks!!! IT's more symple than I could think. Have a nice afternoon!!! Tecla ... View more

DIFFERENZE TRA RIGHE SUCCESSIVE

by Quartz | Level 8 in SAS Programming
‎12-16-2021 07:00 AM
‎12-16-2021 07:00 AM
Buongiorno a tutti, devo creare una colonna che contenga la differenza tra un dato ed il suo precedente, ho provato con "retain" ma non riesco, potete aiutarmi? Grazie ·       · ... View more

Re: PROC SQL DB WITH SAME COLUMNS

by Quartz | Level 8 in SAS Programming
‎04-06-2021 03:17 AM
‎04-06-2021 03:17 AM
Tnks for your kindly replay. Tecla ... View more

PROC SQL DB WITH SAME COLUMNS

by Quartz | Level 8 in SAS Programming
‎04-01-2021 03:40 AM
‎04-01-2021 03:40 AM
Good morning to all and many thnks for your kindly help !!! I need to do a Proc Sql with two DB that has the same named columns and I need to keep all them, there is a way to rename automatically the second columns DB?   Many tnks Tecla ... View more

Re: Installments

by Quartz | Level 8 in SAS Programming
‎11-03-2020 03:30 AM
‎11-03-2020 03:30 AM
Good morning, the order is the time…. but not the date … Tnks !!! ... View more

Re: Installments

by Quartz | Level 8 in SAS Programming
‎11-02-2020 03:25 AM
‎11-02-2020 03:25 AM
Good Morning, Tnks for your help, I expect date as the example, where columns name are STL_1, STL_2 … ecc...) Tecla ... View more

Re: Installments

by Quartz | Level 8 in SAS Programming
‎10-30-2020 05:07 AM
‎10-30-2020 05:07 AM
Good morning, I sent in a format as request from your Mr. Bremser, It' s good now ? Tnks to All. Tecla ... View more

Re: Installments

by Quartz | Level 8 in SAS Programming
‎10-29-2020 01:47 PM
‎10-29-2020 01:47 PM
CHIAVE STL_1 STL_2 STL_3 STL_4 STL_5 STL_6 STL_7 STL_8 STL_9 STL_10 STL_11 STL_12 STL_13 STL_14 STL_15 STL_16 STL_17 STL_18 STL_19 5540306388550000 56312.66 56373.9 56435.20 56496.58 56558.02 56619.52 56681.10 56742.74 56804.44 56866.22 56928.06 56989.97 57051.95 57113.99 57176.10 57238.28 57300.53 57362.81 5540807460420000 3380.1 3388.66 3397.25 3405.86 3414.49 3423.15 3431.82 3440.52 3449.24 3457.98 3466.74 3475.53 3484.33 3493.16 3502.01 3510.89 3519.79 3528.71 3537.65 054Z0010951830000 11435.59 11549.94 11665.44 11782.10 11899.92 12018.90 CHIAVE NOV20 DEC20 JAN21 FEB21 MAR21 APR21 MAY21 JUN21 JUL21 AUG21 SEP21 OCT21 NOV21 DEC21 JAN22 FEB22 MAR22 APR22 MAY22 JUN22 JUL22 AUG22 SEP22 OCT22 NOV22 DEC22 JAN23 FEB23 MAR23 APR23 MAY23 JUN23 JUL23 AUG23 SEP23 OCT23 NOV23 DEC23 JAN24 FEB24 MAR24 APR24 MAY24 JUN24 JUL24 AUG24 SEP24 OCT24 NOV24 DEC24 JAN25 FEB25 MAR25 APR25 MAY25 JUN25 JUL25 AUG25 SEP25 OCT25 NOV25 DEC25 JAN26 FEB26 MAR26 APR26 MAY26 JUN26 JUL26 AUG26 SEP26 OCT26 NOV26 DEC26 JAN27 FEB27 MAR27 APR27 MAY27 JUN27 JUL27 AUG27 SEP27 OCT27 NOV27 DEC27 JAN28 FEB28 05540306388550000 56312.66 . . 56373.9 . . 56435.20 . . 56496.58 . . 56558.02 . . 56619.52 . . 56681.10 . . 56742.74 . . 56804.44 . . 56866.22 . . 56928.06 . . 56989.97 . . 57051.95 . . 57113.99 . . 57176.10 . . 57238.28 . . 57300.53 . . 57362.81 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 05540807460420000 . . . 3380.1 3388.66 3397.25 3405.86 3414.49 3423.15 3431.82 3440.52 3449.24 3457.98 3466.74 3475.53 3484.33 3493.16 3502.01 3510.89 3519.79 3528.71 3537.65 3546.61 3555.6 3564.61 3573.64 3582.7 3591.78 3600.88 3610.01 3619.16 3628.33 3637.52 3646.74 3655.98 3665.25 3674.53 3683.85 3693.18 3702.54 3711.92 3721.33 3730.76 3740.22 3749.69 3759.20 3768.72 3778.27 3787.85 3797.45 3807.07 3816.72 3826.39 3836.09 3845.81 3855.55 3865.32 3875.12 3884.94 3894.79 3904.66 3914.55 3924.47 3934.42 3944.39 3954.38 3964.4 3974.45 3984.52 3994.62 4004.74 4014.89 4025.06 4035.26 4045.49 4055.74 4066.02 4076.32 4086.65 4097.01 4107.39 4117.8 4128.24 4138.7 4149.19 4159.7 4170.24 4180.49 054Z0010951830000 . 11435.59 . . . . . 11549.94 . . . . . 11665.44 . . . . . 11782.10 . . . . . 11899.92 . . . . . 12018.90 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ... View more

Re: Installments

by Quartz | Level 8 in SAS Programming
‎10-29-2020 11:13 AM
‎10-29-2020 11:13 AM
Good afternoon, many tnks for your kindly help, in attached how many you request. tnks, Tecla ... View more

Installments

by Quartz | Level 8 in SAS Programming
‎10-29-2020 03:47 AM
‎10-29-2020 03:47 AM
Good morning to all, please I need a solution to this problem can I have your help? In attached an excell file to explain well….   Many tnks!       ... View more

Re: List columns names contained in a db

by Quartz | Level 8 in SAS Programming
‎10-15-2020 09:23 AM
‎10-15-2020 09:23 AM
Tnks Andreas, I need to put column names in a new DB line by line. ... View more

List columns names contained in a db

by Quartz | Level 8 in SAS Programming
‎10-15-2020 09:08 AM
‎10-15-2020 09:08 AM
Good Afternoon, I often need to go into DB to check the right name of column …. there is a data that show alla names of columns? I read more document but i have not find a right refer.   Many thnks for your kindly help. Tecla ... View more

Re: Export a DB in an excel file - format "time"

by Quartz | Level 8 in SAS Programming
‎05-05-2020 07:08 AM
‎05-05-2020 07:08 AM
excuse me.... the ora format in wrong .... I used "time." ... "timew," was an attempt !!! ... View more

Re: Export a DB in an excel file - format "time"

by Quartz | Level 8 in SAS Programming
‎05-05-2020 07:06 AM
‎05-05-2020 07:06 AM
Hi Kurt, tnk for your replay, as your request:   data Vsf_accounting_vpn_g; set QUERY_FOR_FILTER_FOR_VSF_ACCOUNT; format ORA_PRIMO_COLL ORA_LAST_COLL TIMEW. GG_PRIMO_COLL GG_LAST_COLL DDMMYY10.; /* Ora prima connessione */   ORA_PRIMO_COLL = timepart(TIMESTAMP_CONNESSIONE); /* Ora ultima connessione */   ORA_LAST_COLL = timepart(TIMESTAMP_DISCONNESSIONE); GG_PRIMO_COLL = datepart(TIMESTAMP_CONNESSIONE); GG_LAST_COLL = datepart(TIMESTAMP_DISCONNESSIONE); run;   PROC EXPORT DATA= rwork.Vsf_accounting_vpn_g OUTFILE= "\\grpi-sas-dgc-vip.cariprpc.it\SASDGSWRETE_READ_WRITE\20_dati\report\prova.xlsx" DBMS=EXCEL REPLACE; SHEET="PF_005"; RUN;     ... View more

Export a DB in an excel file - format "time"

by Quartz | Level 8 in SAS Programming
‎05-05-2020 06:19 AM
‎05-05-2020 06:19 AM
Good morning, I have a little problem but I'm not able to resolve it. I need to export a DB with columns with format "Time", the excel file don't keep the right format but take the "date" format, so I have to change the format in all columns.... Please, can you give me some suggestion? Many tnks for you kindly help. Tecla ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-19-2025 02:36 AM
Likes given to
Likes from
View All
Quick links