Hello Experts,
I would like to display my data as 2025100513 (yyyymmddtt). My code seems do not work and I can not find the right format here : SAS Help Center: Working with Dates and Times By Using the ISO 8601 Basic and Extended Notations.
I have this error message : ERROR: Format name B8601DT10.0 not found or the width and/or decimal specified for the format used are out of range. Thank you for your help.
This my code :
%let Ma_Date=%sysfunc(compress(%sysfunc(datetime(),B8601DT10.0),T));
... View more
Hello,
Thank you for your message. I did this, but I still have an empty value for key L004IV :
data ACCORD2_q;
set ACCORD2;
rename 'Frais d''ahésion à l''assos'n=Frais_dadhesion;
keep cd_produit 'Frais d''ahésion à l''assos'n;
run;
data DONNEEMAQUETTE3_q;
set DONNEEMAQUETTE3;
keep cd_produit Nbcar_arb Nbcar_cngmnt;
run;
options validvarname=any;
/***BASE FINALE***/
proc sql;
create table ACCORD13_1 as select a.*, b.*
from ACCORD2_q as a
left join DONNEEMAQUETTE3_q as b on left(a.CD_PRODUIT)=left(b.CD_PRODUIT)
;
quit;
... View more
Hello Experts,
I have an anormal join result, for example, the key L004IV is common, but the result of left join is empty. I tried left, compress, right option, but it doesn't work.
My code is :
proc sql;
create table ACCORD13_1 as select a.*, b.*
from ACCORD2_q as a
left join DONNEEMAQUETTE3_q as b on left(a.CD_PRODUIT)=left(b.CD_PRODUIT)
;
quit;
The data is joined.
Thank you very much for your help!
... View more
Thank you for your answer SasKiwi. « « Note EG projects can only be scheduled on the computer where EG is installed. » Does it mean that I need to install EG in my local environment ?
... View more
Hello Experts,
I have EG 8.3, before I have the SAS sheduling option, but I can not find it with my actual SAS EG version.
Do you know please which kind of script I need to write to schedule the project directly in Windows?
I do not work in local environment, I work in server.
Thank you for your help!
... View more
Hello Experts,
I am wondering how to join with sas sql the tables without overwriting the variables.
For example, I would like to join this data, but in output I would like to have the Value_1=50, Value_2=50.
Key
Value
PI23X
50
PI23X
50
Thank you foryour help !
... View more
