topic Re: sas in SAS Programming

sas

kranthikumari — Sun, 12 Jan 2020 14:49:17 GMT

Hi All,

i have exported the cars from sashelp. for my sas programming practice, again i am trying to import with rename option, but the data set variable names are not changing

proc import datafile="d:\IQ\cars_1.xls"

out=ds3 (rename=(MSRP=msrp_1))
dbms=excel replace;
run;

Re: sas

slathiya444 — Sun, 12 Jan 2020 14:52:05 GMT

I think the problem is in DBMS field.

Re: sas

Kalind_Patel — Sun, 12 Jan 2020 16:21:29 GMT

Have you checked the column properties?
You might be seeing MSRP as label but actually it was changed to msrp_1.

For me this code worked:

proc export data=sashelp.cars
outfile="d:\cars_1.xls" dbms=xlsx replace;
run;

proc import datafile="d:\cars_1.xls"
out=ds3 (rename=(MSRP=msrp_1))
dbms=xlsx replace;
run;

Re: sas

Kalind_Patel — Sun, 12 Jan 2020 16:24:44 GMT

You can see column properties by double clicking on column:

EXPORT/IMPORT problems

PaigeMiller — Sun, 12 Jan 2020 19:49:26 GMT

@kranthikumari wrote:

Hi All,

i have exported the cars from sashelp.

Show us the code that did this export.

Also, since we are trying to help you, please help us by going back and edit your original post and provide a meaningful title. A title of "SAS" is not meaningful, every question is about SAS.

Re: sas

Kurt_Bremser — Sun, 12 Jan 2020 22:24:46 GMT

If "sas" is all you can come up with as a descriptive subject line, your future with SAS looks very bleak. Working with complex software requires effort on your part.