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: 
WilliamB
‎12-23-2022
  • 61 Posts
  • 2 Likes Given
  • 0 Solutions
  • 3 Likes Received

Keep last record

by Obsidian | Level 7 in SAS Programming
‎12-20-2022 11:47 AM
‎12-20-2022 11:47 AM
Hello, if possible in spl I would like to keep the last status with respect to the oldest date of the column (DH_EVNM)   Table: Code DT_DEPO DH_EVNM CD_STTT_APPL PIZ640 23FEB2022:00:00:00 23FEB2022:10:09:39.000000 REPONDEUR SYSTEM PIZ640 23FEB2022:00:00:00 24FEB2022:10:35:00.000000 REFUS PAS INTERESSE PAR L OFFRE PIZ640 23FEB2022:00:00:00 24FEB2022:10:35:21.000000 REFUS PAS INTERESSE PAR L OFFRE PIZ541 16APR2022:00:00:00 16APR2022:11:46:13.000000 REPONDEUR SYSTEM PIZ541 16APR2022:00:00:00 19APR2022:11:23:38.000000 REPONDEUR SYSTEM PIZ541 16APR2022:00:00:00 20APR2022:11:04:00.000000 REFUS PAS INTERESSE PAR L OFFRE PIZ541 16APR2022:00:00:00 20APR2022:11:04:26.000000 REFUS PAS INTERESSE PAR L OFFRE PIZ324 04JUN2022:00:00:00 07JUN2022:14:54:54.000000 REPONDEUR SYSTEM PIZ324 04JUN2022:00:00:00 08JUN2022:16:18:43.000000 REPONDEUR SYSTEM PIZ324 04JUN2022:00:00:00 09JUN2022:13:48:21.000000 REPONDEUR SYSTEM PIZ324 04JUN2022:00:00:00 10JUN2022:17:27:42.000000 REPONDEUR SYSTEM PIZ324 04JUN2022:00:00:00 13JUN2022:17:28:00.000000 GEL AU JOUR 5 PIZ811 17NOV2022:00:00:00 17NOV2022:11:36:45.000000 REPONDEUR SYSTEM PIZ811 17NOV2022:00:00:00 17NOV2022:17:53:39.000000 REPONDEUR SYSTEM PIZ811 17NOV2022:00:00:00 18NOV2022:12:08:46.000000 REPONDEUR PIZ811 17NOV2022:00:00:00 18NOV2022:16:12:39.000000 REPONDEUR PIZ811 17NOV2022:00:00:00 19NOV2022:11:14:16.000000 REPONDEUR PIZ811 17NOV2022:00:00:00 19NOV2022:13:49:00.000000 TENTATIVES D APPELS ATTEINTES   Want: Code DT_DEPO DH_EVNM CD_STTT_APPL PIZ640 23FEB2022:00:00:00 24FEB2022:10:35:21.000000 REFUS PAS INTERESSE PAR L OFFRE PIZ541 16APR2022:00:00:00 20APR2022:11:04:26.000000 REFUS PAS INTERESSE PAR L OFFRE PIZ324 04JUN2022:00:00:00 13JUN2022:17:28:00.000000 GEL AU JOUR 5 PIZ811 17NOV2022:00:00:00 19NOV2022:13:49:00.000000 TENTATIVES D APPELS ATTEINTES Thanks for your help. ... View more

Creating a cumulative column

by Obsidian | Level 7 in SAS Programming
‎05-10-2022 04:15 AM
‎05-10-2022 04:15 AM
Hello, I would like to create a cumulative column in relation to the time variable "month". Thanks for your help         Want:       Month Seg Cost   Month Seg Cumul Cost Cost 202201 Up 5   202201 Up 49 49 202201 Down 10   202201 Down 109 109 202202 Up 33   202201 Right 44 44 202202 Left 66   202201 left 33 33 202201 Right 44   202202 Up 115 66 202201 left 22   202202 Down 109 0 202203 left 66   202202 Right 44 0 202203 right 88   202202 Left 99 66 202201 Up 44   202203 Up 115 0 202201 Down 99   202203 Down 109 0 202202 Up 33   202203 Right 143 99 202201 left 11   202203 Left 264 165 202203 left 99           202203 right 11           ... View more

Get week number

by Obsidian | Level 7 in SAS Programming
‎03-01-2022 10:57 AM
1 Like
‎03-01-2022 10:57 AM
1 Like
Hello, I want to get the week number from a column with a format (DATETIME20.). I want the year before the week number. Precision the first day of the week must be Monday Like this: Table         DT_EXTR     DT_EXTR week number 16FEB2022:00:00:00     16FEB2022:00:00:00 202207 25JAN2022:00:00:00     25JAN2022:00:00:00 202204       20MAR2022:00:00:00 202211   Thanks for your help ... View more

Transpose an array

by Obsidian | Level 7 in SAS Programming
‎02-08-2022 03:18 AM
1 Like
‎02-08-2022 03:18 AM
1 Like
Hello, I want to transpose a data array. When the "Script" column contains M2 then I want the "Want" table to report the date in the M2 column. Another example for the id "789319", "Script" contains M6 I want to report the date in the column "M6" When there is no data I want it to remain empty Thanks a lot for your help. William                   Want           ID Script DATE Flag     ID M2 M3 M4 M6 Flag 235638 Dts_IM2_ras 23/01/2021 0     235638 23/01/2021 24/02/2021 26/03/2021 27/05/2021 0 235638 Promo_IM3_be 24/02/2021 0     457814 25/01/2021 28/02/2021 29/03/2021 30/06/2021 1 457814 SZE_IM2_rz 25/01/2021 1   =>  897643 31/07/2021       0 235638 Queffrti_IM4_rgg 26/03/2021 0     894512 01/09/2021 15/10/2021     1 235638 AIU_IM6_ski 27/05/2021 0     789319       15/12/2021 1 457814 alop_IM3_rfz 28/02/2021 1                 457814 fop_IM4_rhtrh 29/03/2021 1                 457814 skop_IM6_rrefgr 30/06/2021 1                 897643 dzd_IM2_rsa 31/07/2021 0                 894512 uil_IM2_rdzd 01/09/2021 1                 894512 kujndbe_IM3_ezef 15/10/2021 1                 789319 kujnzze_IM6_ezff 15/12/2021 1                                         ... View more

Concatenate two tables with dates

by Obsidian | Level 7 in SAS Programming
‎02-01-2022 10:45 AM
‎02-01-2022 10:45 AM
Hello, I have a first table with the customer number and the registration date. Then a second with the order numbers and all the order dates. I would like to create a table that adds to the A table the date of the first order.   A       B   Number DATE_RECORD     Number DATE_ORDER 234 01/02/1995     2345 11/04/2013 890 03/06/2016     2345 04/11/2017 2345 04/06/2012     2345 04/06/2015 896 29/11/2001     896 21/02/2002 8765 06/03/2002     896 01/11/2008         234 13/09/1995                             WANT           Number DATE_RECORD FIRST_ORDER       234 01/02/1995 13/09/1995       890 03/06/2016         2345 04/06/2012 11/04/2013       896 29/11/2001 21/02/2002       8765 06/03/2002       Thanks for your help ... View more

Remove duplicates

by Obsidian | Level 7 in SAS Programming
‎02-18-2021 10:14 AM
‎02-18-2021 10:14 AM
Hello, I want to remove the duplicates and keep the line with the most recent month (comois). If possible in sql                             Data:    COMOIS seg_cice LIPRLG COMAX 202003 JEUNE client Jeune inactif 205127 202011 JEUNE client Jeune inactif 205127 202003     344978 202002 JA/A/P client Adulte inactif 347109 202006 JA/A/P client Adulte inactif 347109 202007 JA/A/P client Adulte inactif 405866 202007 JA/A/P client Adulte inactif 405868 202009 JA/A/P client Adulte inactif 405868 202003     438218 202006     438218 202005 JA/A/P client Adulte inactif 576036 202007 JA/A/P client Adulte inactif 576036 202003 JEUNE client Jeune inactif 626848 202012 JEUNE client Jeune inactif 626848 202009 JEUNE client Jeune actif non équipé 639972 202006 JEUNE client Jeune inactif 646960 202012 JEUNE client Jeune inactif 646960     Want:     COMOIS seg_cice LIPRLG COMAX 202003 JEUNE client Jeune inactif 205127 202003     344978 202002 JA/A/P client Adulte inactif 347109 202007 JA/A/P client Adulte inactif 405866 202007 JA/A/P client Adulte inactif 405868 202003     438218 202005 JA/A/P client Adulte inactif 576036 202003 JEUNE client Jeune inactif 626848 202009 JEUNE client Jeune actif non équipé 639972 202006 JEUNE client Jeune inactif 646960     Thanks for your help                                                   ... View more

Re: SQL, Select the best line

by Obsidian | Level 7 in SAS Programming
‎02-28-2020 09:12 AM
‎02-28-2020 09:12 AM
The largest number, from the COSEM column ... View more

SQL, Select the best line

by Obsidian | Level 7 in SAS Programming
‎02-28-2020 09:06 AM
‎02-28-2020 09:06 AM
Hello, I would like to select the largest week per month and divide QCNUM / QCDEN into percentages.   In SQL preferably.   Thanks for your help   Table                        COMOIS COSEM COESVD QCNUM QCDEN   202001 202004 3754 12948 24086   202001 202002 3754 12951 24088   202001 202005 3754 12950 24088   202001 202003 3754 12950 24076   202001 202001 3754 12886 24079   202002 202007 3754 12923 24147   202002 202006 3754 12956 24152   202002 202008 3754 12862 24149                           Want            COMOIS COSEM COESVD QCNUM QCDEN taux 202001 202005 3754 12950 24088 54% 202002 202008 3754 12862 24149 53% ... View more

Link two tables with a date year and month

by Obsidian | Level 7 in New SAS User
‎02-27-2020 08:52 AM
‎02-27-2020 08:52 AM
Hello I would like to connect 2 tables but I do not know how to do it because of the date in text of the second table $ 6 .. Can you help me.   Table 1       Table 2               COMAX COOPU DAOPU   COMAX Comois 37351 OPUCTC00046D2CW 02-juil-19   37351 201907 42235 OPUCTC0004TOCFP 05-nov-19   42235 201911 42235 OPUCTC0004UJ9RI 26-déc-19   42243 202001 42243 OPUCTC0004XHLP6 10-janv-20   42251 201911 42251 OPUCTC0004UJD3G 19-nov-19   42265 201912 42265 OPUCTC0004U8XL6 20-déc-19   42268 201911 42268 OPUCTC0004TOJYV 26-nov-19   103891 201909 103891 OPUCTC0004OCEP1 15-sept-19       42265 OPUCTC0004U8XL6 20-janv-19                                                 Want           COMAX Comois COOPU 37351 201907 OPUCTC00046D2CW 42235 201911 OPUCTC0004TOCFP 42243 202001 OPUCTC0004XHLP6 42251 201911 OPUCTC0004UJD3G 42265 201912 OPUCTC0004U8XL6 42268 201911 OPUCTC0004TOJYV 103891 201909 OPUCTC0004OCEP1               ... View more

Macro Variable if

by Obsidian | Level 7 in SAS Programming
‎01-23-2020 11:47 AM
‎01-23-2020 11:47 AM
Hello, I would like to use macro variables, but I am not comfortable. I have a number changing column cond_i from one time to another. I would like a macro variable that counts the cond_i collones. To allow to do   if cond_1 to cond_ & i = F then Top = 1 elce Top = 0   Thanks for your idea   Table             ID Name Cond_1 Cond_2 Cond_3 Cond_4   1 tom F         2 arthur F F F F   3 didier   F   F   4 françois F F F F   5 harry F F F                   Want             ID Name Cond_1 Cond_2 Cond_3 Cond_4 Top 1 tom F       0 2 arthur F F F F 1 3 didier F F F F 0 4 françois F F F F 0 5 harry F F F   0 ... View more

Re: Transpose a table

by Obsidian | Level 7 in SAS Programming
‎01-23-2020 10:26 AM
‎01-23-2020 10:26 AM
thank you so much ... View more

Transpose a table

by Obsidian | Level 7 in SAS Programming
‎01-23-2020 10:10 AM
‎01-23-2020 10:10 AM
Hello, I would like to transpose a table. I only want one the same value in ID. Thanks a lot for your help.   TABLE                           ID CODE DATE         01 FAZ58 07/01/2020         01 FZE78 04/01/2020         02 DS52 05/01/2020         02 YU89 04/01/2020         02 LM69 04/01/2020         03 DS24 05/01/2020         04 FS24 06/01/2020         04 XC89 07/01/2020                       WANT:                           ID CODE1 DATE1 CODE2 DATE2 CODE3 DATE3 01 FAZ58 07/01/2020 FZE78 04/01/2020     02 DS52 05/01/2020 YU89 04/01/2020 LM69 04/01/2020 03 DS24 05/01/2020         04 FS24 06/01/2020 XC89 07/01/2020     ... View more

Multiply tables

by Obsidian | Level 7 in SAS Programming
‎11-07-2019 10:11 AM
‎11-07-2019 10:11 AM
Hello,   I want to multiply table 1 with table 2.     Thanks for your help.   Table 1    Table 2     Want             Name DAFMS DAFMS   Name     DIDIER 31OCT2018 31OCT2018   DIDIER     DIDIER 31JAN2018 31JAN2018   Gérard     DIDIER 30SE2019 30SE2019   william     DIDIER 31JUL2019 31JUL2019         DIDIER 31MAY2019 31MAY2019         DIDIER 28FEB2019 28FEB2019         DIDIER 30JUN2019 30JUN2019         DIDIER 30APR2019 30APR2019         DIDIER 31AUG2019 31AUG2019         DIDIER 30NOV2018 30NOV2018         DIDIER 31DEC2018 31DEC2018         DIDIER 31MAR2019 31MAR2019         Gérard 31OCT2018           Gérard 31JAN2018           Gérard 30SE2019           Gérard 31JUL2019           Gérard 31MAY2019           Gérard 28FEB2019           Gérard 30JUN2019           Gérard 30APR2019           Gérard 31AUG2019           Gérard 30NOV2018           Gérard 31DEC2018           Gérard 31MAR2019           william 31OCT2018           william 31JAN2018           william 30SE2019           william 31JUL2019           william 31MAY2019           william 28FEB2019           william 30JUN2019           william 30APR2019           william 31AUG2019           william 30NOV2018           william 31DEC2018           william 31MAR2019 ... View more

Re: Join data / IF

by Obsidian | Level 7 in SAS Programming
‎11-07-2019 08:43 AM
‎11-07-2019 08:43 AM
It's a mistake it's 1. ... View more

Join data / IF

by Obsidian | Level 7 in SAS Programming
‎11-07-2019 08:25 AM
‎11-07-2019 08:25 AM
Hello, I want to gather tables, adding up data, such as the number of "months" and the number of "connections". But I want to create an "ACTIVE" variable. If "Sum Month" is greater than or equal to Connect then Active = "Yes" otherwise "No". Thanks a lot for your help.   Table 1       Table 2     Clients  Age           Thomas 10     Clients  Month Connexion Nelson 14     Thomas 30SET2019 1 Xavier 15     Thomas 31OCT2019 0 Florine 15     Nelson 31OCT2019 2         Xavier 31JUL2019 1         Xavier 31AUG2019 2         Xavier 30SET2019 0         Xavier 31OCT2019 1         Xavier 31OCT2019 1         Florine 31JUL2019 1         Florine 31AUG2019 0         Florine 30SET2019 0         Florine 31OCT2019 0         Florine 31OCT2019 0                             Want                           Clients  Age Sum Month Sum Connexion Actif     Thomas 10 2 1 No     Nelson 14 1 2 Yes     Xavier 15 5 5 Yes     Florine 15 5 1 No     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-23-2022 06:44 PM
Likes given to
View All
Likes from
View All
Quick links