For task: If in the date columns there is 01/01/1900, replace with 01/01/0001, I tried the following code: data work.CGDM_IMP_PPLC;
infile "&chemin_CGDM./W6_Extraction_CGDM_PPLC.csv"
delimiter='|' firstobs=2 lrecl=32767 missover dsd termstr=lf encoding='utf-8';
format
DATE_DONNEES DDMMYY10.
DATE_ENTREE_ENTREPRISE DDMMYY10.
DATE_SORTIE_ENTREPRISE DDMMYY10.
DATE_ENTREE_ETABL DDMMYY10.
DATE_SORTIE_ETABL DDMMYY10.
IND_VIP 1.
IND_SALARIE_DCD 1.
;
input
SOURCE
DATE_DONNEES :YYMMDD10.
DATE_ENTREE_ENTREPRISE :YYMMDD10.
DATE_SORTIE_ENTREPRISE :YYMMDD10.
DATE_ENTREE_ETABL :YYMMDD10.
DATE_SORTIE_ETABL :YYMMDD10.
IND_VIP
IND_SALARIE_DCD
;
if DATE_SORTIE_ENTREPRISE = '01/01/1900'd
then DATE_SORTIE_ENTREPRISE = '01/01/0001'd;
run; But I am obtaining this error:
... View more