topic Re: Create new variable from existing in SAS Programming

Create new variable from existing

stancemcgraw — Mon, 28 Mar 2016 21:34:32 GMT

I am trying to create a new variable from an exisitng one, but whenever I try, it says variable uninitialized. What is the problem?

libname Iat '\\vmware-host\Shared Folders\Desktop\SAS\IAT\';

PROC IMPORT OUT= X.X

DATAFILE= 'timetoiat'

DBMS=CSV REPLACE;

GETNAMES=YES;

GUESSINGROWS=X;

DATAROW=X;

RUN;

proc import datafile="\\vmware-host\Shared Folders\Desktop\SAS\IAT\timetoiat"

out=Iat.timetoiat dbms=xlsx replace;

sheet="Sheet1";

getnames=yes;

run;

Data iat;

set iat.timetoiat;

IF NIHSS LE 16 THEN NIHSS=NIHSSLT16;

IF NIHSS >=16 THEN NIHSS=NIHSSGTE16;

RUN;

log:

20 Data iat;

21 set iat.timetoiat;

22 IF NIHSS LE 16 THEN NIHSS=NIHSSLT16;

23 IF NIHSS >=16 THEN NIHSS=NIHSSGTE16;

24 RUN;

NOTE: Variable NIHSSLT16 is uninitialized.

NOTE: Variable NIHSSGTE16 is uninitialized.

NOTE: There were 380 observations read from the data set IAT.TIMETOIAT.

NOTE: The data set WORK.IAT has 380 observations and 24 variables.

NOTE: DATA statement used (Total process time):

real time 0.03 seconds

cpu time 0.01 seconds

Re: Create new variable from existing

Reeza — Mon, 28 Mar 2016 21:48:31 GMT

The error message is pretty clear.

Run a proc contents to check your variable names are correct.

Re: Create new variable from existing

Astounding — Tue, 29 Mar 2016 00:25:24 GMT

Which variable are you trying to create? This code is trying to replace NIHISS. It doesn't create anything new.

Re: Create new variable from existing

Kurt_Bremser — Tue, 29 Mar 2016 07:35:50 GMT

20       Data iat;
21       set iat.timetoiat;
22       IF NIHSS LE 16 THEN NIHSS=NIHSSLT16;
23       IF NIHSS >=16 THEN NIHSS=NIHSSGTE16;
24       RUN;

NOTE: Variable NIHSSLT16 is uninitialized.
NOTE: Variable NIHSSGTE16 is uninitialized.

this simply means that there are no variables NIHSSLT16 and NIHSSGTE16 in dataset iat.timetoiat.

Have a look at your infile you use in PROC IMPORT. I also noted that you import into library LAT, but use IAT.timetoiat in your DATA step.

Re: Create new variable from existing

cici0017 — Tue, 29 Mar 2016 14:28:11 GMT

Your previous code is replacing the value of NIHSS but not created variables NIHSSLT16 and NIHSSGTE16, you should have code:

Data iat;
set iat.timetoiat;
   IF NIHSS LE 16 THEN NIHSSLT16=NIHSS;
   IF NIHSS >=16 THEN NIHSSGTE16=NIHSS;
  RUN;