About Nasser_DRMCP

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

Nasser_DRMCP · ‎08-25-2017

Hello, thanks ballard. I gaveup the proc "transpose" and I use "across" within proc report. 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 / mean noprint ; title ; RUN ; years are correctly transposed and sorted but values of the indicator CRD_GEN_MENS_MEAN are always "1" ???

Nasser_DRMCP · ‎08-24-2017

thanks a lot Reeza but I do not understand because "define" within proc report is usefull to sort data. my need is to sort columns. 2015, 2016 and 2017 are columns names. before, It was values of "year" column but I need to transpose to get one column for each year in excel. sorry I my issue was not clearly described.

Nasser_DRMCP · ‎08-24-2017

hello, proc transpose data= BEH_AGG_5 out= BEH_AGG_5_CRDGEN_TRSPS (drop = _name_) ; by RAC &v_AXE. GENERATION PRODUCTION ; var CRD_GEN_MENS_MEAN ; id ANNEE_AMO ; idlabel ANNEE_AMO_LABEL ; run ; ODS TAGSETS.EXCELXP FILE = "&xlsfile." style=normal ; ODS TAGSETS.EXCELXP options ( skip_space='1,0,0,0,0' sheet_name='Encours CRD GEN' ) ; PROC REPORT DATA = work.BEH_AGG_5_CRDGEN_TRSPS NOwd ; title ; format _numeric_ z12.5 ; RUN ; ODS TAGSETS.EXCELXP CLOSE ; by launching this code in sas EG environment , it works as intended, year are sorted ascending , 2015, 2016, 2017 (within the excel file) but in bacth mode, years are sorted descending . how can I sort It ? thanks a lot in advance Nasser

Nasser_DRMCP · ‎08-23-2017

not sas EI but sas EG enterprise guide

Online Status	Offline
Date Last Visited	yesterday

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

catch program failed

use ampersand in concatenation string but not a macro variable

compile all values from many columns in a signle column

close an opened table with open instruction

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: 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...

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

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

ODS TAGSETS.EXCELXP proc report year are sorted desc instead of asc in...

Re: ODS TAGSETS.EXCELXP proc print underscore ahead column unintended