SAS Gurus,              Could you please help me to populate an empty dataset with random data for example:   data class;          set sashelp.class (obs=0); run;   Since I have empty dataset class, how to populate this dataset with 1000 random observations. Please don't recommend proc iml; (it doesn't work for me and I don't want to download the university edition of SAS)?    Thanks a lot in advance. ... View more

SAS gurus,                 I am trying to find accountno in a library with multiple datasets. I am unable to accomplish the task and I have put the code I used to build the logic.  Can someone please show me the direction? 1. i am getting all the accountno total in a macro as well accountno 2. get all the datasets I need to look into using dictionary.columns 3. use a macro to list individual dataset which contains either one or more accountno in them. If possible need to get all the accountno information (possibly using proc sql; select option instead of data _null_ in my code). I would like ideally to have the information of the dataset and all the observations pertaining to that accountno. I am failing in my third step. please help?   thanks,     /*get the total number of accounts from kumngo and save them in a macro accountno*/ proc sql; select count(distinct(accountno)) into :tot from kumngo; select distinct "'"||strip(accountno)|| "'" into :accountno          seperated by "," from kumngo; quit; /*Get all the the dataset names from datasets using dicitionary.columns*/ PROC SQL NOPRINT; SELECT DISTINCT(MEMNAME), COUNT(DISTINCT(MEMNAME)) INTO :ds_list SEPARATED BY '~', :ds_cnt FROM dictionary.columns WHERE LIBNAME = 'DATASETS' ORDER BY MEMNAME; create table datasets as select distinct (memname) from dictionary.tables where libname = 'DATASETS' QUIT; /*search individual dataset to find the accountno and list that dataset*/ %macro check; %if &sqlobs ne 0 %then %do; %DO I = 1 %TO &DS_CNT; %LET DS = %SCAN (&DS_LIST., &I., ~); data _null_; set datasets.&DS. ; if accountno in (&accountno) then put" accountnos are in &DS."; run; %end; %end; %mend; %check ; ... View more

Could anyone give an idea how to give a single condition for a library which has same dataset names suffix or prefixes. Like library (dsn) with names like dataone_05apr2015 , dataone_16jun2014 , dataone_09nov2017    or like 251_datatwo , 158_datatwo , 986_datathree .    How can we give in dictionary.tables or dictionary.columns etc?   thanks,   ... View more