...
rsubmit;
1. proc upload data=mylib.student_details out=student_details;
2. proc upload data= student.studentID out=studentID;
...
<data analysis steps>
...
endrsubmit;
...
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.
There are a number of ways to control what gets uploaded using dataset options for example
OBS= Data Set Option
WHERE= Data Set Option
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.
If that's the case then why not do a match-merge and upload the resulting dataset?
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.