hello,   I would like to know if there is a way to convert a date (ddmmyyn8) to another date format (ddmmyy10) using proc sql alter table modify? Regards,   ... View more

Hello,   I am using a SAS Enterprise Guide 7.15 and I would like to make a backup of a dataset automatically each first day of the month.  Is there a way to achieve that operation.  Does The SAS programm need to be open?   Regards,   ... View more

Hello,   I would like to send a report by email but I receive the following error message:   ERROR: E-mail : 452 4.3.1 Insufficient system resources   Here's a test code:   %macro rapport; proc report data=sashelp.class; col name age sex; define name / style(column)=[cellwidth=1in]; define age / style(column)=[cellwidth=.5in]; define sex / style(column)=[cellwidth=.5in]; title "Using the CELLWIDTH= Style with PROC REPORT"; run; %mend rapport; %rapport; %Macro Email_test(prenom,nom); %global courriel Name Name2; data _null_; call symput ("Name",&Firstname.||" "||&Lastname.); /*You can change the email extention @gmail.com for your email server name */ call symput ("email",&Firstname.||"."||&Lastname.||"@gmail.com"); call symput ("Name2","'"||&FirstName.||" "||&Lastname.||"'"); run; options emailsys = SMTP; options emailhost = confidential; FILENAME mail EMAIL TO=("&email." ) SUBJECT="Test - Report for: &Name" CONTENT_TYPE="text/html"; ODS LISTING CLOSE; ODS HTML BODY=mail; %rapport; ODS HTML CLOSE; ODS LISTING; %mend Email_Test; %Email_Test('firstname','lastname');   Does anyone already saw this error message and how can we solve it. regards,   Alain. ... View more

Hello,   I would like to add an header like 'the purple line' (line 'This is a LINE before data starts displaying';) after Var1 eq 'D'   Here's my code but it is missing something to obtains what I want. Does someone know how to add an header after the Nth observations? Regards,   data Dataset1; infile datalines delimiter=','; input var1 $ var2 $ var3 $ var4 $ var5 $; datalines; A,1,2,3,4 B,1.1,1.2,1.3,1.4 C,2.1,2.2,2.3,2.4 D,3.1,3.2,3.3,3.4 E,5,6,7,8 F,5.1,5.2,5.3,5.4 G,6.1,6.2,6.3,6.4 H,7.1,7.2,7.3,7.4 ; RUN; proc report data=Work.dataset1 nowd; columns (Var1 ('Period1' Var2 Var3 ) ('Period2' Var4 var5 )); compute before / style={just=l color=purple}; line 'This is a LINE before data starts displaying'; endcomp; define Var1 / 'Variable1' style(column)={just=l}; define Var2 / 'Variable2' style(column)={just=c}; define Var3 / 'Variable3' style(column)={just=c}; define Var4 / 'Variable4' style(column)={just=c}; define Var5 / 'Variable5' style(column)={just=c}; run; ... View more