Hello, I’ve a dataset with an ID variable and two time points that can be used to identify if an individual is active between two time points. I’d like to create a dataset that can record the person’s ID and if the person is active in each year. I'd like to do fiscal year (say from April 1 to March 31), though if one program can do calendar year (i.e. from Jan 1 to Dec 31), that's be terrific too. If the active period goes cross several years’ span, this person will have multiple records. Here is the data I’ve: data aa; format id best. start end yymmdd10.; input id start yymmdd10. end yymmdd10.; datalines; 1 2006-05-05 2006-06-30 2 2006-02-05 2006-05-30 3 2006-09-01 2008-11-30 4 2006-03-31 2009-2-28 ; The output data should look like the following. Cyear is a bonus ONLY if it can easily done and does not over-complicate the program: ID Fyear Cyear 1   2006  2006 2   2005 2   2006  2006 3   2006  2006 3   2007  2007 3   2008  2008 4   2005  4   2006  2006 4   2007  2007 4   2008  2008 4            2009 Many thanks. ... View more

I've a question about how SAS handles extra spaces in a variable. I was hoping to provide an example (below) with some of the data with 2 extra spaces before or after the text "abc" but somehow SAS strips the spaces off after reading in the data and becomes one value abc for all observations. But my question is quite simple. If I've data with spaces before or after some text for a variable, do I need to use the compress function to make sure I'm selecting only the text part? If I've 5 observations with text = "abc",  "  abc",  "abc  ",  "  abc  ", or "abcdef", I don't care about the extra spaces, and I want all 4 cases with only abc in it (I don't want the "abcdef" case), can I use just    IF text='abc'; or I need to use the compression function:   IF COMPRESS(text)='abc' I read somewhere that SAS's default is compressing spaces with statements such as the following. Is it correct? If so, I can just use IF text='abc' as it is redundant to use IF COMPESS(text)='abc';    if compress (var, '');    new_variable=compress (variable, ''); Thanks, -----------Example - though it seems SAS automatically compresses the data once reading in the data, data aa; input text $ 1-10; datalines; abc abc    abc   abc   ; run; data aa1; set aa; if text='abc' then v1=1; proc print; run; ... View more

Hi, I'd like to use %do year=2002  %to year=2011 for the 10 years of data I'd like to run, however, my source data is not 4 digits or even 2 digits, but like 0203, 0304, 0405 ...1112. How can I get around with it if I still want to use %do loop? >>>> If I don't use %do %to: proc means data=amount0203 nway noprint;      var amount; class sex;      output out=out2002 (drop=_type_ _freq_) sum=;      run; ... proc means data=amount1112 nway noprint;      var amount; class sex;      output out=out2011 (drop=_type_ _freq_) sum=;      run; I was hoping to use %do YEAR=2001 %to 2011, but how do I get around with the nonconsecutive part of the dataset name while using %do loop? %macro year(); %do YEAR=2002 %to 2011; proc means data=amount***1112*** nway noprint;      var amount; class sex;      output out=out&YEAR (drop=_type_ _freq_) sum=;      run; %end; %mend year; %year; Thanks in advance. ... View more

Hello, I want to create a new macro variable (year+1) based on the macro year variable (2009-2012) and apply the new macro variable to the age calculation - that is, for 2009 data, the age calculation should be based the fiscal year end, that is March 2010, etc.    Age = INT((INTCK('month', DOB,'31mar&year2.'d) - (DAY(DOB)>DAY('31mar&year2.'d)))/12); I thought it would work but it didn't; SAS didn't recognize the year2 variable. Here is the macro: %macro service_age (); %do year=2009 %to 2011; data list&year; merge  dob_data (in=a)   service&year (in=b); by id;     if a and b;     %let year2=1+&year;     Age = INT((INTCK('month', DOB,'31mar&year2.'d) - (DAY(DOB)>DAY('31mar&year2.'d)))/12); run; %end; %mend service_age; %service_age; If I don't use macro, it'd look like the following: data list2009; merge  dob_data (in=a)   service2009 (in=b); by id;     if a and b;     Age = INT((INTCK('month', DOB,'31mar2010'd) - (DAY(DOB)>DAY('31mar2010'd)))/12); run; data list2010; merge  dob_data (in=a)   service2010 (in=b); by id;     if a and b;     Age = INT((INTCK('month', DOB,'31mar2011'd) - (DAY(DOB)>DAY('31mar2011'd)))/12); run; data list2011; merge  dob_data (in=a)   service2011 (in=b); by id;     if a and b;     Age = INT((INTCK('month', DOB,'31mar2012'd) - (DAY(DOB)>DAY('31mar2012'd)))/12); run; Thanks in advance for the help. ... View more

Hi I have some daily data but some days may have missing data. I'd like to output only records for every 365 days, and if the data is missing for that day, I'd like to choose the nearest day point to output - either before or after. Is there an easy and efficient way to do it? Thanks in advance. data data; input days; datalines; 1 364 365 729 732 1094 1096 1099 3285 3630 3675 ; Desire output: 365 729 1096  (either 1094 or 1096 is fine, preferably the latter day though) 3285 3630 ... View more