05-18-2016 01:36 AM
I have some code that is pretty much ideal for how I need to transform my data:
proc summary data=adtr.as5 nway;
idgroup(out (lflag rdflag mflag jflag ap var5 var14 adn nation)=) / autoname;
However, I get:
ERROR: The parameter value 130 is not within the required range of 1 and 100.
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!
05-18-2016 03:29 AM
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 ?
05-18-2016 04:24 AM
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.
Need further help from the community? Please ask a new question.