topic Re: unstack the count in SAS Programming

unstack the count

pavank — Mon, 08 Jan 2024 06:47:07 GMT

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

Re: unstack the count

yabwon — Mon, 08 Jan 2024 07:08:39 GMT

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

Re: unstack the count

Patrick — Mon, 08 Jan 2024 09:25:29 GMT

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.

Re: unstack the count

Kurt_Bremser — Mon, 08 Jan 2024 09:31:14 GMT

Simple (and correct) answer: Don't.

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