The second code works ^O^. Thanks so much.  ... View more

Hi Tom, Yes, I did change the MYTABLE to the really table name. ... View more

Thanks so much. The second code run without error. But the work.copy file has 0 observations. ... View more

I just use the Base SAS ... View more

I just use a lib statement to point to the server. libname CBIT remote "mainframe_file_name" disp=shr server=server_name; ... View more

Hi Tom, I need to get the data source form Mainframe. I have assign a libname to the mainframe server. Then I run a simple data step to transfer the data into my local PC, then work on it. The variable "Status" has the length of 2 (numeric). There is the error msg: data sample; length status 8.; SET CBIT.DATA ; run; ERROR: One or more numeric variables could not be converted to the target representation because they are shorter than the target representation allows. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.SAMPLE may be incomplete. When this step was stopped there were 0 observations and 7 variables. WARNING: Data set WORK.SAMPLE was not replaced because this step was stopped.   ... View more

Thanks so much. It works perfectly.  ... View more

Thanks so much. It works perfectly. ... View more

Thank you for the reply. The situation is that I need to randomly select 50 observations for my dataset. And there are three groups in the  dataset, I need at least 8 observation from each group. I am thinking to use proc surveyselect to select my sample. So I need "three random number between 8 and 50, and must adding up to 50" using as sampsize. ... View more