DATA Step, Macro, Functions and more

Selective Field Output to a permanent table on SAS SERVER

Reply
N/A
Posts: 0

Selective Field Output to a permanent table on SAS SERVER

Hello,
Real simple question (Hopefully). In this simple script below, How do I choose which columns I want as the ouput to the data table "Scott_OUT"? For example ,say Scott_out has 3 columns, Name, address, and phone. What code do I use to post only 2 columns, say Name and Address, to the scott_out permanent data set?

LIBNAME Scott '/sas/userdata/Scott_Test';
data Scott_out;
set Scott.test;
run;
Super Contributor
Super Contributor
Posts: 3,174

Re: Selective Field Output to a permanent table on SAS SERVER

Posted in reply to deleted_user
You will want to code a KEEP statement for your DATA step.

Scott Barry
SBBWorks, Inc.
N/A
Posts: 0

Re: Selective Field Output to a permanent table on SAS SERVER

Awesome, just what I was looking for. Thank you very much!

-Scott
Ask a Question
Discussion stats
  • 2 replies
  • 108 views
  • 0 likes
  • 2 in conversation