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?

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

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!

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