topic Re: i have 1000 variable i want to keep 500 variable in SAS Programming

i have 1000 variable i want to keep 500 variable

aanan1417 — Mon, 05 Jul 2021 14:22:18 GMT

i have 10000 variable and i want to keep only 500 variable.

without using keep drop

Re: i have 1000 variable i want to keep 500 variable

Reeza — Mon, 05 Jul 2021 15:10:04 GMT

@aanan1417 wrote:

i have 10000 variable and i want to keep only 500 variable.

without using keep drop

WHY?

The only other method I can think of is to explicitly name each of your columns in a SELECT statement in SQL.

proc sql;
create table want as
select name, age 
from sashelp.class;
quit;

If you have naming conventions or patterns you can generate your variable lists dynamically or use variable short cut lists but those cannot be used in SQL.

Here is a reference that illustrates how to refer to variables and datasets in a short cut list:
https://blogs.sas.com/content/iml/2018/05/29/6-easy-ways-to-specify-a-list-of-variables-in-sas.html

Re: i have 1000 variable i want to keep 500 variable

Amir — Mon, 05 Jul 2021 15:55:21 GMT

Hi @aanan1417,

To help you, we will need more information, e.g.:

Are the variables on a SAS data set, or a csv, or some other file?
Where do you want to output the data to, e.g., a csv file?
What code have you tried so far? Please share any error messages and related code from the log.
What is the reason why you cannot use keep or drop?
Do you have any other special requirements?

Edit: If you have a SAS data you could write it out to a file (e.g., proc export) and just read in the information you want from that file, but again the requirement to not use drop or keep, means there is more code (and I/O in this case) than is necessary.

Thanks & kind regards,

Amir.

Re: i have 1000 variable i want to keep 500 variable

ballardw — Wed, 07 Jul 2021 14:21:30 GMT

@Reeza wrote:

@aanan1417 wrote:

i have 10000 variable and i want to keep only 500 variable.

without using keep drop

WHY?

The only other method I can think of is to explicitly name each of your columns in a SELECT statement in SQL.

A real kludgy method is create a separate data set with the desired named variables of the proper types and use Proc Append with Force. Not that I advocate such, but it is a way that meets OP somewhat problematic requirement. Probably way more work than proper variable lists with drop and keep.

@aanan1417 could share a proc contents with Order=Varnum output and indicate which variables he wants.