topic Re: Proc transpose query in SAS Programming

Proc transpose query

scb — Thu, 08 Feb 2018 07:58:47 GMT

data sensitive;
input type1 $ type2 $ var1 $ var2 $ var3 $ var4 $;
cards;
t1 ta custid custname m mobile
;

With the dataset above, how can I transpose var1,var2,var3,and var4 only? The desired dataset should look like:

Var_need

custid

custname

mobile

Is it possible? Anyone can help? Thanks.

Re: Proc transpose query

andreas_lds — Thu, 08 Feb 2018 08:05:40 GMT

Using a loop and the output-statement:

data work.want;
   set work.sensitive;
   length Var_Need $ 8; /* important: must be equal to max vlength of var1-var4 */
   array vars var1-var4;
   
   do i = 1 to dim(vars);
      Var_Need = vars[i];
      output;
   end;

   keep Var_Need;
run;

Re: Proc transpose query

RW9 — Thu, 08 Feb 2018 09:05:41 GMT

This is not complicated, what have you tried? Have you for instance tried the tranpose procedure, which you may find useful in this case:

data sensitive;
  input type1 $ type2 $ var1 $ var2 $ var3 $ var4 $;
cards;
t1 ta custid custname m mobile
;
run;

proc transpose data=sensitive out=want;
  by type1 type2;
  var var:;
run;

Re: Proc transpose query

ShiroAmada — Fri, 09 Feb 2018 09:39:12 GMT

Try this...

proc transpose data=HAVE out=WANT;
  var VAR: ;
run;

Hope this helps.

Re: Proc transpose query

soham_sas — Fri, 09 Feb 2018 11:56:23 GMT

@scb you can do it like below

data sensitive;
input type1 $ type2 $ var1 $ var2 $ var3 $ var4 $;
cards;
t1 ta custid custname m mobile
;
run;

proc transpose data=sensitive out=want(drop=_name_ rename=(col1=var_need));
var var1-var4;
run;