topic Missing columns in a new data set in New SAS User

Missing columns in a new data set

butterfly_wing — Sat, 05 Jan 2019 13:08:18 GMT

Hello,

I am using SAS Studio and I tried to create a new variable using conditional logic. The new variable was created successfully (called NewVar).

My original dataset has 140 columns so I was expecting my data set to have 141 columns (with one new variable). However, my new data set only has 33 columns. Why is that?

Below are my codes, really appreciate your help! By the way, is there a way to write a statement to keep ALL the variables?

Data Data_2;
Set WORK.PRINTSORTEDDATA;
Length NewVar 4;
IF B6 = 1 THEN NewVar = 6;
ELSE IF B7 = 1 then NewVar = 5;
else if B7 = 2 then NewVar = 4;
else if B7 = 3 then NewVar = 3;
else if B7 = 4 then NewVar = 2;
else if B7 = 5 then NewVar = 1;
RUN;

Re: Missing columns in a new data set

kiranv_ — Sat, 05 Jan 2019 14:01:08 GMT

Nothing in your code will decrease columns. use proc contents to see columns of both the tables, that will give you good idea on what is happening.

Proc contents data = Data_2;
run;

Proc contents data = PRINTSORTEDDATA;
run;

/* You can use dictionay.columns to find what are columns which are not there. example code below and you can use the same for your code*/

data class;
		set sashelp.class(drop=age);
		run;

proc sql ;
 select coalesce(a.name, b.name) as missing_column
 from 
	   (select name from Dictionary.columns
	     where upcase(libname)=upcase('work') and 
	     upcase(memname)=upcase('class'))a 
full join
      (Select name from Dictionary.columns
       where upcase(libname)=upcase('SASHELP') and 
		upcase(memname)=upcase('CLASS'))b 
		
on upcase(a.name)=upcase(b.name) 
 where a.name is missing or b.name is missing;

Re: Missing columns in a new data set

Reeza — Sat, 05 Jan 2019 19:00:50 GMT

Check your log? You likely have an error somewhere and are working with a partial data set.

@butterfly_wing wrote:

Hello,

I am using SAS Studio and I tried to create a new variable using conditional logic. The new variable was created successfully (called NewVar).

My original dataset has 140 columns so I was expecting my data set to have 141 columns (with one new variable). However, my new data set only has 33 columns. Why is that?

Below are my codes, really appreciate your help! By the way, is there a way to write a statement to keep ALL the variables?

Data Data_2;
Set WORK.PRINTSORTEDDATA;
Length NewVar 4;
IF B6 = 1 THEN NewVar = 6;
ELSE IF B7 = 1 then NewVar = 5;
else if B7 = 2 then NewVar = 4;
else if B7 = 3 then NewVar = 3;
else if B7 = 4 then NewVar = 2;
else if B7 = 5 then NewVar = 1;
RUN;