About Nasser_DRMCP

Nasser_DRMCP · ‎10-18-2017

hello Reeza please could I ask an added question. this is the new dataset "have" that contains 2 years 2016 and 2017. I would like to sum only column NB_2016_ whenever the row concerns 2016 and sum NB_2017_ whenever the row concerns 2017. thanks a lot in advance ! Nasser data have ; informat year 4. ; informat year_month yymmn6.; format year_month date9.; input year year_month NB_201601 NB_201602 NB_201603 NB_201701 NB_201702 NB_201703 ; datalines; 2016 201601 1611 1612 1613 1711 1712 1713 2016 201602 1621 1622 1623 1721 1722 1723 2016 201603 1631 1632 1633 1731 1732 1733 2017 201701 1611 1612 1613 1711 1712 1713 2017 201702 1621 1622 1623 1721 1722 1723 2017 201703 1631 1632 1633 1731 1732 1733 ; run ;

Nasser_DRMCP · ‎10-17-2017

thanks a lot Reeza for quality and reactivity

Nasser_DRMCP · ‎10-17-2017

Hello, I have this dataset data table ; input year_month NB_201701 NB_201702 NB_201703 ; datalines; 201701 101 102 103 201702 201 202 203 201703 301 302 303 ; run ; And I would like to get a new aggregated column that holds the addition of each column which have a month (in the column name) less than the month in the "year_month" column. 1rst line==> because it is jan then the result shoul be NB_201701 only 2nd ==>NB_201701 + NB_201702 3==> NB_201701 + NB_201702 + NB_201703 Thanks a lot in davance for your help Nasser

Nasser_DRMCP · ‎09-07-2017

thanks but I created the format # ##0,00000 in excel and by doing style(column)={tagattr='format:# ##0,00000'} I get 225 353,74 (only two deci) I don't succeed to get in excel a number format like 225 353,73804

Nasser_DRMCP · ‎09-07-2017

thanks a lot RW9. may I ask an added question. I try to export the amount into excel via ODS and proc report. I specified this define montant / '' format = frmt_num_spac_comma. ; but in excel I get a character column. what should I specify into this line above to get a numeric. thanks a lot

Nasser_DRMCP · ‎09-07-2017

proc format library = fodat.cat_formats ; picture frmt_num_spac_comma 0 - 9999999 = '000 000 000,00000' (decsep=',' dig3sep=' ') ; run ; data encours ; input montant ; datalines ; 123456.12345 ; data encours2 ; set encours ; montant2 = put(montant,frmt_num_spac_comma.); run ; Hello, I have the amount 123456,12345 and I would like to get 123 456,123456. (space thousand separator) so I appply a format (by creating an amount2) that I created. the display is correct but the format of the amount2 is character and I would like numeric. How can I fix this ? thanks a lot in adance. Nasser

Nasser_DRMCP · ‎09-06-2017

thank you very much. so I started to create a format within, excel like # ##0,00000' and then in proc report I do this : define MNT_MOIS_AMO_AVT_SORTIE / '' style(column)={tagattr='format:# ##0,00000'} I get a number but I only get 2 decimales instaed of 5

Nasser_DRMCP · ‎09-06-2017

for exmple the value 225353,74382 I would like to get in excel, a number (and not text) like 225 353,74382 (with space thousand and ',' separator). but with this below, I get the correct displayed but it is a text define MNT_MOIS_AMO_AVT_SORTIE / '' f = frmt_num_spac_comma. And with this below, I get a number but the display is not correct 000 225 353,74000 define MNT_MOIS_AMO_AVT_SORTIE / '' style(column)={tagattr='format:000 000 000.00000'} ;

Nasser_DRMCP · ‎09-06-2017

Hello, I export a report (via proc report) into excel and I would like to keep a specifiq numerci format. When I launch this code below, it works. I mean, in excel the number is kept into numeric format define MNT_MOIS_AMO_AVT_SORTIE / '' style(column)={tagattr='format:000 000 000.00'}; but I create this format named "frmt_num_spac_comma" via proc format . so I try this define MNT_MOIS_AMO_AVT_SORTIE / '' style(column)={tagattr=frmt_num_spac_comma.}; but it does not work. how could I specify the created format ? thanks a lot for your in advance. Nasser

Nasser_DRMCP · ‎09-05-2017

Thanks Bruno, But I do not manage to display the computed varaible datas. even if with the example you gave to me. you can notice it in the encmosed screenshot

Nasser_DRMCP · ‎09-05-2017

PROC REPORT DATA = work.T_AMO_CRD_SORTIES nowd ; column MOIS_AMO MNT_MOIS_AMO_AVT_SORTIE TX_SORTIE_DDT MNT_MOIS_AMO_SORTIE_DDT , MOIS_PROD_LABEL ; define MOIS_AMO / group ; define MOIS_PROD_LABEL / across '' ; define MNT_MOIS_AMO_AVT_SORTIE / display noprint; define TX_SORTIE_DDT / display noprint; define MNT_MOIS_AMO_SORTIE_DDT / computed f = numx15.5 ; COMPUTE MNT_MOIS_AMO_SORTIE_DDT ; MNT_MOIS_AMO_SORTIE_DDT = MNT_MOIS_AMO_AVT_SORTIE * TX_SORTIE_DDT ; ENDCOMP ; title ; RUN ; Hello, I get 2 columns amount ( )and percentage ( ) and I do not succeed to multiply them. thanks in advance for your help Nasser

Nasser_DRMCP · ‎08-25-2017

thanks for your quick respons. I found the solution insisde proc report by using a compute like this : COMPUTE RAC ; IF RAC NE ' ' then hold=RAC ; IF RAC EQ ' ' then RAC=hold ; ENDCOMP; then in the clumn RAC, the first value is repeated

Nasser_DRMCP · ‎08-25-2017

PROC REPORT DATA = work.BEH_AGG_5 nowd ; column RAC Groupe GENERATION production ANNEE_AMO, CRD_GEN_MENS_MEAN ; define RAC / group ; define Groupe / group ; define GENERATION / group ; define production / group ; define ANNEE_AMO / across ; define CRD_GEN_MENS_MEAN / '' f=12.2 ; title ; RUN ; hello, I would like to get a report with the column "year" transposed and with the variable group values repeated. with the enclosed code, I succeed to get the indicators values aligned on the same line (this is intended). but the value of group variable is only once displayed (first row). by specifying "display" like this "define RAC / group display ;" the values are repeated (not sorted) but indicators are no aligned anymore. thanks a lot for your help

Nasser_DRMCP · ‎08-25-2017

PROC REPORT DATA = work.BEH_AGG_5 ; column RAC Groupe GENERATION production ANNEE_AMO, CRD_GEN_MENS_MEAN ; define RAC / group ; define Groupe / group ; define GENERATION / group ; define production / group ; define ANNEE_AMO / across ; define CRD_GEN_MENS_MEAN / '' f=12.2 ; title ; RUN ; Hello, By launch this code, the indicators CRD_GEN_MENS_MEAN are correctly aligned in one line correspoinf to a combination of group variables. the problem is that the value of RAC is displayed only once (first row). I would like to display it one each row. so I specified display as "define RAC / group display ; " and then the RAC value is effectively repeated but now , the indicators CRD_GEN_MENS_MEAN values are not aligned anymore. thanks a lot in adcance for your help

Nasser_DRMCP · ‎08-25-2017

It works ! column RAC Groupe GENERATION production ANNEE_AMO , CRD_GEN_MENS_MEAN the comma was missing

Online Status	Offline
Date Last Visited	5 hours ago

Re: struggle with join toward a table with 3 billions rows

Re: struggle with join toward a table with 3 billions rows

Re: struggle with join toward a table with 3 billions rows

struggle with join toward a table with 3 billions rows

duration between 2 dates and display hour min sec

struggle with different date format in a string

Re: macro with returned value string instead numeric

macro with returned value string instead numeric

Re: catch program failed

Re: catch program failed

Re: Converting Date number to Date9.

Re: create subgroup number by group

Re: generate a random integer without duplicate

Re: generate a random integer without duplicate

Re: generate a random integer without duplicate

struggle with different date format in a string

Re: function that returns a min date from table

join two tables by comparing date in range dates

Re: sgplot xaxis NOT sorted for all group values

Re: addition certain columns depends value of a month column

Re: addition certain columns depends value of a month column

addition certain columns depends value of a month column

Re: proc format text instead of numeric

Re: proc format text instead of numeric

proc format text instead of numeric

Re: TAGSETS.EXCELXP proc report maintain numerci format

Re: TAGSETS.EXCELXP proc report maintain numerci format

TAGSETS.EXCELXP proc report maintain numerci format

Re: proc report computed variable by multiply 2 columns

proc report computed variable by multiply 2 columns

Re: PROC Report repeating grroup varaibale values

PROC Report repeating grroup varaibale values

proc report repeat the group value for each lines

Re: ODS TAGSETS.EXCELXP proc report year are sorted desc instead of as...