It is not allowed to distribute these databases. It will be a problem for Author if he/she is using some data which is not subscribed by their institutions. The most likely way is to collaborate (joint research) with someone from the institution who has access.  ... View more

THank you @art297. I just noted there were few missing ISIN which were creating this problem. The codes written by Tom worked. Thank you for you time. Good day Kyojik ... View more

This is often called "converting from wide to long format."  You can use PROC TRANSPOSE as in this example or read this article for a DATA step or macro approach.   data Have; input country $1 y1920 y1921 y1923 y1924; Subject + 1; /* define ID */ datalines; A 1 1 1 1 B 1 2 3 1 C 2 1 2 9 ; /** 2. Transpose the variables from wide to long format **/ proc transpose data=Have out=long1(rename=(Col1=ER)) name=cYear; by Subject; /** for each subject **/ var y1920 y1921 y1923 y1924; /** make a row for these variables **/ run; /** 3. Optional: Convert to numeric year **/ data long; set long1; Year = input( substr(cYear, 2, 4), 4. ); drop cYear; run; proc print; run; ... View more

@Kyojik Please post as a new question and link to this or your partial solution ideally. Make sure to include sample data. You'll get a faster response that way. As initially mentioned, PROC EXPAND is the easiest to code solution if you have SAS/ETS licensed. ... View more

@Kyojik Hi, Sorry for not being able to give you the much needed solution last night as I was awefully tired. Here you go, the below will work for multiple companies. Please do let me know should if it doesn't quite meet your requirement. It's actually easy. So feel free to reach out.   Regards, Naveen Srinivasan   proc sort data=have; by companyname year month; run;   data want(rename=(_month=month)); do until(last.companyname);    do until(last.year);       set have;        by companyname year month;        length _type __type $1;        if first.companyname or first.year then call missing(_month,_type,__type);        if first.year and last.year and month=12 then          do;               _month=month;               output;            end;        else if (first.year and last.year) and month<12 then          do;               do _month=month to 12;               output;               end;          end;       else if (first.year and not last.year) and month<12 then          do;                _month=month;                 _type=type;            end;       else if not first.year then          do;               __type=type;               do _month=_month to month-1;               type=_type;               output;               end;               _type=__type;               if last.year then do;               do _month=month to 12;               type=_type;               output;               end;            end;       end;   end; end; drop month _type __type; run; ... View more