Hello all,   how could I create a table from  psn_name, application200001, application200002, application200003 a,1,2,3 b,2,3,4 to psn_name, date, Number_of_applications a,200001,1 a,200002,2 a,200003,3 b,200001,2 b,200002,3 b,200003,4 an example I need is  could you please give me some suggestions?    thanks in advance.   ... View more

dear all,   I would like to create a quarter variable based on a date variable.   The FORMAT of the date is YYMMDDD10. (e.g.,1990-09-29). I use the code like  DATA Step1.Appln_newQuarter; SET Step1.appln_new; IF MONTH(earliest_filing_date)=1 or 2 or 3 THEN quarter=1; ELSE IF MONTH(earliest_filing_date)=4 or 5 or 6 THEN quarter=2; ELSE IF MONTH(earliest_filing_date)=7 or 8 or 9 THEN quarter=3; ELSE IF MONTH(earliest_filing_date)=10 or 11 or 12 THEN quarter=4; RUN; but the result is '1'. could you please give me some suggestions?   thanks in advance.      ... View more

Dear all,   I would like to make a statistic like a highlight part of the following,  I have the dataset like this    the psn_name is the company's name. the No_of_cit20051 is the month Jan 2005, the number in the table (like 0 and 4) is the number of patent applications made at that month. I have the number of patent applications made by each company each month during the period between 2005 and 2010.   I am confused about how to make the second table like the first one? Could you please give me some suggestion?   thanks in advance. ... View more

dear all   i would like to make a statistic by using following codes   proc univariate data=Step6.Number_of_patent_us_end; var col1-col91440; output=Step6.patent_us mean=mean max=max min=min std=std; run;  but the result shows that, 16 proc univariate data=Step6.Number_of_patent_us_end; 17 var col1-col91440; 18 output=Step6.patent_us mean=mean max=max min=min std=std; ------ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 19 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 0.09 seconds cpu time 0.10 seconds could you please give me some suggestion? thanks in advance. ... View more

dear all,   how could i delete the same observation in the data set?   for example    name, 20001, 200002 aaa,1,1 aaa,1,1 aaa,1,2 bbb,1,2 how do I only keep one 'aaa,1,1' in the dataset and get the following data   name, 20001, 200002 aaa,1,1 aaa,1,2 bbb,1,2 Could you please give me some suggestion?   many thanks in advance. ... View more