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

[mssh2712]

Hi

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.

[mssh2712]

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

[Jagadishkatam · Accepted solution]

Try

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

[ballardw]

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.