topic Re: Query on auto generation of variable and data in SAS Programming

Query on auto generation of variable and data

Lidia1 — Thu, 05 Nov 2020 07:56:06 GMT

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.

Re: Query on auto generation of variable and data

Shmuel — Thu, 05 Nov 2020 10:32:15 GMT

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;