cynqiu's articles:

Items(10) /1

Re: quoting problem #4 0 14 (12/5/2007 8:35:08 PM) comp.soft-sys.sas Thank you! ... cynqiu

quoting problem #2 0 9 (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 please 1 35 (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 #3 0 35 (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 problem 4 28 (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 #3 1 22 (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 function 3 32 (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

Re: date question #3 1 38 (10/3/2003 5:17:51 PM) comp.soft-sys.sas How then do I resolve the value of date2 (created by the %let)? ... cynqiu

date question 2 37 (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 SQL 1 37 (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