topic Re: sas programming in SAS Programming

sas programming

pawandh — Sat, 16 Jan 2016 03:44:17 GMT

data t;
input sno category$ 20.;
cards;
1 dairy floor eggs
2 floor milk
3 eggs bread
4 bread butter butter
;run;

i have this data set and i want distinct category (dairy,floor,eggs,milk,bread,butter).

I can do like this

data t1;
set t;
do i=1 to 3;
x=scan(category,i);
output;
end;
run;
proc print;run;

but here i dnt knw how many times i have to run the loop like 3 or 4 or 5 times.Any optimum way?

Re: sas programming

Reeza — Sat, 16 Jan 2016 03:57:31 GMT

Countw() will count number of words in a variable. Use that to create a variable that holds the number of iterations and use it in your do loop.

Re: sas programming

stat_sas — Sat, 16 Jan 2016 03:57:54 GMT

data t1;

set t;
do i=1 to countw(category);
x=scan(category,i);
output;
end;
run;

Re: sas programming

PGStats — Sat, 16 Jan 2016 04:01:26 GMT

Read the categories one by one until the end of each line:

data t;
infile datalines truncover;
input sno category :$20. @;
do until(missing(category));
    output;
    input category :$20. @;
    end;
datalines;
1 dairy floor eggs
2 floor milk
3 eggs bread
4 bread butter butter
;