Dear SAS Community, I am a new user in SAS and I have encountered an issue while working on large data set. Let me introduce the data-table I am working with. My table has millions of rows and it is unique at ID+Month level. The Month variable runs from 1 to 100. Then I have series of column named like var1, var2, var3.....var100. And these columns only contain two values; a blank or "Y". I leave a snapshot of the table below. ID Month Var1 Var2 …. …. Var100 ABC1 1 Y Y ABC2 1 ABC3 1 Y ABC4 1 Y ABC5 1 Y Y ABC1 2 Y Y Y ABC2 2 Y ABC3 2 ABC4 2 Y ABC5 2 ABC1 … Y Y ABC2 … Y Y ABC3 … ABC4 … Y ABC5 … Y ABC1 100 Y Y ABC2 100 Y ABC3 100 ABC4 100 Y Y ABC5 100 Y Y Y Using the table I want to create an output which has only unique IDs and columns as Month1, Month2, Month3, ..., Month100. In the columns Month1, Month2, ...., Month100, I want to have only two values as a blank or "Y" based on combination of a specific month and varx. For example, for Month = 1 and Var1, only ID ABC3 has Var1 = "Y" hence in my output table, Month1 value against ID ABC3 has the same value "Y". ID Month1 Month2 …. …. Month100 ABC1 Y Y ABC2 Y Y ABC3 Y ABC4 ABC5 Y Hope the long explanation helps.
... View more