About BonnaryW

BonnaryW · ‎08-10-2018

Thank you for your response and offer the solution Astounding.

BonnaryW · ‎08-09-2018

Hello, I am not sure if this is the right way of doing it. I would like to add month and year to the title based on what month it is. I need to add one year, if month is January, February, and March, otherwise leave year as the current year. Below is my codes. %let today = %sysfunc(today()); %let pmo1= %sysfunc(putn(%sysfunc(intnx(month,&today,+3)),monname)); %let pmo2= %sysfunc(putn(%sysfunc(intnx(month,&today,+5)),monname)); IF &pmo1 IN ("January","February","March") OR &pmo2 in ("January","February","March") THEN %let OCYR= %SYSFUNC(year(%SYSFUNC(INTNX(year,&today,+1)))); ELSE %let OCYR= %sysfunc(year(&today)); title1 "Testing &pmo1 &ocyr &pmo2 &ocyr"; Result: Testing November 2018 January 2019. Thank you.

BonnaryW · ‎08-06-2018

Thank you everyone for your response.

BonnaryW · ‎08-02-2018

Thank you for responding to my post. It work. Now, I am having problem with title have special characters (',' , '&', '/') , it get drop off from the title.

BonnaryW · ‎08-02-2018

Hello, I need how converting the first letter of each word on a title excluding the acronym. Please see below: data HAVE; input title $40.; cards; PRINCIPAL ABC SCHOOL ACCT TEACHER CBS SCHOOL MATH TEACHER NY SCHOOL run; DATA title; SET HAVE; title2 = PROPCASE(TITLE); RUN; The result should be: Principal ABC School ACCT Teacher CBS School Math Teacher NY School Thank you.

BonnaryW · ‎07-27-2018

It's Worked !! Thank you very much for simplify my codes and the explanations.

BonnaryW · ‎07-27-2018

Hello, I am trying to extract current/previous year and use it in my file name. I want to extract current year (2018) if not January and extract previous year (2017) if it's January. data _NULL_; data _null_; %let testdate=01JANE2018; %let cmons=%sysfunc(month("&testdate"d)); if &cmons = 1 then; %let syear= %sysfunc(year(%sysfunc(intnx(year,%SYSFUNC("&testdate"d)),-1)))); else; %let syear= %sysfunc(year("&testdate"d)); run; %put &cmons &syear; ods _all_ close; ods tagsets.excelxp file="c:\Reports\me_Q%sysfunc(intnx(qtr,%sysfunc(date()),-1), qtr.)_&syear..xls" style=sasweb; ods tagsets.excelxp options(sheet_name="me_Q%sysfunc(intnx(qtr,%sysfunc(date()),-1), qtr.)_&syear"); Thank you for your help.

BonnaryW · ‎07-12-2018

Hello, I need help on how to add previous QTR to the filename. My code is below. ods _all_ close; %let q= (%sysfunc(intnx(qtr,%sysfunc(date()),-1))); %put &q; ods tagsets.excelxp file="c:\myfile_Q&q..xls" style=sasweb; My filename should be "c:\myfile_Q2.xls. I am getting "c:\myfile_Q&q.xls". Thank you.

BonnaryW · ‎06-28-2018

Thank you Ballardw. It's work!

BonnaryW · ‎06-28-2018

Thank you Reeza. It's work !!!

BonnaryW · ‎06-27-2018

Hello, I am trying to convert the pmons(numeric month)to monname3. month. %let pmons = %sysfunc(month(%sysfunc(intnx(month,%sysfunc(date()),-1)))); ods tagsets.ExcelXP file="C:\Reports\TEST_ME_&pmons&cyear..xls" style=sasweb options(absolute_column_width='6,20,4'); PROC REPORT DATA=ME nowd; column ID NAME CODE; define ID / style(column)={tagattr='00000'}; My file name should be: TEST_ME_MAY2018.xls Thank you.

BonnaryW · ‎04-27-2018

Thank you so much.

BonnaryW · ‎04-27-2018

thank you so much.

BonnaryW · ‎04-27-2018

Hello, I am trying to add up the AMOUNT AND INCREASE with multiple rows have the same ID. data calc; input ID AMOUNT INCREASE cards; 8888 50 3.55 8889 1.10 0 8889 2.99 2.22 8890 3.48 15 8891 34.08 1 8891 144.87 4 8891 2.24 0.8 8892 0 0 ; I like to add the AMOUNT AND INCREASE FOR EACH ID. The result: 8888 50 3.55 8889 4.09 2.22 8890 3.48 15 8891 181.19 5.8 8892 0 0 Thank you.

BonnaryW · ‎02-22-2018

Hello, I am not an expert SAS programmer, I need help with assign value to new variables based on the "D" value "Report_Lev1", "Report_Lev2", "Report_Lev3", and "Report_Lev4". below is data and output: DATA A; ID NAME D 1 JOE DOES |- 2 RAY DOES |-| 3 JOHN DOES |-|- 4 JANE DOES |-|-| 5 ANN DOES |-|-|- 6 DAN DOES |-|-|- 7 SCOTT DOES |-|-| 8 ME DOES |-|-|- 9 KIM DOES |-|-|- 10 JANE ME |-| 11 JOE ME |-|- 12 JOHN ME |-|-| 13 ANNE ME |-|-|- 14 TIM ME |-|-|- 15 ANDY ME |-|-| 16 TRACY ME |-|-|- 17 DAVID ME |-|-|- 18 LORI ME |-|-|- I need help to produce the result below: ID NAME D Report_Lev1 Report_Lev2 Report_Lev3 Report_Lev4 1 JOE DOES |- BEGIN 2 RAY DOES |-| RAY DOES 3 JOHN DOES |-|- RAY DOES RAY DOES 4 JANE DOES |-|-| RAY DOES JOHN DOES JOHN DOES 5 ANN DOES |-|-|- RAY DOES JOHN DOES JANE DOES ANN DOES 6 DAN DOES |-|-|- RAY DOES JOHN DOES JANE DOES DAN DOES 7 SCOTT DOES |-|-| RAY DOES JOHN DOES JOHN DOES 8 ME DOES |-|-|- RAY DOES JOHN DOES SCOTT DOES ME DOES 9 KIM DOES |-|-|- RAY DOES JOHN DOES SCOTT DOES KIM DOES 10 JANE ME |-| JANE ME 11 JOE ME |-|- JANE ME JANE ME 12 JOHN ME |-|-| JANE ME JOE ME JOE ME 13 ANNE ME |-|-|- JANE ME JOE ME JOHN ME ANNE ME 14 TIM ME |-|-|- JANE ME JOE ME JOHN ME TIM ME 15 ANDY ME |-|-| JANE ME JOE ME JOE ME 16 TRACY ME |-|-|- JANE ME JOE ME ANDY ME TRACY ME 17 DAVID ME |-|-|- JANE ME JOE ME ANDY ME DAVID ME 18 LORI ME |-|-|- JANE ME JOE ME ANDY ME LORI ME Thank you for your assistance.

Online Status	Offline
Date Last Visited	‎08-13-2018 04:07 PM

Re: Adding Month Year to Title Base on the Month

Adding Month Year to Title Base on the Month

Re: PROPCASE not Acronym

Re: PROPCASE not Acronym

PROPCASE not Acronym

Re: Add Year to File Name

Add Year to File Name

Add QTR to FileName

Re: Convert numeric month to "mmm" string and use as filename

Re: Convert numeric month to "mmm" string and use as filename

Re: PROPCASE not Acronym

Re: Convert numeric month to "mmm" string and use as filename

Re: Convert numeric month to "mmm" string and use as filename

Re: Sum amount with multiple rows in to one row

Re: Sum amount with multiple rows in to one row

Turning Off HotFix Update Reminder for SAS EG 7.1

Re: Create Response File for SAS EG 7.1

Re: Adding Month Year to Title Base on the Month

Adding Month Year to Title Base on the Month

Re: PROPCASE not Acronym

Re: PROPCASE not Acronym

PROPCASE not Acronym

Re: Add Year to File Name

Add Year to File Name

Add QTR to FileName

Re: Convert numeric month to "mmm" string and use as filename

Re: Convert numeric month to "mmm" string and use as filename

Convert numeric month to "mmm" string and use as filename

Re: Sum amount with multiple rows in to one row

Re: Sum amount with multiple rows in to one row

Sum amount with multiple rows in to one row

Assign Value to new variable.