unstack the count

[pavank]

data ds;
input item_name: $ 15. total_count;
datalines;
Water_Bottle  2
Tent   1
Apple 4
;
run;


data split;
set ds;
do split=1 to total_count;
output;
end; drop total_count;
proc print ;
run;

Q)1. How to get split item count using proc sql

[yabwon]

proc sql;
create table spliSQL as
select * from split
;
quit;

😜

... and seriously, sql is not a tool for such job (Maxim 14), data step is.

Bart

[Patrick]

Not possible with standard SQL as implemented in SAS.

Most databases have extensions like T-SQL or PL-SQL that allow for loops. In SAS you've got the data step for this.

[Kurt_Bremser]

Simple (and correct) answer: Don't.

SQL is not the tool for such a task, the DATA step is. Maxim 14 (as already mentioned).