Write and run SAS programs in your web browser

How to Abbreviate.

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

How to Abbreviate.

I got a code as shown below. How do I abbreviate the if statements in a way that goes like this Chile-Japan without typing every one of them?

 

data med;
infile "/folders/myshortcuts/sas/Vaccines.dat";
input
VacName $ 1-29
Mode $ 32-50
WInc 51-60
WDeath 61-70
Chile $ 71-73
Cuba $ 77-79
US $ 83-85
UK $ 89-91
Finland $ 95-97
Germany $ 101-103
SaudiArab $ 107-109
Ethiopia $ 113-115
Botswana $ 119-121
India $ 125-127
Australia $ 131-133
China $ 137-139
Japan $ 143-145
;
if WDeath = "" then WDeath = "0";
if WInc = "" then WDeath = "0";
if Chile = "" then Chile = "No";
if Cuba = "" then Cuba = "No";
if US = "" then US = "No";
if UK = "" then UK = "No";
if Finland = "" then Finland = "No";
if Germany = "" then Germany = "No";
if SaudiArab = "" then SaudiArab = "No";
if Ethiopia = "" then Ethiopia = "No";
if Botswana = "" then Botswana = "No";
if India = "" then India = "No";
if Australia = "" then Australia = "No";
if China = "" then China = "No";
if Japan = "" then Japan = "No";
run;

proc print data=med;
format WInc comma10. WDeath comma8.;
run;


Accepted Solutions
Solution
‎08-08-2017 09:41 PM
PROC Star
Posts: 325

Re: How to Abbreviate.

something like this

 

data med;

set med;

array country{13} Chile Cuba US UK Finland Germany SaudiArab Ethiopia  Botswana India  Australia China Japan ;

do i = 1 to 13;

if country{i} = "" then country{i} ="No"

end;

drop i;

run;

View solution in original post


All Replies
Solution
‎08-08-2017 09:41 PM
PROC Star
Posts: 325

Re: How to Abbreviate.

something like this

 

data med;

set med;

array country{13} Chile Cuba US UK Finland Germany SaudiArab Ethiopia  Botswana India  Australia China Japan ;

do i = 1 to 13;

if country{i} = "" then country{i} ="No"

end;

drop i;

run;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 206 views
  • 1 like
  • 2 in conversation