SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

proc transpose - too many id groups

Accepted Solution Solved
Reply
Contributor
Posts: 50
Accepted Solution

proc transpose - too many id groups

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! 


Accepted Solutions
Solution
‎05-18-2016 11:02 AM
Super User
Posts: 9,691

Re: proc transpose - too many id groups

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

 

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

View solution in original post


All Replies
Super Contributor
Posts: 305

Re: proc transpose - too many id groups

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 ?

Super User
Super User
Posts: 7,430

Re: proc transpose - too many id groups

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.

Solution
‎05-18-2016 11:02 AM
Super User
Posts: 9,691

Re: proc transpose - too many id groups

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

 

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 326 views
  • 2 likes
  • 4 in conversation