Hi,   I have a dataset ONE and want to : Duplicate ONE dataset Each row is now doubled. So for each pair I will want to create a new variable top which is 'x' on the first row and nothing on the second. The code below only gives me the character 'x' on the second line when I would like it on the first   data TMP_ONE; set ONE; top = 'x'; run; data TMP_1_ONE; set ONE; top = ''; run; data I_ONE; set TMP_ONE TMP_1_ONE; run; proc sort data=I_ONE out=I_TWO; by _all_ top; run; Thanks   ... View more

Hi,   I have many SAS dataset on SPDS server  with billions of records and i would like to increase the lenght of a variable. I have a variable name PisteAudit with lenght 100 and i would like to increase to 240. By using     proc sql; alter table lib.table_065 modify PisteAudit char(240); quit;   it takes several hours to complete. Is there an easier way to do this?   Regards ... View more

Hi,    I have some trouble cause i would like to create a date variable dat in a sas dataset and i'm doing lke this:   %let date_traitement=%sysfunc(intnx(month, %sysfunc(today()),-1,e), ddmmyyn8.); %put NOTE: DATE de Traitement ====> &date_traitement.; data test; set sashelp.Prdsal2; date0= put(input(&date_traitement.,ddmmyy10.), ddmmyy10.); run;   Dateset is created but the variable dat have values 3101202 instead of 31012018. I'm a bit confused.   Thnaks for your support     ... View more

Hi, I have some trouble.I have one table( here person) data person; infile datalines delimiter=','; input CREANCE $14. POND REPOR RISK $ COUNTRY$; datalines; 20241514156EUR,272186, 136093,ART122, FR 20241514156EUR,272186, 136093,ART122, NO 20085273456EUR,341928, 65688,ART126-b, FR 20085273456EUR,341928, 170964,ART126-a, FR ; and i would like to have this one in result   data person1; infile datalines delimiter=','; input CREANCE $14. POND REPOR RISK $ COUNTRY$; datalines; 20241514156EUR,272186, 136093, ART122-ART122,FR-NO 20085273456EUR,341928, 236652, ART126-b-ART126-a,FR-FR ; Here the first column are equal and the last column are not equal, so  i keep the first, second, third column, concatenate the fourth and fifth column. 20241514156EUR,272186, 136093,ART122, FR 20241514156EUR,272186, 136093,ART122, NO For others, first colum are identical the same as the last column, so i keep the first, second column, sum the third column, concatenate the fourth and fiht column. 20085273456EUR,341928, 65688,ART126-b, FR 20085273456EUR,341928, 170964,ART126-a, FR Thanks in advance.   ... View more

Hi, I would like to create a sas macro who will give us a list containing all end of month according to the current date. For example: If the macro is launch in March, we will have list_of_date=('31/01/2017', '28/02'2017'). If the macro is launch in June, we will have list_of_date=('31/01/2017', '28/02'2017', '31/03/2017','30/04/2017', '31/05/2017') If the macro is launch in junuary (of year N+1), we will have the end of all month of the previous year. Thanks for all. ... View more

Hi,   I have one table called ENC (same table are in file attached):   PAYS   | Header |CD2  |VAL1|VAL2| COEF BRE    | MATLAB | 11  |.   |500 |-0,9561 BRE    | MATLAB | 11  |500 |.   |0 BRE    | MATLAB | 2   |.   |550 |-1,2212 BRE    | MATLAB | 2   |550 |.   |0   and I would like to create a SAS Format by using this code(missing signify to be "lowest or highest possible value") : data WORK.FMT_ENC(keep=START END FMTNAME LABEL); length FMTNAME $32; retain FMTNAME ; set ENC (rename=(VAL1=start VAL2=end COEF=label)) end=eof; FMTNAME = lowcase(compress('$' !! PAYS !! Header !! put(CD2,2.)!!'_flgperso')); /*retain fmtname "test" type "C";*/ output; if eof then do; hlo = "O"; label = "Autre"; output; end; run; proc format library=WORK cntlin=WORK.FMT_ENC; run;   and I get this error:   ERROR: Cannot mix missing and nonmissing values in the same range: .-500. Plase could you tell me what is wrong in my code.     Thanks a lot fro your reply. ... View more