BookmarkSubscribeRSS Feed
inquistive
Quartz | Level 8

 

...
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.

 

1 REPLY 1
AMSAS
SAS Super FREQ

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?

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 710 views
  • 1 like
  • 2 in conversation