topic proc transpose - too many id groups in SAS Data Management

proc transpose - too many id groups

r4321 — Wed, 18 May 2016 05:36:24 GMT

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!

Re: proc transpose - too many id groups

Loko — Wed, 18 May 2016 07:29:50 GMT

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 ?

Re: proc transpose - too many id groups

RW9 — Wed, 18 May 2016 08:24:30 GMT

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.

Re: proc transpose - too many id groups

Ksharp — Wed, 18 May 2016 09:06:15 GMT

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

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