proc transpose - too many id groups

[r4321]

Hello everyone, 

I have some code that is pretty much ideal for how I need to transform my data: 

proc summary data=adtr.as5 nway;
class year_id;
output out=adtr.as6
idgroup(out[130] (lflag rdflag mflag jflag ap var5 var14 adn nation)=) / autoname;
run;

However, I get: 

ERROR: The parameter value 130 is not within the required range of 1 and 100.
1900 run;

I don't know how else to do this...and...I need to have the 130 id groups. If you could help me with this code or show me another way, that would be great. Bear in mind that I am by no means an advanced programmer, still pretty novice, so please don't take it too far over my head. 

Thanks for your help in advance! 

[Loko]

hello,

proc means specifications state that for out[n] - [n] is an integer between 1 and 100.

anyway the question is why you need something that will create 100 variables for each of

lflag rdflag mflag jflag ap var5 var14 adn nation variables ?

[RW9]

Totally agree with @Loko here, 130 * 9 = 1170 variables.  That is not the way forward regardless of any requirement.  

Alos, post example test data (in the form of a datastep) and what the output should look like if you need code.  But the question really is why you would need all those columns, as its really not going to work.

[Ksharp · Accepted solution]

Here is an alternative way(MERGE Skill) proposed by me, Arthur.T, Matt.

http://support.sas.com/resources/papers/proceedings15/2785-2015.pdf