About Mar1ene

Mar1ene · ‎02-24-2023

Thank you @Quentin , you are an absolute legend!!

Mar1ene · ‎02-22-2023

Hi @ChrisHemedinger, Thanks a stack for this!! You're a Rockstar!! I am using the below code to send an email (copy & pasted from a SAS community :D), only if the data table is populated. I want to receive a notification if the data table is empty tho, but it does not work. Please help!! %macro email; data _null_; call symputx('nobs',nobs); stop; set Exceptions nobs=nobs; run; %if (&nobs.) %then %do; filename outfile email from= "Department@company.com" to="User@company.com" subject="EXCEPTIONS as at &date." attach=("/SAS/Department/Process/Exceptions.xlsx" content_type="application/xlsx"); data _null_; file outfile; PUT 'Email body'; run; %end; %else %do; filename outfile email from= "Department@company.com" to="MyEmail@company.com" subject="EXCEPTIONS data as at &date. is empty"; %end; %MEND EMAIL; %EMAIL;

Mar1ene · ‎10-02-2018

Hi Hasnat, I give up... LOL! Guess the pro's should rather assist. Give my below code a shot... proc sort data=SASxyz; by FYYYYQ; data SASxyz1 (drop=prev_EPSFIQ move_perc); set SASxyz; by FYYYYQ; format prev_EPSFIQ 8.2 move_perc comma5.2; prev_EPSFIQ = lag(EPSFIQ); if prev_EPSFIQ in (.,0) then prev_EPSFIQ=EPSFIQ; move_perc = ((EPSFIQ-prev_EPSFIQ)/prev_EPSFIQ)*100; count + 1; if move_perc<0 then count = 0; run; proc report data=SASxyz1 out=SASxyz2 (drop=_break_) nowd missing; columns FYYYYQ count n; define FYYYYQ/display; define count/across; where count ne 0; run; Go well!! Marlene

Mar1ene · ‎10-02-2018

hi Hasnat, I'm not 100% sure I understand the requirement, but if I am correct, you can use the below and specify the output in the proc report by 'key'... I hope this helps... proc sort data=SASxyz; by FYYYYQ; data SASxyz1; set SASxyz; counter = _N_; Key = ceil(counter/5); run; proc report data=SASxyz1 out=SASxyz2 (drop=_break_) nowd missing; columns Key FYYYYQ EPSFIQ; define Key/group; define FYYYYQ/display; define EPSFIQ/display; run; Output sample: Key FYYYYQ EPSFIQ 1 1980.099976 0.06 1980.199951 0.06 1980.300049 0.06 1980.400024 0.07 1981.099976 0.14 2 1981.199951 0.16 1981.300049 0.21 1981.400024 0.19 1982.099976 0.24 1982.199951 0.24 3 1982.300049 0.26 1982.400024 0.32 1983.099976 0.4 1983.199951 0.4 1983.300049 0.4 Kind Regards, Marlene

Mar1ene · ‎10-01-2018

Oh gosh... meant thank you Ballardw (blushing face)

Mar1ene · ‎10-01-2018

Thank you Knagarkar 😄

Mar1ene · ‎09-28-2018

Hi Knagarkar, Check the below out... I think it explains it nicely... https://communities.sas.com/t5/SAS-Programming/What-is-the-purpose-of-N-syntax-in-the-codes/m-p/245335#M45764 Marlene

Mar1ene · ‎09-28-2018

Good morning from South Africa Sathish, Maybe you can try the below: %macro Macro_Name(Server, Table); update MyTable set ht = b.Height FROM MyTable a JOIN &Server..Project.dbo.&Table. b ON a.ID = b.ID and ht is in ("null","") and /***(Null or '')***/ b.R_date = (select min(R_date) from &Server..Project.dbo.&Table. cc where a.ID = cc.ID) /*SET ONE*/ %Macro_Name('192.168.11.3', 'Table1'); %Macro_Name('192.168.11.3', 'Table2'); %Macro_Name('192.168.11.3', 'Table3'); /*SET TWO*/ %Macro_Name('192.168.12.3', 'Table1'); %Macro_Name('192.168.12.3', 'Table2'); %Macro_Name('192.168.12.3', 'Table3'); Give it a shot... Marlene

Mar1ene · ‎09-27-2018

Hello from South Africa, Please help me to organize my email layout. My code below: /*EMAIL SUMMARY VIEW AND EXCEPTION REPORTS*/ /*-------------------------------------------------------------------------------*/ options emailsys=smtp emailhost= localhost emailport=25; FILENAME OUTPUT EMAIL SUBJECT = "Trying to find a better email layout" attach=("Path/File_Name.xlsx" content_type="application/xlsx") FROM = "Mar1ene@email.co.za" TO=('Mar1ene@email.co.za') type='text/html' CT ='text/html'; ods html3 body=OUTPUT /*EMAIL BODY*/ /*-------------------------------------------------------------------------------*/ style=htmlblue; ods escapechar='^'; ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black} "; ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black}Hello,"; ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black} "; ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black}Please help me to space my body text and output tables better"; ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black} "; ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black}Thank you,"; ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black}Mar1ene"; ODS TEXT="^S={font_face='Calibri' font_size=3 fontweight=Medium foreground=black} "; ODS TEXT="^S={font_face='Calibri' font_size=5 fontweight=Medium foreground=black}SUMMARY CATEGORY 3"; /*CATEGORY 3*/ proc print data=Table_Name (rename=(Var1=Var_1 Var2=Var_2 Var3=Var_3)) style (table) = [frame=box borderwidth=1] noobs; VAR Var_1 Var_2 Var_3 Amount N; format Amount comma20.; TITLE "Fancy output Title to impress people"; Footnote1 "Explain my summary table above a little, just for fun; run; proc print data=Table_Name2 (rename=(Var4=Var_4 Var5=Var_5 Var6=Var_6)) style (table) = [frame=box borderwidth=1] noobs; VAR Var_4 Var_5 Var_6 Amount N; format Amount comma20.; TITLE "Fancy output Title... again..."; Footnote1 "Explain my summary table above a little, because i can; run; ODS TEXT="^S={font_face='Calibri' font_size=5 fontweight=Medium foreground=black}SUMMARY CATEGORY 4"; /*CATEGORY 4*/ proc print data=Table_Name3 (rename=(Var7=Var_7 Var8=Var_8 Var9=Var_9)) style (table) = [frame=box borderwidth=1] noobs; VAR Var_7 Var_8 Var_9 Amount N; format Amount comma20.; TITLE "Title Blah Blah Blah"; Footnote1 "I love texting here...; run; /*CATEGORY 5*/ /*CATEGORY 11*/ ods html3 close; **bleep** output below: (LOL!! can't believe I got "bleeped"!!) ...okay... "DARN" output below: Photo1 the table heading is above the body text... why? Category 4 is directly under the Cat3 table, instead of above the Cat4 table? Thank you, Marlene

Mar1ene · ‎09-27-2018

Hi Knagarkar, Let me try with my limited knowledge... lets learn together 😄 data vite_b data output name (keep=SID strata1 plaque1 plaque2 trt); only keeping the specified variables in the output table set vite data intput table nobs=nobs; Creates and names a temporary variable whose value is usually the total number of observations in the input data set or data sets. retain SID 0 strata1 0 plaque1 0 plaque2 0 trt 0; Causes a variable that is created by an INPUT or assignment statement to retain its value from one iteration of the DATA step to the next. if _N_ EQ (equal to) 1 then do; condition to be met for below 'instructions' i.e. 'then do' sid = ID; strata1 = ID; trt = treatment; end; this ends the 'then do' statement if SID NE (not equal to) ID then do; once again a condition for the then do instruction output; write to the table vite_b as specified above SID = ID; strata1 = strata; trt = treatment; end; ends the 'then do' statement if visit = 0 condition then plaque1= plaque instruction; if visit = 2 condition then plaque2=plaque instruction; if _N_ = nobs condition then output instruction; run; LOL!! I hope this helps Marlene

Mar1ene · ‎09-27-2018

Maybe this is useful in what you want to achieve. http://bi-notes.com/2012/10/sas-code-show-sas-macro-variables/

Mar1ene · ‎09-27-2018

Hello sasuser381 (creative name ;P), if you use proc contents data=TABLE_NAME; run; you get the table (specified) column names and attributes... is this what you're looking for? Alphabetic List of Variables and Attributes# Variable Type Len Format Label 4 EMP_BANDS Char 9 $9. EMP_BANDS 2 INCOME_BANDS Char 7 $7. INCOME_BANDS 5 INT_RATE_MARGIN_BANDS Char 18 $18. INT_RATE_MARGIN_BANDS 1 LOAN_BANDS Char 8 $8. LOAN_BANDS 6 Loan_Amount Num 8 18.2 Loan Amount 7 N Num 8 N Marlene

Mar1ene · ‎09-27-2018

Hi ... uhm ... Sathish_jammy (what should I call you?) If I understand you correctly, you basically need to include additional variables to your existing table from various servers/tables? And you do this on a regular basis, hence the macro requirement? Marlene

Mar1ene · ‎09-19-2018

Hi Tom, I have to agree, I could have worded my question better... I guess it comes with not being English 😜 ... Thank you for wanting to assist anyway!! M

Mar1ene · ‎09-19-2018

Fredrik, you are my fudging hero!! Thank you soooo much!! This is exactly what I wanted!!

Online Status	Offline
Date Last Visited	‎10-23-2023 04:48 PM

Re: How to send email using SAS

Re: How to send email using SAS

Re: Splitting a set of positive & increasing values-growth, from the f...

Re: Splitting a set of positive & increasing values-growth, from the f...

Re: Need explaination for this chunk of code

Re: Need explaination for this chunk of code

Re: Need explaination for this chunk of code

Re: Using Sas macro to fetch values from one table to another table

Formatting Email Spacing Between Text and proc print output

Re: Need explaination for this chunk of code

Re: Formatting Email Spacing Between Text and proc print output

Re: Need explaination for this chunk of code

Re: What is the purpose of _N_ syntax in the codes?

Re: Columns used in project

Re: Splitting a set of positive & increasing values-growth, from the f...

Re: Need explaination for this chunk of code

Re: Formatting proc print tables in email body text to include lines

Re: Formatting proc print tables in email body text to include lines

Re: Formatting email body text, and proc print output

Re: How to send email using SAS

Re: How to send email using SAS

Re: Splitting a set of positive & increasing values-growth, from the f...

Re: Splitting a set of positive & increasing values-growth, from the f...

Re: Need explaination for this chunk of code

Re: Need explaination for this chunk of code

Re: Need explaination for this chunk of code

Re: Using Sas macro to fetch values from one table to another table

Formatting Email Spacing Between Text and proc print output

Re: Need explaination for this chunk of code

Re: Columns used in project

Re: Columns used in project

Re: Using Sas macro to fetch values from one table to another table

Re: Formatting proc print tables in email body text to include lines

Re: Formatting proc print tables in email body text to include lines