Hello, i just tried to create a table, i have a case when clause that generates an error. (case when t1.code_chiffre_affaire = 1 then '<-10%' when t1.code_chiffre_affaire = 2 then '-10% à -5%' when t1.code_chiffre_affaire = 3 then '-5% à 0%' when t1.code_chiffre_affaire = 4 then '0% à +5%' when t1.code_chiffre_affaire = 5 then '+5% à +10%' when t1.code_chiffre_affaire = 6 then '>+10%' end) as tranche_var_chiff_aff   the error :  ERROR: String data, right-truncated TRANCHE_VAR_CHIFF_AFF ... View more

hello, i am trying to add a column where i have the number of rows, like 1,2,3.. However this is what i get. I used this script :  data casuser.X; set CASUSER.Y; retain f 0; f++1; run;   ... View more

Hello, do you know why i get this ?   length COL2 varchar(*) COL3 varchar(*) COL4 varchar(*) annee_min 8 annee_max 8;  ERROR: Cannot change variable type that is already defined for variable COL2. ... View more

Hello,   I have a table that may contain 1 to 5 observations, i need to add a column that contains the number of observations. i tried row_num= _n_ but it is not what i want. i will be thankful for your help. ... View more

Hello,   I have an error out of memory, do you know how to put this option readtransfersize in a sas viya code ??   Thank you ... View more

Hello,  I have a table x containing 10 million lines. do you have an example script that runs in loop to multpily observations 3 times or more.   Thank you ... View more

Hello everyone, In SAS VIYA, i would like to import an excel file with multiple sheets. Do you have an idea which option shall i use ? Thank you ... View more