topic Re: please help in SAS Programming

How to change variable names

wagdy — Thu, 22 Nov 2018 14:36:58 GMT

how to change variable name from q1a to q1 without affeting my data

Re: please help

Astounding — Tue, 20 Nov 2018 22:23:59 GMT

It's easy, but you left out too much information.

What is the name of your data set?

Should this be a permanent change, or just a temporary change for one DATA or PROC step?

Re: please help

wagdy — Wed, 21 Nov 2018 21:28:26 GMT

hi,

I have excel file & would like to make it SAS file.

I go to SAS then import the file. it forces me to save it as work file. but I can't open it after.

I am used to xxx.file name. How to do this? thanks in advance

Re: please help

Astounding — Wed, 21 Nov 2018 21:37:33 GMT

This has absolutely nothing to do with your original question.

Is your first question already answered?

You still need to provide details. How are you trying to import the file? Is there a log?

Re: please help

wagdy — Wed, 21 Nov 2018 22:00:58 GMT

1. re 1st question: sorry. the 1st question has not been answered. you asked me to send more info. & I did via email last night.

2. re second question: I highlight the excel file & after saving it as exclpdf. I go to sas & try to import it. the problem is I can not save it as XXX.FILENAME.

please excuse my ignorance with SAS I used it while doing my master & PH.D more that 30 years ago. I am trying to help some one else using my data/. appreciate your help.

Re: please help

andreas_lds — Thu, 22 Nov 2018 08:08:08 GMT

@wagdy wrote:

how to change variable name from q1a to q1 without affeting my data

Use proc datasets or proc sql with alter table.

Re: please help

wagdy — Thu, 22 Nov 2018 12:44:42 GMT

Thanks. What would be the command I use?

Re: please help

PaigeMiller — Thu, 22 Nov 2018 12:49:00 GMT

@wagdy, please update the title of this thread to something meaningful.

Re: please help

wagdy — Thu, 22 Nov 2018 12:51:42 GMT

Thanks. Not sure what you mean

Re: please help

PaigeMiller — Thu, 22 Nov 2018 12:54:56 GMT

Surely you understand that a title of "Please Help" is not meaningful, that a title that actually describes the problem would be more meaningful. Click on the Gear icon next to your original post, select Edit Message, and then provide a meaningful title that actually (and succinctly) describes the problem.

changing variable

wagdy — Thu, 22 Nov 2018 14:23:18 GMT

thanks for your response.

my question is: how to change variable name from q1a to q1 without affeting my data. regards

Re: changing variable

PaigeMiller — Thu, 22 Nov 2018 14:24:42 GMT

You need to change the title on your ORIGINAL post in this thread to something meaningful.

Re: changing variable

wagdy — Thu, 22 Nov 2018 14:39:42 GMT

Thanks. I just did.

Changing Variable Name

PaigeMiller — Thu, 22 Nov 2018 14:56:04 GMT

@andreas_lds wrote:

@wagdy wrote:

how to change variable name from q1a to q1 without affeting my data

Use proc datasets or proc sql with alter table.

proc datasets library=work nolist;
    modify datasetname;
    rename q1a=q1;
run; quit;

If your dataset is in some other library than WORK, then use the library name instead of WORK. Also, you have to use your actual data set name instead of where I used datasetname.

Re: Changing Variable Name

wagdy — Thu, 22 Nov 2018 23:14:33 GMT

many thanks for your help. The problem is solved

Re: Changing Variable Name

PaigeMiller — Fri, 23 Nov 2018 13:09:47 GMT

@wagdy

You can't mark your own comment as correct in this case. You need to un-mark it as correct and then mark the answer that solved your problem as the correct answer.