These combinations include duplicates and same-element combinations, whereas I don't want these duplicates and same element combinations - how would I in this case delete the duplicates and same value combs? ... View more

Hi PaigeMiller,   this code is quite simple, and I didn't even think of it!   But this code has repetitions, that is, since I have 5 elements it gives me all the pairs twice and also the pair of each element with itself   5sq = 25 pairs,   but if I want the unique non-same pairs I should get (25-5)/2 = 10 pairs     Thanks!  ... View more

Hi novinsorin,   I am not familiar with hash, is it possible to get the solution in a macro form similar to this:   proc sql; select element into :element_list separated by ' ' from have ; quit; proc sql; select count(element) into :n from have ; quit; %put &element_list; %put &n; %macro m1; data want; %do i=1 %to &n; %let var1=%scan(&element_list,&i); var1=&var1; %end; %mend m1; %m1   Thank you ... View more

Hi,   as you can see I included the additional "industry" variable. So I guess that for more variables I will have to repeat the process.   Thanks! ... View more

Thanks for the code. I managed to include an additional "industry" variable:   data want; set have2 ; retain _flag 0 _line _n _line2 _n2 ; if find(line, "stock")>0 then do; __n=0; _flag=1; _n=n; _line=line; end; if _flag then __n+1; if __n=3 then do; _n2=n; _line2=line; end; if __n=5 then do; n=_n; industry=line; price=_line2; line=_line; output; end; drop _: ; run; so I guess that if I had more variables to create I would just repeat the process ... View more

Hi novinosrin,   for the line in your code:    else if index(line,'$')>0 then do;   if I understand correctly the code looks for the symbol "$", but in my case I have many useless lines that contain the symbol "$", so it is really the relative position of the lines from the line that contains the word "stock" that are important ... View more

Hi draycut,   thanks for the code, worked perfectly!   If possible to expand the code, in my case I have more variables of interest. For example, the 4th line after the line that contains the word "stock" I have its industry:   data have2; input n line $50.; datalines; 30 doidn 31 fifeniofe 32 doewiij 33 fofugrugr 34 text jdjdjf stock IBM 35 djdff 36 25$ 37 fg fgg 38 computers 39 text jdjdjf stock AAA 40 djdff 41 22$ 42 fggh 43 food 44 text jdjdjf stock BBB 45 djdff 46 55$ 47 duehuefhu 48 automotive 49 dfeoufeijer 50 ierhde43848 ; run; Using your code I did the following:   data want2; merge have2 have2(firstobs=3 rename=(line=price)) have2(firstobs=5 rename=(line=industry)); if find(line, "stock")>0 then output; run; And also got the result that I wanted!   I would like to ask for your opinion on the following:   1) In my data I have tens to hundreds of thousands of lines (most of them useless) and 5 to 7 variables that I need to extract, so this would mean merging 5 to 7 times the same data table just like above. Is this a good approach, i.e, could there be efficiency or some other problems (like the computer freezing for example)?   2) Recently I worked on some data where I also had to restructure it into a more analysis-friendly form using Excel VBA. Looking at my data I would perhaps do the following:   Loop through my original data until I find the word "stock". Once I find it, remember the cells row r and paste the cell's content into a new spreadsheet in cell (1,2) (the first column in the new sheet is the stock, second column price etc). In the original sheet the contents of the cell with row = r+2 are the stock's price and so they will be pasted into the new sheet's cell (2,2), and so on for the other variables... And when I reach a new cell with the word "stock" I go to the next line in the new sheet. It seems, at least to me, that using cells is easier conceptually (because I couldn't figure out how to do the above mentioned data restructuring using SAS), so is it possible to "cellulize" data in SAS? Is it even worth it?   Thanks                      ... View more

Hi mkeintz,   since my data is generated externally, lets assume that I already imported data equivalent to: data have; input line $ 1-10; datalines; xxx stock AAA aaa 11$ xxx xxx stock BBBB bbb 22$ run; It is now that I need to do the process described in the question. I tried to guess based on your code by doing the following:   data want; set have; input @ 'stock' stock :$5. // price :$5.; put (_all_) (=); run;   But unsurprisingly it didn't work   ... View more