...
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?
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.