About mlogan

mlogan · ‎05-18-2018

Here is what my data situation and what I want. My fiscal year goes from March 1 to end of February. At any given day (let's say today) I have my current fiscal year data until today (Mar 01 2018 - May 19 2018) and data from last 2 full fiscal year. For example today I have: FiscalYear 2018-2019: Mar 01 2018 - May 19 2019 Fiscal Year 2017-2018: Mar 01 2017 - Feb 28 2018 Fiscal Year 2016-2017: Mar 01 2016 - Feb 28 2017 WHAT I WANT: ------------------- Filter the data until the end of last month (in my case April of 2018-2019 Fiscal Year) and I want the code to determine that from system date. Filter the data from each last 2 fiscal year until the end of April of each year. In my example it will be April 2017 & April 2016. Every month when I will run my code, I don't want to change my Year/Fiscal year manually on my code. My output table should look like this: 16Mar2016 Bio2 01Mar2018 Eng1 15Mar2018 Bio1 27Apr2018 Bio1 HERE IS MY Example DATA DATA have; INPUT Date Course_ID $4.; INFORMAT Date Date9.; FORMAT Date Date9.; DATALINES; 05Jan2018 ENG1 16Aug2017 Bio2 11MAY2015 Eng2 28Feb2018 Geo2 16Mar2016 Bio2 01Mar2018 Eng1 09Feb2017 Che1 19Jan2015 Phy2 15Mar2018 Bio1 12Mar2015 Phy2 19May2018 Che1 27Apr2018 Bio1 ; PROC PRINT NOOBS; RUN;

mlogan · ‎05-18-2018

I Ksharp, I actually wanted to make it dynamic so that at any given month when I will run my code, it will grab/filter the data until the last date of previous month of every year of the date field. DATA have; INPUT Date Course_ID $4.; INFORMAT Date Date9.; FORMAT Date Date9.; DATALINES; 05Jan2018 ENG1 16Jan2017 Bio2 09Dec2016 Che1 15Jan2018 Bio1 11MAY2015 Eng2 12Mar2016 Phy2 20May2018 Che1 ; PROC PRINT NOOBS; RUN; I have written the following code, but can really make it work at the end. Can you please help. Thanks. DATA want; SET have; Y0_FYb=YEAR(intnx('YEAR.4',date,0)); Y0_FYe=YEAR(intnx('YEAR.4',date,0,'e')); Y0_fromdate=intnx('year.4',date,0,'b'); Y0_todate=intnx('MONTH',date,-1,'e'); Y1P_FY=YEAR(intnx('YEAR.4',date,0)); Y1P_fromdate=intnx('year.4',date,0,'b'); Y1P_todate=intnx('MONTH',date,-1,'e'); Rep_ToMonth=intnx('MONTH', date , -1, 'e'); fy2 = COMPRESS(Y0_FYb||"-"||Y0_FYe); FORMAT Y0_fromdate Y0_todate Rep_ToMonth date date9.; PROC PRINT NOOBS; RUN; DATA Final; SET want; WHERE Rep_ToMOnth >= intnx('MONTH', %SYSFUNC(today()), -1, 'e'); RUN; PROC PRINT NOOBS; RUN;

mlogan · ‎05-16-2018

Thanks Kharp. I wanted to query from the Year18_19 and Year17_18 dataset and get the following output: From Year18_19: ---------------------- Date1 Course_ID age 09Apr2018 Che1 10 11MAY2018 Eng2 15 09Mar2018 Phy2 11 From Year17_18: ---------------------- Date1 Course_ID age 05Jan2018 ENG1 10 11MAY2017 Eng2 15 22Apr2017 Phy2 11 20Feb2018 Che1 15

mlogan · ‎05-16-2018

DATA Year18_19; INPUT Date1 Course_ID $4. age 3.; INFORMAT Date1 Date9.; FORMAT Date1 Date9.; DATALINES; 05Jan2018 ENG1 10 16Feb2018 Bio2 15 09Apr2018 Che1 10 15Jan2018 Bio1 11 11MAY2018 Eng2 15 09Mar2018 Phy2 11 20Feb2018 Che1 15 ; RUN; PROC PRINT DATA=Year18_19 NOOBS; RUN; DATA Year17_18; INPUT Date1 Course_ID $4. age 3.; INFORMAT Date1 Date9.; FORMAT Date1 Date9.; DATALINES; 05Jan2018 ENG1 10 16Jan2017 Bio2 15 09Feb2017 Che1 10 15Mar2018 Bio1 11 11MAY2017 Eng2 15 22Apr2017 Phy2 11 20Feb2018 Che1 15 ; RUN; PROC PRINT DATA=Year17_18 NOOBS; RUN; Hi, My Fiscal Year goes from March 01 to February 30. When I am in the month of May now, I want to pull all the data for this fiscal year (from dataset Year18_19 above) UNTIL last month. and I want the system to calculate that from sysdate. So for this fiscal year code should return the following observations from dataset Year18_19: Date1 Course_ID age 09Apr2018 Che1 10 11MAY2018 Eng2 15 09Mar2018 Phy2 11 Now I want to do the same for the last Fiscal year (Year17_18) which will return: Date1 Course_ID age 05Jan2018 ENG1 10 11MAY2017 Eng2 15 22Apr2017 Phy2 11 20Feb2018 Che1 15

mlogan · ‎05-15-2018

DATA Year18_19; INPUT Date1 Course_ID $4. age 3.; INFORMAT Date1 Date9.; FORMAT Date1 Date9.; DATALINES; 05Jan2018 ENG1 10 16Feb2018 Bio2 15 09Apr2018 Che1 10 15Jan2018 Bio1 11 11MAY2018 Eng2 15 09Mar2018 Phy2 11 20Feb2018 Che1 15 ; RUN; PROC PRINT DATA=Year18_19 NOOBS; RUN; DATA Year17_18; INPUT Date1 Course_ID $4. age 3.; INFORMAT Date1 Date9.; FORMAT Date1 Date9.; DATALINES; 05Jan2018 ENG1 10 16Jan2017 Bio2 15 09Feb2017 Che1 10 15Mar2018 Bio1 11 11MAY2017 Eng2 15 22Apr2017 Phy2 11 20Feb2018 Che1 15 ; RUN; PROC PRINT DATA=Year17_18 NOOBS; RUN; Hi, My Fiscal Year goes from March 01 to February 30. When I am in the month of May now, I want to pull all the data for this fiscal year (from dataset Year18_19 above) UNTIL last month. and I want the system to calculate that from sysdate. So for this fiscal year code should return the following observations from dataset Year18_19: Date1 Course_ID age 09Apr2018 Che1 10 11MAY2018 Eng2 15 09Mar2018 Phy2 11 Now I want to do the same for the last Fiscal year (Year17_18) which will return: Date1 Course_ID age 05Jan2018 ENG1 10 11MAY2017 Eng2 15 22Apr2017 Phy2 11 20Feb2018 Che1 15 I tried to follow the following code to accomplish it, but I really can't get anything out of it. I will really appreciate any help on this. Thanks, %let previous_month = %sysfunc( intnx( MONTH , %sysfunc( today() ) , -1) , yymmN6.); %MACRO fy (date , start=7); year(&date) + (month(&date) ge &start and &start ne 1) %MEND; DATA try_FY; this_date = date(); FiscalYear = %FY( this_date , start = 3 ); PUTLOG FiscalYear = Txn_Date=date9.; RUN;

mlogan · ‎03-10-2018

Hi All, Is there anyone who is successful sending email through Office 365 server using SAS 9.4. There are lots of information on the net and none of them are working for me. I would appreciate if can share a code that is working for Office 365. Thanks,

mlogan · ‎03-07-2018

Hi SuryaKiran, Is the code working for you?

mlogan · ‎03-07-2018

Hi RW9, Would you please test if this is code is working at your end. It's not working at my end. May be I am missing something. I want to get rid of a value where there is 6 9s only, NOT 99999999. DATA Have; INPUT ID VAR1$ VAR$ VAR6$; DATALINES; 101 ENG1 15225555 NY 105 Che1 10222541 NY 109 Eng2 999999 CA 115 Phy2 1156858 PA 201 Che1 99999999 TX ; RUN; data want; set have; if strip(var4)="999999" then var4=""; run; Thanks,

mlogan · ‎03-07-2018

Hi RW9, Your index function works, but it is removing '99999999' instead of '999999' also it is working for Numeric variable. do you know how I should modify your code if it is a Character value? Thanks,

mlogan · ‎03-07-2018

Hi All, I wanted to know what would be the best command to remove one specific value from a variable. For example, I want to remove the value '999999' (a value containing 6 nines) from VAR4 of the following table. DATA Have; INPUT ID VAR1$ VAR4$ VAR6$; DATALINES; 101 ENG1 15225555 NY 105 Che1 10222541 NY 109 Eng2 999999 CA 115 Phy2 1156858 PA 201 Che1 99999999 TX ; RUN; Expected output table: ID VAR1 VAR4 VAR6 101 ENG1 15225555 NY 105 Che1 10222541 NY 109 Eng2 CA 115 Phy2 1156858 PA 201 Che1 99999999 TX Thanks,

mlogan · ‎03-07-2018

Thanks Tom. I did figure that out. Yes, you are right ATTRIB and LENGTH really worked well at the end.

mlogan · ‎03-05-2018

Thanks for your reply Tom. Maximum length of the data is 61,983,986 Would you please tell me what would be the length size to show this value up as character. I am very sure that I defined the value as 8 but for some reason it shows one digit only. If I define the length as 7 or below, it still shows 1 digit. Thanks

mlogan · ‎03-05-2018

I still can't see the data under converted variable. In my original data my old variable features are: TYPE Numeric LENGTH 8 FORMAT BEST12. INFORMAT BEAT32. Example of my data: 61,983,986 When I convert it to char_var = put(num_var, 8.) I get only 6 instead of 61,983,986 and when I convert with 12. I get nothing on my new character variable.

mlogan · ‎03-05-2018

Sorry folks, I still can't see the data under converted variable. In my original data my old variable features are: TYPE Numeric LENGTH 8 FORMAT BEST12. INFORMAT BEAT32. Example of my data: 61,983,986 When I convert it to char_var = put(num_var, 8.) I get only 6 instead of 61,983,986 and when I convert with 12. I get nothing on my new character variable.

mlogan · ‎03-05-2018

Hi Reeza, I still can't get rid of the comma in my VARnew variable. Can you please help. Also please remember on my original data The NLNUM variable's FORMAT is 12. and INFORMAT32. Thanks. DATA Have; INPUT ID VAR1$ VAR4 VAR6$; FORMAT VAR4 NLNUM12.; DATALINES; 101 ENG1 15225555 NY 105 Che1 10222541 NY 109 Eng2 1511445 CA 115 Phy2 1156858 PA 201 Che1 14445555 TX ; RUN; DATA Want; VARnew=put(VAR4, NLNUM12.); SET Have; RUN;

Online Status	Offline
Date Last Visited	‎04-10-2025 02:32 PM

Re: Redistributing numbers

Re: Redistributing numbers

Re: Redistributing numbers

Re: Redistributing numbers

Re: Redistributing numbers

Re: Redistributing numbers

Redistributing numbers

Re: How to apply format to all numeric values all at once

How to apply format to all numeric values all at once

Connecting DB2 Database using sas base.

Re: Redistributing numbers

Re: Redistributing numbers

Re: Redistributing numbers

Re: How to apply format to all numeric values all at once

Re: Dynamic Calculations of Variables

Redistributing numbers

Adding an empty row after each by group

csv import with text qualifier

Retrieving Data with REST API

Re: Export SAS 9.4 file to Access .mdb

Dynamic filtering of data until last month of every year

Re: Coding with Fiscal Year

Re: Coding with Fiscal Year

Coding with Fiscal Year

Coding with multiple Fiscal Year Data

Email using Office 365 from SAS 9.4

Re: Removing one specific value

Re: Removing one specific value

Re: Removing one specific value

Removing one specific value

Re: Convert from NLNUM12. to Character

Re: Convert from NLNUM12. to Character

Re: Convert from NLNUM12. to Character

Re: Convert from NLNUM12. to Character

Re: Convert from NLNUM12. to Character