Hello. My data-set has more than 1 million observations and I would like to export it as excel file. However, the number of observation has beyond the maximum rows for excel. I think I should split t...
I have a dataset and I need to split this dataset based on a variable (say deptid) in it . The number of splits depends on the number of distinct departments.The name of the output dataset comes f...
Hi All, I'm trying to splitdataset using product id , but seems it's not working. Can someone have a look and correct me please? data sample; input custid prdid prdname $30.; c...
Hi all, Below is the original dataset that I want to split it into 3 different datasets as pass, open, and exception. Could someone kindly show me how to go about doing this? Any help is g...
...00 400
three 500 200
three 200 100
two 400 200
two 300 166
one 300 100
three 400 400
; Now, what if I want to dynamically split up this dataset into three datasets called one two and three? And I w...
...n WRDS cloud server, which is presumably much faster than my local machine, splitting the dataset is mandatory to do any kind of analysis. I am planning to split the dataset in 40 smaller dataset...
Hi All, Please help me to split the dataset efficiently (preferably hash). Since the data set TEST has duplicates, getting error while splitting using hash.. All i wanted is not to split by record c...
Hello Experts,
I need to split my larger data set. I know how many datasets i want from the larger data set.
I want to split my larger data set into 3 data set with equal c...
Hi Good Evening suppose i have huge data in a single dataset so i want to split that data into multiple datasets following first dataset 20% second dataset 50% third dataset 30% a...
I have a SAS dataset with 3000 variables that I need to split into 3 datasets with 10000 variables each. I need each dataset to have the studyid in the dataset so they can remerged later. Is there a...
