format - how could I handle an iterative naming system for this? -

-

i have dataset of kind, dataset contains missing values (i'm representing them x).

id  va  vb  ... vn      |       id  va  vb  ... vn  |    1   a1  b1  ... n1      |       1   a1  x   ... n1  | 2   a2  b2  ... n2      |===    2   x   b2  ... x   | 3   a3  b3  ... n3      |===    3   a3  b3  ... n3  | ..................      |       ..................  | n    bn  ... nn      |       n   x   bn  ... nn  |

i want add observations id using 1 variable column, call variable var: inverted proc format id; var var;.

id  var 1   a1 .. 1   n1  2   b2 .. 3   a3 3   b3 .. 3   n3 .. n   bn ..   n   nn

so tried split olddataset in different datasets (newa newb ...newn) where, in each dataset have not-missing observations stored in column called var. merge newa newb ... newn in newdataset , apply proc sort restoring order id.

the problem arised when realized "n" not known prior analysis 'cause want setup generalized code won't work 1 dataset, , va vb vn result of proc format step.

if n knows use this:

data newa newb newc; set olddataset; array try[3] va vb vc ; if try[1] ne '.' output newa; if try[1] ne '.' output newb; if try[1] ne '.' output newc; run;

but need iterative naming system maybe sounds like:

data new_i;                     <-------- "i" must assigned set olddataset; array try[*] v: ; i=1 dim(try); if try[i] ne '.' output new_i; <---- "i" must assigned run;

hope sounds clear. hints? thanks.

try proc transpose instead, can delete missing in second step or add clause out data set. if want create subsets after based on id separate them out in data step. 

*generate sample data; data have; array v(20) v1-v20; id=1 10;     i=1 20;     v(i)=rand('normal', 0, 1);     if v(i) < -2 v(i)=.;     end;     output; end; drop i; run;  *flip data; proc transpose data=have out=want(where=(var1 ne .)) prefix=var;     id; run;  *separate different data sets; data _null_;     set want;     id;     call execute(catt("data var", id, "; set want; id=", id, ";run;")); run;

Comments

Post a Comment

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,...
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11...
Read more

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -

-
any ideas when firefox implement lengthadjust andtextlength?..... working svg application. lengthadjust , textlength working fine in chrome not working in fire fox . <svg viewbox = "0 0 500 300" version = "1.1"> <defs> <path id="s3" d="m 10,90 q 100,15 200,70" /> </defs> <g> <text font-size = "20"> <textpath xlink:href="#s3" textlength="205"> short text</textpath> </text> <use xlink:href="#s3" fill="none" stroke="black" stroke-width="1"/> </g> </svg> this implemented in firefox text elements (not textpath or tspan) in case that's ok though can move attribute text element. <svg viewbox = "0 0 500 300" version = "1.1"> <defs> ...
Read more