topic Re: Create new variable in dataset in New SAS User

Create new variable in dataset

sasnewbie5 — Tue, 11 Dec 2018 01:13:17 GMT

I need to create a new variable that contains the first and last name from my dataset. The code I have is as follows:

data hw9.combo;
	infile "/folders/myfolders/hw9/combo";
	input name = firstname + lastname;
run;

I get the following errors when trying to run it:

NOTE: Variable lastname is uninitialized.

ERROR: Physical file does not exist, /folders/myfolders/hw9/combo.

Can anyone help me resolve this? I'm using SAS university edition, which is why I did the file location that way.

r_behata — Tue, 11 Dec 2018 01:46:41 GMT

Hello @sasnewbie5 . Please look into this video, it may be a good reference point for importing external data into SAS.

VDD — Tue, 11 Dec 2018 03:26:21 GMT

data hw9.combo;

infile "/folders/myfolders/hw9/combo";

input name = firstname + lastname;

run;

we don't add character variables.

one way to create a new variable name would be

name = firstname || ' ' || lastname;

ballardw — Tue, 11 Dec 2018 17:08:28 GMT

First thing will be to get the name of the file to read correct.

Second while + is acceptable on an input statement it is used to move a read pointer. The = would not be.

Read the variables then manipulate them.