topic how to write vertical values in SAS Programming

how to write vertical values

sas_university — Tue, 27 Sep 2022 06:26:00 GMT

data ds;

infile datalines;

input id team$ loc$;

datalines;

10 red nlr

11 green tpt

12 tellow klr

;

run;

data ds1;

set ds;

if team='red' then members=' ravi, sekhar,pawan';

run;

output required ;

ravi

sekhar

pawan

i want vertical data expected output anyone can help me

output :

ravi, sekhar,pawan

anyone can help me

Re: how to write vertical values

PeterClemmensen — Tue, 27 Sep 2022 06:40:45 GMT

By 'vertical', do you mean that you want 1 obs per name if team = 'Red'?

Re: how to write vertical values

ballardw — Tue, 27 Sep 2022 06:43:45 GMT

Output where? An external text file? An ODS destination? The Log? A data set with each value a separate observation?

This will print one word for each value of Members to the default output destination window.

data ds;
infile datalines;
file print;
input id  team$ loc$;
if  team='red' then members=' ravi, sekhar,pawan';
do i=1 to countw(members);
   word = scan(members,i);
   put word;
end;
datalines;
10 red  nlr
11 green tpt
12 tellow klr
;

Re: how to write vertical values

Vivi1997 — Tue, 27 Sep 2022 07:00:05 GMT

data ds (drop=members i);
infile datalines;
file print;
input id  team$ loc$;
members=' ravi, sekhar,pawan';
do i=1 to countw(members);
   if team = 'red' then member = scan(members,i);
   output;
end;
datalines;
10 red  nlr
11 green tpt
12 tellow klr
;

You can simply run a do loop for all the members and check for team red then output the appropriate member at the end of each iteration. However this will create 3 rows for each team since 3 members are specified at the beginning. Hope this helps!

Output:

Re: how to write vertical values

sas_university — Fri, 14 Oct 2022 09:52:44 GMT

Hi sir..

example :

if team=red then name=ravi, venu ,sai

when i am convert excel file in column output be like :

name

ravi

venu

sai

help me

Re: how to write vertical values

Kurt_Bremser — Fri, 14 Oct 2022 10:42:27 GMT

data want;
set have (rename=(name=_name));
do i = 1 to countw(_name,",");
  name = scan(_name,i,",");
  output;
end;
drop i _name;
run;

Untested for lack of usable example data.