topic Re: Replace specific missing variable with differences between multiple variable columns in SAS Programming

Replace specific missing variable with differences between multiple variable columns

Kayla_Tan222 — Wed, 22 May 2019 07:17:23 GMT

Hi all,

would like to ask what code should I use in order to replace the specific missing variables column (not all, as I have total 7 missing variable columns) with

differences between multiple variables columns. was struggling this for few hours and unable to get solutions even after I tried to google search.

I had attached two screenshots with this post.

Hope to get some replies asap.Thanks.

here's my code below

data P201812;
%let _EFIERR_=0;
infile '\\D:\POLA\201812.csv' dlm=',' MISSOVER DSD lrecl=32767 $3.;

firstobs=2;

informat dev10yr_fy 4.0;

format dev10yr_fy 4.0;

INPUT

dev10yr_fy;

if _ERROR_ then call symputx('_EFIERR_',1);

run;

Re: Replace specific missing variable with differences between multiple variable columns

Onizuka — Fri, 17 May 2019 09:59:29 GMT

Hello,

First of all : put your code in the "INSERT SAS CODE"

Don't put files on attachment, just say what you want preciselly

Re: Replace specific missing variable with differences between multiple variable columns

Kayla_Tan222 — Mon, 20 May 2019 02:01:19 GMT

Hmmm, sorry. I cannot understand what you meant. Can you provide a more detail explanation?

Because i am A very beginner and almost dont know anything.

Re: Replace specific missing variable with differences between multiple variable columns

Kayla_Tan222 — Mon, 20 May 2019 02:09:22 GMT

Hi, is it the below code is what you meant?

But for the your_given_input , what should i put actually? the data file?

data zclmosnet;

set your_given_input;

zclmosnet = zclmos - zosqs-zosvc-zosaf-zossp01;

keep zclmosnet ;

run;

Re: Replace specific missing variable with differences between multiple variable columns

Patrick — Mon, 20 May 2019 02:52:29 GMT

@Kayla_Tan222

You write: "what code should I use in order to replace the specific missing variables column".

Given your latest post I assume you've got a problem when doing calculations with variables where one of them is missing.

You can use the SUM() function for such situations as this function treats missing values differently (excluding them from the calculation).

data zclmosnet;
  set your_given_input;
  zclmosnet = sum(zclmos,-zosqs,-zosvc,-zosaf,-zossp01);
  keep zclmosnet;
run;

As for posting code: Use the running man icon as I've done above. This lets you post code that doesn't get messed up.

Re: Replace specific missing variable with differences between multiple variable columns

Kayla_Tan222 — Mon, 20 May 2019 03:20:21 GMT

Hi, first of all, thanks for your reply!

I have another problem is that what shoud i put after the ‘set’ function, the file location? Or the file name?

Re: Replace specific missing variable with differences between multiple variable columns

Patrick — Mon, 20 May 2019 04:28:38 GMT

If you read data from an external file like in your original code sample then it's the INPUT statement which maps your source data into SAS variables. So any operations you want to perform on SAS variables must come after the INPUT statement.

If you read data from a source table via a SET statement then any operations you want to perform with the values coming from a source table must come after the SET statement.

Re: Replace specific missing variable with differences between multiple variable columns

Kayla_Tan222 — Tue, 21 May 2019 00:42:51 GMT

Thanks Patrick! You help me a lot!