quoting problem #209 (12/5/2007 5:49:44 PM) comp.soft-sys.sas I'm trying to extract the last two characters from a macro variable then use the result to create a date constant in a data step. Here's some code that doesn't work: %macro test (FY=); %let y = 30sep20%subst... cynqiu
still need help please135 (9/30/2004 6:56:25 PM) comp.soft-sys.sas For those who replied thank you. However your solutions were not what I was looking for. I need to compare every value of a_date with every value of b_date and then calculate a count of a_date values that are ... cynqiu
Re: counting with dates using SQL problem #3035 (9/30/2004 6:40:36 PM) comp.soft-sys.sas I just want to clarify: I used the SQL approach because I need to compare every value of a_date with every value of b_date to obtain a count of the values of a_date that are less than or equal to b_date. Hope... cynqiu
counting with dates using SQL problem428 (9/30/2004 6:27:43 PM) comp.soft-sys.sas Hi SASperts, Can someone help me? In the program below I'm trying to count the number of instances of a_date where a_date is less than or equal to b_date. This is the result I get: id b_date a_date ... cynqiu
Re: OT: Outsourcing #3122 (8/3/2004 5:49:55 PM) comp.soft-sys.sas More insidious than outsourcing is what I call �in sourcing� � the practice of US companies of hiring foreign college graduates as programmers. In exchange for a work visa and below market wages the company pay... cynqiu
Overflow error with lag function332 (12/1/2003 7:38:34 PM) comp.soft-sys.sas Hi SAS-l'ers , I am having problems with a program that I would like would return the number of days for a given id between two dates. For example in the data below the program would calculate number of days ... cynqiu
date question237 (10/3/2003 4:46:30 PM) comp.soft-sys.sas Can someone tell me why I am getting different results for date1 and date2? data _null_; date1 = '31MAR2003'd; call symput ('date1',date1); run; %let date2 =%STR('31MAR2003'd); %put &date1 ; %put &date... cynqiu
learning SQL137 (9/26/2003 5:35:47 PM) comp.soft-sys.sas I recently started working for an organization that uses SQL Server. The data is scattered in several dozen different tables. I have been given the task of simplifying existing SAS programs - some that have 20... cynqiu