topic Re: Reshape data in SAS Programming

Reshape data

rohitkrishna — Tue, 27 Aug 2019 11:37:35 GMT

Hi All,

I have data issue while making reshape of the below data, kindly someone help me out for this scenario

{

data _nu;

infile datalines;

input num1

datalines;

1 2 3 4 5 ;

run;

my expecting results should be

num1

I want to reshape horizontal to vertical

Thanks & regards

Rohit

Re: Reshape data

PeterClemmensen — Tue, 27 Aug 2019 11:44:39 GMT

data wide;
input num1-num5;
datalines;
1 2 3 4 5
;

proc transpose data=wide out=long(rename=COL1=num drop=_NAME_);
run;

Re: Reshape data

Kurt_Bremser — Tue, 27 Aug 2019 11:45:33 GMT

Please supply a WORKING step with datalines.

Is num1 thought to be a string with all the digits, or do you rather have 5 numerical values in one observation?

Or do you want to read a text file that has all the numbers on one line?

That would be very easy with a "double hold":

data _nu;
infile datalines;
input num1 @@;
datalines;
1 2 3 4 5
;
run;

Re: Reshape data

novinosrin — Tue, 27 Aug 2019 12:01:02 GMT

Adding some fun

data _nu;
infile datalines;
array num(5);
input num(*);
do _n_= 1 to 5;
 numbers=num(_n_);
 output;
end;
keep numbers;
datalines;
1 2 3 4 5 
;
run;

Re: Reshape data

rohitkrishna — Tue, 27 Aug 2019 12:56:22 GMT

HI KurtBremser, novinosrin
Thanks for the quick replay
I just asked for example how it works for reshaping horizontal to vertical for my existing SAS code so kindly share the solution for real sas code
{
data _null_;
infile ssassdt missover;
INPUT @17 Inamlin1 $Char28.
@45 Inamlin2 $Char28.
@79 Idtype $Char7. @@;

PUT @17 Inamlin1 $Char28.
@45 Inamlin2 $Char28.
@79 Idtype $Char7. ;
return;}
but it going in loop while removing the missover
if missover is there it throughs error code 8.
kindly give some suggestion for this problem
Thanks & regards;
rohit

Re: Reshape data

novinosrin — Tue, 27 Aug 2019 13:01:47 GMT

Hi @rohitkrishna Can you post a sample of the data you have and your expected output that you want plz? Makes it easier to code it for you

Re: Reshape data

rohitkrishna — Tue, 27 Aug 2019 13:08:29 GMT

Hi novinosrin
Thanks for the response
please find below mention data
{
R M********N T**B
D N******E T**B
L H**********N T**B
R S***********N T**B
K *******L T**B
Thanks & regards
rohit

Re: Reshape data

novinosrin — Tue, 27 Aug 2019 13:09:31 GMT

Okay and what is the output you want from that?

Re: Reshape data

rohitkrishna — Tue, 27 Aug 2019 13:12:07 GMT

Ya novinosrin,
i want the rec into vertical
like
R M********N
T**B
like above one after another
Thanks & regards
rohit

Re: Reshape data

Kurt_Bremser — Tue, 27 Aug 2019 13:17:16 GMT

So you have three strings in one input line, and you want the third string to go into a new observation?

@rohitkrishna wrote:
Hi novinosrin
Thanks for the response
please find below mention data
{
R M********N T**B
D N******E T**B
L H**********N T**B
R S***********N T**B
K *******L T**B
Thanks & regards
rohit

Re: Reshape data

rohitkrishna — Tue, 27 Aug 2019 13:20:22 GMT

Hi KurtBremser,
ya i have three fields in one line and i want it to be one after the other like Horizontal to vertical
Thanks & regards
Rohit

Re: Reshape data

Kurt_Bremser — Tue, 27 Aug 2019 13:26:18 GMT

But your previous post showed two strings in the first observation:

@rohitkrishna wrote:
Ya novinosrin,
i want the rec into vertical
like
R M********N
T**B
like above one after another
Thanks & regards
rohit

Re: Reshape data

rohitkrishna — Tue, 27 Aug 2019 13:41:21 GMT

Hi
try to provide some solution for the above issue
Thanks & regards
Rohit

Re: Reshape data

Kurt_Bremser — Tue, 27 Aug 2019 13:42:31 GMT

@rohitkrishna wrote:
Hi
try to provide some solution for the above issue
Thanks & regards
Rohit

Since your rule does not match your expected output, I can't do that.

Re: Reshape data

rohitkrishna — Tue, 27 Aug 2019 13:50:56 GMT

Hi KurtBremser,
ya sorry for the trouble i will explain in a simpley way
please find below the code
{
data _null_;
infile insfdt missover;
put @1 name $char26.
@28 sex $char1.
@30 surname @char28. @;
return;
put @1 name $char26.
@28 sex $char1.
@30 surname @char28.;
run;
and the output looks
("carline f karei") that is the output in a single line
but my req is
{ carline
f
karei}
like above one
Thanks & regards
Rohit

Re: Reshape data

Kurt_Bremser — Tue, 27 Aug 2019 13:56:18 GMT

Easy with a character array:

data want;
set have;
array vars {*} _character_;
length var $30; /* make sufficient */
do i = 1 to dim(vars);
  var = vars{i};
  output;
end;
keep var;
run;

Re: Reshape data

rohitkrishna — Tue, 27 Aug 2019 14:43:42 GMT

Hi KurtBremser
Thanks for the replay
i think it will work thanks very much for the help
thanks & regards
Rohit

Re: Reshape data

Reeza — Tue, 27 Aug 2019 15:58:31 GMT

Please mark the relevant answer as the solution.