About CaroleBPRI

CaroleBPRI · ‎07-17-2023

Ok I will test this point. Is there still a misread when the table is exported. Thank you

CaroleBPRI · ‎07-17-2023

This is my original Code to import the xlsx file : proc import out=lst_pci datafile="V:\3613_DEPT_CONTROLE_DE_GESTION\Transverse\ANAPLAN\TBB Clientèle - Eléments hors SI.xlsx" dbms=XLSX replace; Sheet='REF PCI'; run;

CaroleBPRI · ‎07-17-2023

Hello SAS community, When I import a xlsx file with SAS 9.4, I 've got an issue with a variable name in a column. 'EQ & PPR' in the xlsx file become 'EQ & PPR' in the SAS table imported. Is it a bug from SAS? Are there any other misread special characters? Thank you very much.

CaroleBPRI · ‎07-11-2023

Hi, I imported a csv file with the following code : proc import out=GSM datafile='V:\3613_DEPT_CONTROLE_DE_GESTION\Transverse\ANAPLAN\PALLIATIFS_DIRECT_PBI\commissions\GSM.csv' DBMS=csv replace; delimiter = ";"; run; In the GSM.csv file, one column is "Comax Code" and the format is character. For example, "0000001" SAS put automatically an informat : numeric and "0000001" become the number 1 To fix that I try : proc import out=GSM datafile='V:\3613_DEPT_CONTROLE_DE_GESTION\Transverse\ANAPLAN\PALLIATIFS_DIRECT_PBI\commissions\GSM.csv' DBMS=csv replace; delimiter = ";"; informat "Comax Code" $8.; run; But I still have the wrong informat : Thanks for any help 🙂

Online Status	Offline
Date Last Visited	‎07-21-2023 01:39 PM

Re: & in a xlsx file upload in SAS become &

Re: & in a xlsx file upload in SAS become &

& in a xlsx file upload in SAS become &

PROC IMPORT CSV character value instead of numeric value

Re: & in a xlsx file upload in SAS become &

Re: & in a xlsx file upload in SAS become &

& in a xlsx file upload in SAS become &

PROC IMPORT CSV character value instead of numeric value