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.
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;
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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.