topic reading a sas7bdat file in a data step to perform conditional processing in SAS Programming

reading a sas7bdat file in a data step to perform conditional processing

Dublin187 — Fri, 25 Jan 2019 04:12:21 GMT

Hi,

This is a beginner's question but I am unable to solve the problem myself. Thank you in advance for your help.

How do we combine the following statements in a data step?

I am unable to code properly to get my file read.

Can I use the 'set' statement right after my 'infile' statement? Or do I need to put a 'input' statement?

The following code is wrong, but how could I get SAS to read my file so that I can perform conditional processing?

Do I need to divide the whole thing into 2 data steps?

Thank you

Data Sales;
infile '/home/XXX/learn/sales.sas7bdat';
input Region TotalSales;
set sales (keep = TotalSales Region)
Select (region);
When (Region = 'North') Weight = 1.5;
When (Region = 'South') Weight = 1.7;
When (Region = 'West') Weight = 2.0;
when (Region = 'East') Weigth = 2.0;
Otherwise;
End;
run;

Title 'Region and TotalSales';
proc print data=sales;
run;

Re: reading a sas7bdat file in a data step to perform conditional processing

novinosrin — Fri, 25 Jan 2019 04:15:15 GMT

sas7bdat

is a file extn of a sas dataset

So all you need is

Data Sales;
set sales (keep = TotalSales Region)
Select (region);
When (Region = 'North') Weight = 1.5;
When (Region = 'South') Weight = 1.7;
When (Region = 'West') Weight = 2.0;
when (Region = 'East') Weigth = 2.0;
Otherwise;
End;
run;

Re: reading a sas7bdat file in a data step to perform conditional processing

Tom — Fri, 25 Jan 2019 04:27:42 GMT

An INPUT statement is used to read text from lines of text into values of variables.

To read in a SAS dataset just use a set statement.

You could first use a LIBNAME statement define a libref that points to the folder with the SAS dataset in it and use that libref in your code.

libname learn  '/home/XXX/learn/';
data Sales;
  set learn.sales (keep = TotalSales Region) ;
 ....

Or you could skip the libname and just use the quoted physical path of the dataset.

data Sales;
  set '/home/XXX/learn/sales.sas7bdat' (keep = TotalSales Region) ;
 ....

Re: reading a sas7bdat file in a data step to perform conditional processing

VDD — Fri, 25 Jan 2019 04:33:09 GMT

libname mylib '/home/XXX/learn';


data sales;
set mylib.sales (keep = TotalSales Region);
if Region = 'North' then Weight = 1.5;
else if Region = 'South' then Weight = 1.7;
else if Region = 'West' then Weight = 2.0;
else if Region = 'East' then Weigth = 2.0;
End;
run;

Title 'Region and TotalSales';
proc print data=sales;
run;

title;

Re: reading a sas7bdat file in a data step to perform conditional processing

Dublin187 — Fri, 25 Jan 2019 13:44:59 GMT

Thank you! it works! Have a lovely day! 🙂