🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 11-05-2020 02:54 AM
(589 views)
I want to generate a list with 4 variable like - name,age,sex,roll and want to populate data .
But for doing that I cant use any raw data file. I have to use some auto generating functions here I guess.
The variable will be generated automatically and data will be populated automatically. I can only define starting value for each variable and the number of observation I want.
Kindly help me with such query.
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Check the next code:
%let rows = 100;
/* pfx stands for prefix */
%let pxfName = name;
/* numeric values can be computed randomly in a given range
using any randomizing function - like ranuni */
data want;
length name $20;
do i=1 to &rows;
name ="&name" || put(i,5.);
age = int(ranuni(-1) * 100) + 8; /* any age 8 and above up to 108 */
if mod(_N_,2) < 1 then sex = 'M'; else sex ='F';
/* add any algorithm to compute roll randomly */
OUTPUT;
end;
run;
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Check the next code:
%let rows = 100;
/* pfx stands for prefix */
%let pxfName = name;
/* numeric values can be computed randomly in a given range
using any randomizing function - like ranuni */
data want;
length name $20;
do i=1 to &rows;
name ="&name" || put(i,5.);
age = int(ranuni(-1) * 100) + 8; /* any age 8 and above up to 108 */
if mod(_N_,2) < 1 then sex = 'M'; else sex ='F';
/* add any algorithm to compute roll randomly */
OUTPUT;
end;
run;