dataset - SAS transpose using a part of the name -

-

i'm here asking for problem proc transpose.

i have dataset made way (i'm going show 3 variables have lots of them)

pr  id  var1a   var1b   var1c   var2a   var2b   var2c   var3a   var3b var3c  1   1   x       x       x       x       x       x       x       x     x 1   2   x       x       x       x       x       x       x       x     x 1   3   x       x       x       x       x       x       x       x     x 2   1   x       x       x       x       x       x       x       x     x 2   2   x       x       x       x       x       x       x       x     x 2   3   x       x       x       x       x       x       x       x     x

i need output dataset this:

preid   id  var(name)     b   c 1       1   var1(name)  x   x   x 1       1   var2(name)  x   x   x 1       1   var3(name)  x   x   x 1       2   var1(name)  x   x   x 1       2   var2(name)  x   x   x 1       2   var3(name)  x   x   x 1       3   var1(name)  x   x   x 1       3   var2(name)  x   x   x 1       3   var3(name)  x   x   x

etc preid 2 id 1 2 3, preid 3 id 1 2 3.

so need transpose using name (discriminating b c), have no idea start. can me please?

similar @sushil solution above, 1 less step. since have go data step anyways, may transpose data in step well. in solution proc transpose/data step combined. if had few enough variables i'd remove last transpose well, more flexible if have quite few variables. 

data input; infile datalines dsd dlm=',' missover; input pr    :$8.        id    :$8.         var1a :$8.         var1b :$8.         var1c :$8.          var2a :$8.         var2b :$8.         var2c :$8.         var3a :$8.         var3b :$8.        var3c :$8.; datalines4; 1,1,x,x,x,x,x,x,x,x,x 1,2,x,x,x,x,x,x,x,x,x 1,3,x,x,x,x,x,x,x,x,x 2,1,x,x,x,x,x,x,x,x,x 2,2,x,x,x,x,x,x,x,x,x 2,3,x,x,x,x,x,x,x,x,x ;;;; run;  data out1; set input; array vars(*) var1a--var3c; i=1 dim(vars); name=vname(vars(i)); varname=substr(name,1,length(name)-1); group=substr(name,length(name)); value=vars(i); output; end;  drop var1a--var3c; run;  proc transpose data=out1 out=out2; pr id varname; id group; var value; run;

Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

gradle error "Cannot convert the provided notation to a File or URI" -

-
i have defined 2 system properties in gradle.properties: systemprop.builddir=build systemprop.cfgdir=build\\cfg and have following task defined in build.gradle: task clean(group:'clean',description:'clean project') << { ant.sequential { delete(dir: system.properties.builddir) mkdir(dir: system.properties.builddir) delete(dir: system.properties.cfgdir) mkdir(dir: system.properties.cfgdir) } } this generates following error: execution failed task ':clean'. > cannot convert provided notation file or uri: {dir=build}. following types/formats supported: - string or charsequence path, e.g 'src/main/java' or '/usr/include' - string or charsequence uri, e.g 'file:/usr/include' - file instance. - uri or url instance. but equivalent block of code not generate error , works expected: task clean(group:'clean',description:'clean project') << { ...
Read more

python - NameError: name 'subprocess' is not defined -

-
i'm trying make rng website: http://jamesdotcom.com/?p=417 . when run following code: captureimage = subprocess.popen( [ "fswebcam", "-r", "356x292", "-d", "/dev/video0", "static.jpg", "--skip", "10" ], stdout=devnull, stderr=devnull) captureimage.communicate() i following error message: nameerror: name 'subprocess' not defined what should do? thanks have imported first? import subprocess captureimage = subprocess.popen(["fswebcam", ...) subprocess included in python standard library since python 2.4. should not necessary install it.
Read more