About Danglytics

Danglytics · ‎07-26-2011

Hi, I'm trying to get the difference in Years between two dates at the end of each month end date. MembershipDate: which is a Datetime format and I have a parameter I reference throughout my code to be the month end date: %let cur_mth_end = '31Jan10'd. I used the function Tenure = Datdif (MembershipDate, &cur_mth_end, 'act/act') / 365 ; but I get the note: Invalid argument to function DatDif I'm pretty sure its because MembershipDate is a datetime format, but not sure how to fix this. Thanks for your help.

Danglytics · ‎07-26-2011

Hi, I have a piece of code that I convert a numeric into a character: char_var = put(num_var, $16.) ; and I get the warning "Variable num_var has already been defined as numeric." can anyone tell me how to get rid of this? from that point forward I only use the character version of the variable. Thanks for your help.

Danglytics · ‎07-21-2011

Great thanks for your help.

Danglytics · ‎07-21-2011

yes exactly, is there a way around the warning?

Danglytics · ‎07-21-2011

Is their a way to force the length for the new dataset? for example: table1: Product $15 table2: Product $15 table3: Product $17 table4: Product $15 for some reason i have some dirty records in table3 that makes the product variable $17, In my merged dataset I want to make product $15, and its fine if its truncated.

Danglytics · ‎07-21-2011

yes the warning still shows up if do: data merged ; length product $15 ; set table1 table2 table3 table4 ; run ;

Danglytics · ‎07-21-2011

Hi, I think this is a simple solution, but I can't seem to figure it out. I have multiple datasets in the exact same data layout that i'd like to concatenate using the data step. for example: data merged ; set table1 table2 table3 table4 ; run ; A variable may have different lengths in each of the tables so when I run the code above I get the warning: "Multiple lengths were specified for the variable Product by input data set(s). This may cause truncation of data." I tried adding the length statement but still got the warning. How can I set the length so I do not get the warning? Thanks for your help.

Danglytics · ‎06-27-2011

Thank you for your help! This solution worked perfectly.

Danglytics · ‎06-24-2011

I've triple checked the code, and still now sure why it only outputs the first and last record

Danglytics · ‎06-23-2011

After making the adjustments to fit my actual datasets, the code ran without problem, but when i look at the 'collections' table i get the initial record which is blank except for number_of_rows = 1 and the second record which is the information of my last data set (20110430). I can't seem to figure out why it is not outputting the datasets in between.. I should have 7 datasets in there, from 20101031 to 20110430. Thanks again for your replies.

Danglytics · ‎06-22-2011

Thank you both for your help. I see the logic behind using modate as the identifier for the file date, but unfortunately the date does not match. for example my 20110430 file has date modified of 25May2011

Danglytics · ‎06-22-2011

Old files do not change. All files are SAS files. i'm not sure if the dictionary.tables will work as there are many other tables within that library.

Danglytics · ‎06-21-2011

Hi, Every month I receive a data dump of indicators and counts by id. the tables are loaded in the following manner: src.indicators_20110131 src.indicators_20110228 src.indicators_20110331 etc.. the latest month should always have more records than the previous. and look like this: id count1 ind1 count2 ind2 1 3 1 0 0 2 0 0 2 1 .. essentially if the count exists the indicator is a 1, else 0 . What I want to do is to create a checking program that looks at the %change in # records from the previous month. My current logic/checking program is quite manual and I hope to alter it to be more automatic with some sort of iterative processing. My program now looks like: %let month1 = 20110131 %let month2 = 20110228 etc. proc sql create table src.check_&month1 as select count(*) as numrows_&month1 from src.indicator_&month1 ; code above repeated for every months data, then datastep to merge [merge check:] . I havent completed the calculation step yet. This was just a first stab at it, and is very manual (every month I would have to add a proc sql step above. If anyone has any suggestions that would be great. Thanks for your help!

Danglytics · ‎06-16-2011

I think ive figured it out. data rollup ; set transactions ; by id ; retain earliestdate ; if first.id then do; sales_sum=. ; earliestdate= '01jan3000'd *set date to sometime way in the future, i know probably not the best practice.. ; end; earliestdate = min(earliestdate,date) ; sales_sum + sales ; if last.id then output ; run ;

Danglytics · ‎06-16-2011

This is an overly simplified example of the actual data i'm using, and for that reason theproc summary / means wouldnt work, so i was hoping to incorporate some sort code to my data step. but in this case i would do data rollup ; set transactions ; by id ; if first.id then do sales_sum=. ; sales_sum + sales ; if last.id then output ; run ; i havent been able to figure out capturing the earliest transaction date part of the code yet.

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

DATDIF function

Warning in data step

Data step Length

Data step Length

Data step Length

Data step Length

Data step Length

Re: Data check program: logic

Re: Data check program: logic

Re: Data check program: logic

Re: Data check program: logic

Re: Data check program: logic

Data check program: logic

Re: Max/Min date function on a variable

Re: Max/Min date function on a variable