topic Selective Field Output to a permanent table on SAS SERVER in SAS Programming

Selective Field Output to a permanent table on SAS SERVER

deleted_user — Fri, 12 Mar 2010 23:24:31 GMT

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;

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

sbb — Fri, 12 Mar 2010 23:37:21 GMT

You will want to code a KEEP statement for your DATA step.

Scott Barry
SBBWorks, Inc.

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

deleted_user — Sat, 13 Mar 2010 03:12:40 GMT

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

-Scott