https://communities.sas.com/t5/SAS-Programming/How-to-limit-data-while-uploading-data-for-processing-on-remote/m-p/873937#M345254 <P>There are a number of ways to control what gets uploaded using dataset options for example<BR /><BR /><A href="https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/ledsoptsref/p0h5nwbig8mobbn1u0dwtdo0c0a0.htm" target="_self">OBS= Data Set Option</A><BR /><A href="https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/ledsoptsref/p0ny9o8t8hc5zen1qn3ft9dhtsxx.htm" target="_self">WHERE= Data Set Option</A>&nbsp;<BR /><BR />Although I'm not sure that's the question you are asking. I suspect that you only want to upload observations from the large dataset that match observations (student_id) in the smaller dataset.<BR /><BR />If that's the case then why not do a match-merge and upload the resulting dataset?</P> Thu, 04 May 2023 17:15:27 GMT AMSAS 2023-05-04T17:15:27Z https://communities.sas.com/t5/SAS-Programming/How-to-limit-data-while-uploading-data-for-processing-on-remote/m-p/873910#M345251 <P>&nbsp;</P> <PRE><CODE class=" language-sas">... rsubmit; 1. proc upload data=mylib.student_details out=student_details; 2. proc upload data= student.studentID out=studentID; ...<BR />&lt;data analysis steps&gt; ... endrsubmit;<BR />...</CODE></PRE> <P>Based on above steps, suppose I have only 200 studentID(under mylib.student_details(step#1) in sample code) whereas student.studentID(step#2 in sample code) table has 1 million studentID. Now I want to fetch/upload only 200 studentID (required for the analysis).Is it possible to do so(limit records as per requirement)? If yes, how? Any help would be greatly appreciated. Thanks.</P> <P>&nbsp;</P> Thu, 04 May 2023 17:03:09 GMT https://communities.sas.com/t5/SAS-Programming/How-to-limit-data-while-uploading-data-for-processing-on-remote/m-p/873910#M345251 inquistive 2023-05-04T17:03:09Z https://communities.sas.com/t5/SAS-Programming/How-to-limit-data-while-uploading-data-for-processing-on-remote/m-p/873937#M345254 <P>There are a number of ways to control what gets uploaded using dataset options for example<BR /><BR /><A href="https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/ledsoptsref/p0h5nwbig8mobbn1u0dwtdo0c0a0.htm" target="_self">OBS= Data Set Option</A><BR /><A href="https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/ledsoptsref/p0ny9o8t8hc5zen1qn3ft9dhtsxx.htm" target="_self">WHERE= Data Set Option</A>&nbsp;<BR /><BR />Although I'm not sure that's the question you are asking. I suspect that you only want to upload observations from the large dataset that match observations (student_id) in the smaller dataset.<BR /><BR />If that's the case then why not do a match-merge and upload the resulting dataset?</P> Thu, 04 May 2023 17:15:27 GMT https://communities.sas.com/t5/SAS-Programming/How-to-limit-data-while-uploading-data-for-processing-on-remote/m-p/873937#M345254 AMSAS 2023-05-04T17:15:27Z