About Danglytics

Danglytics · ‎03-07-2012

Hi, I'm not sure how to classify an ID to the month end date when I have a date variable for them. for example i'd like my data set to look like: where i have ID and Date and need to create FILE PERIOD ID Date FILE_PERIOD 1 01Jan2012 31Jan2012 2 05Feb2012 29Feb2012 etc.. thank you for your help.

Danglytics · ‎02-23-2012

thank you.

Danglytics · ‎02-23-2012

Hi, I have a character field i'd like to clean up by using a delimiter. for example my data has a bunch of codes that look like: tmp435-abc tmp902-cde tp309-dmco etc. i'd like to clean up the variable to cut off at the '-' delimiter. I'm not sure what the right function to use is. Thanks for your help.

Danglytics · ‎02-21-2012

Hi, I have a logic problem and an issue with creating a macro that will take a previous month end date from a specified date. for example: if i have a date at any point before the month end i'l like to create a USAGE_TIMESTAMP variable of the previous month end. otherwise if i have a date at the month end i'd like the USAGE_TIMESTAMP to be at the current month end. I'm not sure if the above is possible to automate but an example would be as follows: Middle of the month example: %LET DATE='15NOV2011'D; %LET TIMESTAMP=2011NOV15; %LET USAGE_TIMESTAMP =2011OCT31 Month end example: %LET DATE='30NOV2011'D; %LET TIMESTAMP=2011NOV30; %LET USAGE_TIMESTAMP =2011NOV30 i've tried the following for USAGE_TIMESTAMP, it gives me the right date, but i tried using it in a data step (data A.FILE_&USAGE_TIMESTAMP) and i get an error because it is outputting the formula as a text rather than the "2011OCT31": %LET USAGE_TIMESTAMP = INTNX('MONTH',&DATE,-1,'END') ; Thank you for your help.

Danglytics · ‎02-17-2012

thank you, worked perfectly.

Danglytics · ‎02-17-2012

thanks Art, when i remove the quotes i'm still getting an error for the pcoess Apparent symbolic reference TYPE_CNT_INCOM not resolved. DATA WORK.TEST; SET DATA.TEST; %MACRO USAGE(TYPE); IF EVENT_TYPE IN ("&TYPE") AND DIRECTION IN ('INCOM') THEN DO; USE_&TYPE_CNT_INCOM=COUNT; END; IF EVENT_TYPE IN ("&TYPE") AND DIRECTION IN ('OUTGO') THEN DO; USE_&TYPE_CNT_OUTGO=COUNT; END; %MEND; %USAGE(SMS); %USAGE(MMS);

Danglytics · ‎02-17-2012

Am I able to embed a text from a macro into a variable name? the following code isnt working, but i'd like to create 2 vars in this case: USE_SMS_CNT_INCOM USE_MMS_CNT_INCOM DATA WORK.TEST; SET DATA.TEST; %MACRO USAGE(TYPE); IF EVENT_TYPE IN ("&TYPE") AND DIRECTION IN ('INCOM') THEN DO; USE_"&TYPE"_CNT_INCOM=COUNT; END; IF EVENT_TYPE IN ("&TYPE") AND DIRECTION IN ('OUTGO') THEN DO; USE_"&TYPE"_CNT_OUTGO=COUNT; END; %MEND; %USAGE(SMS); %USAGE(MMS); Thanks.

Danglytics · ‎02-17-2012

Hi, I have a macro to stack 2 files, but i want to do is create a variable with the timestamp of where the file is coming from, I'm not sure how to just extract the text from the code file name to create the variable FILE_PERIOD. likely pretty obvious but my code below for file_period does not work.. %MACRO STACK(STACKED,FILE1,FILE2) ; DATA B.&STACKED ; SET A.&FILE1 A.&FILE2 ; FILE_PERIOD = SUBSTR(&FILE1,7,10) ; RUN; %MEND ; %STACK(STACKED_2011DEC31,FILE1_2011DEC31,FILE2_2011DEC31) ; Thanks for your help.

Danglytics · ‎02-02-2012

Hi, I have a macro set up that calculates the days inbetween two dates: %MACRO DAYS_DIFF(CURR_PER,PREV_PER); DATA A.TEST; SET A.PAYMENT_CHARGE_&TIMESTAMP; IF ME_S&CURR_PER='A' THEN DO; IF ABS(INTCK('DAYS',CM&CURR_PER,PM&CURR_PER))<ABS(INTCK('DAYS',CM&CURR_PER,PM&PREV_PER)) THEN DAYS_DIFF_&CURR_PER=INTCK('DAYS',CM&CURR_PER,PM&CURR_PER); ELSE DAYS_DIFF_&CURR_PER=INTCK('DAYS',CM&CURR_PER,PM&PREV_PER); END; IF ME_S&CURR_PER='S' AND CM&CURR_PER^=. THEN DAYS_DIFF_&CURR_PER=INTCK('DAYS',&CUTOFF_DATE,CM&CURR_PER); IF ME_S&CURR_PER='C' AND CM&CURR_PER^=. THEN DAYS_DIFF_&CURR_PER=INTCK('DAYS',&CUTOFF_DATE,ME_D&CURR_PER); RUN; %MEND; %DAYS_DIFF(1,2); %DAYS_DIFF(2,3); %DAYS_DIFF(3,4); %DAYS_DIFF(4,5); %DAYS_DIFF(5,6); %DAYS_DIFF(6,7); if i run this i will get an output of the last variable: DAYS_DIFF_6 i'm having troubles creating the final dataset that will combine all the DAYS_DIFF_1 - DAYS_DIFF_6 onto one dataset. thanks for your help!

Danglytics · ‎02-01-2012

thank you for your help. what happens to months with 31 days? I assume it goes to month end?

Danglytics · ‎02-01-2012

Hi, I have a statement end date that I need to figure the statement start date, which is exactly the same day but in the month previous. for example id bill_end_date bill_st_date 1 12Jan2011 12Dec2010 2 23Feb2011 23Jan2011 etc. thanks for your help.

Danglytics · ‎01-16-2012

Hi, I have a process flow with a Setup program that contains my month end time periods: ***************************************************************************************************; * SETUP /***************************************************************************************************; %LET CUTOFF_DATE='31OCT2010'D; %LET TIMESTAMP=2010OCT31; ***************************************************************************************************; %LET CUTOFF_DATE='30NOV2010'D; %LET TIMESTAMP=2010NOV30; ***************************************************************************************************; %LET CUTOFF_DATE='31DEC2010'D; %LET TIMESTAMP=2010DEC31; etc.. Currently i am having to comment out the code and run the entire process flow based on one time period, then changing it and pressing run process flow again for the next time period. it is very manual, and not at all efficient, I was wondering if there is a way for me to automate this? in a macro? part of EG? thanks for your help!

Danglytics · ‎01-10-2012

i'm not sure if i'm following the holding logic correctly data work.example_new ; set work.example; retain hold_bill_st_date hold_bill_nd_date ; hold_bill_st_date = bill_st_date ; hold_bill_nd_date = bill_nd_date ; if bill_nd_date = . then bill_nd_date = hold_bill_nd_date ; if bill_st_date = . then bill_st_date = hold_bill_st_date ; run ; i dont think the above is working correctly..

Danglytics · ‎01-10-2012

Thanks for the quick reply. i'll give it a try, but my gut feeling is it wont work with this data set, there might be a few exceptions..

Danglytics · ‎01-10-2012

Hi, I have a question regarding logic to my dataset. an example of my data is: id bill_cycle bill_st_date bill_nd_date action action_date 1 26 01/26/2011 02/27/2011 open 01/26/2011 1 26 . . closed 02/24/2011 1 26 02/26/2011 03/27/2011 open 02/26/2011 etc. I have certain transactions in my data that do not have a bill_st_date, or bill_nd_date, i want to assign that transaction to bill_st_date and bill_nd_date for the action date that the transaction falls into. the bill_cycle will always be the bill_st_date's day. so i'd like it to look like: id bill_cycle bill_st_date bill_nd_date action action_date 1 26 01/26/2011 02/27/2011 open 01/01/2011 1 26 01/26/2011 02/27/2011 closed 02/24/2011 1 26 02/26/2011 03/27/2011 open 02/26/2011 Thanks for your help.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

array and loops? recoding into different variables

Text Parsing

Re: Stacking data

Stacking data

Help with Arrays

Proc Freq Output

what is wrong with this code?

data step logic

Output Proc Logisitic into a dataset

Output Proc Logisitic into a dataset

Renaming unconventional Variable names

Re: Data check program: logic

end of month date

substring by delimiter?

substring by delimiter?

setting macro dates

macro to extract text?

macro to extract text?

macro to extract text?

macro to extract text?

Macros help

Date logic

Date logic

Macro to automate process flow run?

data logic

data logic

data logic