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

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 660 views
  • 1 like
  • 2 in conversation