topic Is there a way to add an extra variable column while importing a data? in SAS Programming

Is there a way to add an extra variable column while importing a data?

mssh2712 — Wed, 14 Dec 2016 13:02:37 GMT

I have a dataset of 5 variables (Name,Age,Gender,Recepie and status).

I want to add a new variable(country) which will have "India" as a value thru out all the rows.

Name Age Gender Recepie status Country

vinu 56 F Tandoor complete Canada

please reply.

Re: Is there a way to add an extra variable column while importing a data?

mssh2712 — Wed, 14 Dec 2016 13:04:29 GMT

Hi please ignore the previous message.

I have a dataset of 5 variables (Name,Age,Gender,Recepie and status).

I want to add a new variable(country) which will have "Canada" as a value thru out all the rows.

Name Age Gender Recepie status Country

vinu 56 F Tandoor complete Canada

Re: Is there a way to add an extra variable column while importing a data?

Jagadishkatam — Wed, 14 Dec 2016 13:07:42 GMT

Try

data want;
set have;
retain country 'Canada';
run;

Re: Is there a way to add an extra variable column while importing a data?

ballardw — Wed, 14 Dec 2016 15:33:25 GMT

As a generic comment: any data imported using a data step can do practically anything you want in a data step. I routinely in a read data step add analysis and data quality indicator variables, write messages to the log or another file about suspect values or data inconsistencies, recode character values to numeric and/or apply standardization rules such as proper case or sentence case to character variables.