topic Re: Assigning Value to the bulk data as per percentage in SAS Enterprise Guide

Assigning Value to the bulk data as per percentage

pooja0108 — Thu, 15 Oct 2020 18:11:25 GMT

I am working on data with 10000 unique accounts. I have to assign these accounts as per percentage. Like 40% of count of accounts gets value 'ABC' ,30% of count of accounts get 'DEF' and remaining 30% gets 'XYZ'
for instance : 40% of 10000= 4000 accounts get value ABC
30% of 10000=3000 accounts get DEF
30% of 10000=3000 accounts get XYZ

Please write a code for this query.

Re: Assigning Value to the bulk data as per percentage

PaigeMiller — Thu, 15 Oct 2020 18:26:22 GMT

Assign at random, or otherwise? Explain further.

Re: Assigning Value to the bulk data as per percentage

Reeza — Thu, 15 Oct 2020 18:33:02 GMT

Look up RAND() function with the table option.
https://blogs.sas.com/content/iml/2011/07/13/simulate-categorical-data-in-sas.html

Re: Assigning Value to the bulk data as per percentage

pooja0108 — Thu, 15 Oct 2020 18:34:37 GMT

Randomly assign values ABC, DEF , XYZ as per given ratio on total count of cases