topic Re: Renaming a column after importing data from csv in SAS Programming

Renaming a column after importing data from csv

byeh2017 — Thu, 16 Feb 2017 12:40:22 GMT

Hi Everyone,

Very new to sas. I just imported a csv file and was wondering how I can rename a column. Thanks for your help. This was my code:

data pracitce.new1 (rename=(nationalid=nid));
set practice.new
run;

proc print data= practice.new1;
run;

The imported file is now under practice.new. Is there a way to just modify the column on the parent file without creating a new file? I got this error:

98 data pracitce.new1 (rename=(nationalid=nid));
ERROR: Libref PRACITCE is not assigned.
99 set practice.new
100 run;
ERROR: File WORK.RUN.DATA does not exist.
101

NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

102 proc print data= practice.new1;
103 run;

NOTE: No observations in data set PRACTICE.NEW1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Re: Renaming a column after importing data from csv

PeterClemmensen — Thu, 16 Feb 2017 12:44:51 GMT

You did not assign your libref PRACITCE right 🙂

Your rename statement looks right if you want to use the variable name nid in your data step.

If you want to use the variable name nationalid and then rename the variable in your output data set simply do

data pracitce.new1;
set practice.new

rename nationalid=nid
run;

Re: Renaming a column after importing data from csv

byeh2017 — Thu, 16 Feb 2017 12:49:07 GMT

Thank you. How do I correctly assign the practice folder as my library? I thought I did that already before when I created the library folder... thanks again.

Re: Renaming a column after importing data from csv

PeterClemmensen — Thu, 16 Feb 2017 12:51:46 GMT

Like this 🙂

%let path = insertyourpathhere; 
libname practice "&path";

Re: Renaming a column after importing data from csv

mkeintz — Thu, 16 Feb 2017 12:53:01 GMT

As to your question - yes you can rename a variable in a dataset without making a new dataset ... using PROC DATASETS:

proc datasets libname=practice; /*or pracitce if that is correct spelling*/

modify new;

rename nationalid=nid;

run;

quit;

Re: Renaming a column after importing data from csv

Reeza — Thu, 16 Feb 2017 14:23:40 GMT

Looks like a typo?

Practice vs pracitce

Re: Renaming a column after importing data from csv

byeh2017 — Fri, 17 Feb 2017 07:53:15 GMT

Yes, it was a typo! Thank you everyone.