Hi,   From this table: DATA SALE; INPUT FILE $ TYPE $ VAR1 ; CARDS; 1254 100A 52 3652 200 36 1254 100A 36 3652 200 65 3652 200 6 2541 300 65 ; RUN; I did a proc tabulate: PROC TABULATE DATA=SALE; VAR VAR1; CLASS FILE / ORDER=UNFORMATTED MISSING; TABLE /* Dimension de ligne */ FILE={LABEL=""}, /* Dimension de colonne */ VAR1* Sum={LABEL=""}*F=BESTX12. /* Options de la table */ / BOX={LABEL="FILE"} ; ; I would like to achieve the following result:   Each file has the same type. As it is a character variable, I don't know how to integrate it into the proc tabulate.   Thanks     ... View more

Hi,   I have a table with a date field whose values are in this form:   14JUL2023:11:27:52.619374 10JAN2024:10:58:13.665456 20JAN2021:19:23:40.697598 28DEC2022:12:23:56.123211 18JAN2017:11:13:11.259936   I would like to know how to use this field in a SQL query, to select data from 2022 and 2023 for example.   Thanks ... View more

From this example,   PROC SQL; SELECT CODE_VAR1, CODE_VAR2, CODE_VAR3, CODE_VAR4, CODE_VAR5, VAR1, VAR2, VAR3, VAR4, VAR5 FROM SALE; QUIT; RUN;       I would like to know if it is possible not to repeat the name of the variables, as we can do with a KEEP in a DATA step: CODE_VAR1-CODE_VAR15  VAR1-VAR5  ?         ... View more

Hello, I try to get the following result:   From de following table:   DATA SALE; INPUT FILE $ VAR1 VAR2 VAR3 CATEGORY $; CARDS; A 02 03 10 HIGHT A 05 02 03 LOW A 06 02 01 MEDIUM A 02 06 01 MEDIUM B 10 01 06 LOW B 02 03 03 MEDIUM C 03 05 07 MEDIUM C 05 08 06 LOW C 06 10 08 LOW ; RUN; Can someone help me ?     ... View more

  Hello, I try to get the following result:     from the following table   DATA SALE; INPUT ANNEE TYPE $ VAR1 VAR2 VAR3 VAR4; CARDS; 2020 100 52 36 98 74 2020 200 36 52 2 6 2021 100 36 55 44 7 2021 200 65 8 24 6 2022 100 6 36 54 8 2022 200 65 8 25 4 ; RUN; I read the following post but it's not exactly the same case: https://communities.sas.com/t5/SAS-Procedures/Using-proc-report-to-transpose-a-table/m-p/883261    Does anyone have de solution ?   Thank you   ... View more

Hello,  I would like to know how to add a hyperlink on a spanned header in a proc report with ods excel. I tried the 2nd solution offered by this answer but it didn't work in my case.  Re: URL in spanned headers of proc report - SAS Support Communities   Here is a sample code. I would like, by clicking on the 'EMPLACEMENT' header in the excel file, to open the TEST.xlsx file.   %LET FICHIER = file:///\\repertoire\information\TEST.XLSX; DATA SHOES; SET SASHELP.SHOES; RUN; ODS EXCEL FILE="\\repertoire\information\Rapport.xlsx"; PROC REPORT DATA= SHOES; COLUMN ('EMPLACEMENT' Region Product) ('AUTRES' Subsidiary Stores Sales Inventory Returns); RUN; ODS EXCEL CLOSE;   ... View more