topic Re: Why am I getting the errors? in SAS Programming

How do I solve the errors?

mdoddala — Sat, 16 Feb 2019 03:37:24 GMT

libname clinic '/home/mdoddala0';
data clinic.admit7;
 set clinic.weightclub;
 proc tabulate data=clinic.admit7;
 class team;
var startweight endweight;
table team*(startweight endweight),mean;
run;

run;

Here is the code to create the weightclub dataset

input IdNumber 1-4 Name $6-20 Team $22-27 StartWeight 29-31 EndWeight 33-35;
Loss=StartWeight-EndWeight;
cards;
1023 David Shaw red 189 165
1049 Amelia Serrano yellow 145 124
1219 Alan Nance red 210 192
1246 Ravi Sinha yellow 194 177
1078 Ashley McKnight red 127 118

;

run;

Re: How do I solve the errors?

stat_sas — Sat, 16 Feb 2019 03:41:26 GMT

Hi,

Try this

proc tabulate data=clinic.admit7;
 class team;
var startweight endweight;
table team,(startweight endweight)*mean;
run;

Re: How do I solve the errors?

mdoddala — Sat, 16 Feb 2019 04:19:44 GMT

still getting the errors:(

Errors (2)

ERROR: Variable StartWeight in list does not match type prescribed for this list.

ERROR: Variable EndWeight in list does not match type prescribed for this list.

Warnings

Notes (7)

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

71 libname clinic '/home/mdoddala0';

NOTE: Libref CLINIC refers to the same physical library as KRRISH.

NOTE: Libref CLINIC was successfully assigned as follows:

Engine: V9

Physical Name: /home/mdoddala0

72 data clinic.admit7;

73 set clinic.weightclub;

NOTE: There were 5 observations read from the data set CLINIC.WEIGHTCLUB.

NOTE: The data set CLINIC.ADMIT7 has 5 observations and 6 variables.

NOTE: DATA statement used (Total process time):

real time 0.02 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 799.53k

OS Memory 29100.00k

Timestamp 02/16/2019 04:09:31 AM

Step Count 115 Switch Count 3

Page Faults 0

Page Reclaims 181

Page Swaps 0

Voluntary Context Switches 46

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 264

74 proc tabulate data=clinic.admit7;

75 class team;

76 var startweight endweight;

ERROR: Variable StartWeight in list does not match type prescribed for this list.

ERROR: Variable EndWeight in list does not match type prescribed for this list.

77 table team,(startweight endweight)*mean;

78 run;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE TABULATE used (Total process time):

real time 0.00 seconds

user cpu time 0.00 seconds

system cpu time 0.00 seconds

memory 388.37k

OS Memory 28840.00k

Timestamp 02/16/2019 04:09:31 AM

Step Count 116 Switch Count 0

Page Faults 0

Page Reclaims 60

Page Swaps 0

Voluntary Context Switches 9

Involuntary Context Switches 0

Block Input Operations 288

Block Output Operations 0

Why am I getting the errors?

mdoddala — Sat, 16 Feb 2019 05:41:45 GMT

libname clinic '/home/mdoddala0';
data clinic.admit7;
 set clinic.weightclub;
 proc tabulate data=clinic.admit7;
 class team;
var StartWeight EndWeight;
table team,(StartWeight EndWeight)*mean;
run;

data weightclub; 
input IdNumber 1-4 Name  $6-20 Team $22-27 StartWeight  29-31 EndWeight 33-35; 
Loss=StartWeight-EndWeight;
cards; 
1023 David Shaw      red    189 165 
1049 Amelia Serrano  yellow 145 124 
1219 Alan Nance      red    210 192 
1246 Ravi Sinha      yellow 194 177 
1078 Ashley McKnight red    127 118 
; 
run

Re: Why am I getting the errors?

Patrick — Sat, 16 Feb 2019 05:56:16 GMT

@mdoddala

Please don't post the same question twice.

Answers here: https://communities.sas.com/t5/SAS-Programming/How-do-I-solve-the-errors/m-p/536113#M147292

I suggest you delete your post here.

Re: How do I solve the errors?

Patrick — Sat, 16 Feb 2019 05:58:50 GMT

@mdoddala

A SAS data step must end with a RUN; command. Look at the code you've posted. Something is off there.

Re: Why am I getting the errors?

mdoddala — Sat, 16 Feb 2019 06:01:54 GMT

I couldn't find an option to delete

Re: How do I solve the errors?

mdoddala — Sat, 16 Feb 2019 06:04:03 GMT

I think it ended with a run; statement

Re: How do I solve the errors?

Astounding — Sat, 16 Feb 2019 06:05:06 GMT

This message means that StartWeight and EndWeight are not numeric variables... they are character. The program you originally posted would have created them as numeric. Somehow a different program created clinic.weightclub

Re: Why am I getting the errors?

Patrick — Sat, 16 Feb 2019 06:13:42 GMT

@mdoddala

You as the poster of the question should have access to below menu:

Re: Why am I getting the errors?

mdoddala — Sat, 16 Feb 2019 06:18:27 GMT

@Patrick Sir, this is what I'm seeing

Re: Why am I getting the errors?

Patrick — Sat, 16 Feb 2019 06:34:27 GMT

ok - then I also don't know how you could delete the whole post. Just leave it then.

Re: Why am I getting the errors?

mdoddala — Sat, 16 Feb 2019 06:36:32 GMT

Haha alright sorry for any inconvenience:(

Re: Why am I getting the errors?

Kurt_Bremser — Sat, 16 Feb 2019 08:51:53 GMT

I merged the threads.

Please do not double-post.

Re: How do I solve the errors?

ErikLund_Jensen — Sat, 16 Feb 2019 12:02:58 GMT

Back to your question after these editorial exercises...

First: The data step you posted as source for data set weightclub produces numeric variables. So @Astounding is right about the cause of your log errors: your input data was created by a different program. If you run the data step in your post from yesterday first and then the data/tablulate step, you don't get the errors.

Second: @stat_sas pointed out that you should use a star instead of a comma in your Proc Tabulate.

not: table team,(StartWeight EndWeight),mean;

but: table team,(StartWeight EndWeight)*mean;

The star gives you the wanted statistic, while the comma adds an extra dimension and produces 2 useless tables. But it works and does not cause errors in the log.

Third: As @Patrick pointed out, you omitted a run statement before Proc Tabulate. Data steps and Proc steps are two different things, you cannot use a proc statement inside a data step, so you need to terminate the Data step before continuing your program with a Proc step. Your run statement is terminating the Proc Tabulate step, not the Data step. However, any Proc xx or Data statement acts as an implicit termination of the preceding step, so this omission does not cause any errors, but is generally seen as sloppy coding.

Conclusion: Your program runs without errors, if you use the right input, But it needs the correction proposed by sas_stats to give the desired output. And please help yourself (and others reading your code) by always using an explicit step termination. Good luck with the weight club.

Re: How do I solve the errors?

mdoddala — Sat, 16 Feb 2019 18:54:24 GMT

Thank you @ErikLund_Jensen for your clear explanation:) I think I did the mistake and I was not connecting the right dataset. Thanks again for being patient with me! I'm a beginner programmer in SAS.

Re: Why am I getting the errors?

VDD — Sun, 17 Feb 2019 13:23:04 GMT

please mark you questions as solved to close the thread. Be kind and do leave things behind.

Re: How do I solve the errors?

ErikLund_Jensen — Sun, 17 Feb 2019 14:57:02 GMT

@mdoddala

We all started as beginners, so don't let that trouble you. I know it is difficult, because SAS is not like other tools on your PC. SAS is old. A few core technologies may have survived, but SAS is probably the one and only end user tool that has been with us since data processing meant MVS systems with card punchers for input and line printers for output. I remember writing a SAS program when somebody came to tell me that Ronald Reagan had beaten Carter, and it is a marvel that a platform is still readily available to run that program today.

SAS was easier to learn in those days. In the beginning was the Data Step and a few procedures, but SAS evolved and expanded to cover new technologies. Display Manager came with CRT terminals, SAS Macro language arrived to add a scripting language to SAS, with relational databases came ODBC, SQL came as the new highlight of end-user query tools and was added to SAS also, New presentation technologies found their way into SAS with the Output Delivery System and so on. Now SAS VIYA has arrived and will over time relegate people like me to dinosaurs, but that is another story.

As an old SAS hand one had a lifetime to adopt to all these new possibilities, but a new user today will get the whole package with tools an tiers and metadata and what not. It is like a whole world of its own, and no single person can be an expert in all parts of it, but SAS version 9 is still based on the good old principles, the core is a batch system, and all SAS applications from Display Manager to SAS Studio are just interfaces that helps the user to write a program, submit it to processing in background and retrive the result.

This makes SAS stand apart from most applications that interact with a database. SAS does not handle transactions, but whole files and data sets, and this concept is difficult to comprehend for a Java or Visual Studio programmer. It is a different way of thinking, and an understanding of the concept of steps as separate blocks connected only via data files or -sets is necessary together with knowledge of the language elements and the way SAS handles a program, just as knowing the principles of boiling and roasting is essential to utilize an induction range.

A new user may find it difficult to get a starting point, but in my opinion the best way in is "The Little SAS Bok, a primer". It is now in 5. edition and not so little anymore, but it takes you in hand and guides you all the way from a having a basic understanding to become a full fledged SAS programmer. This link gives an introduction to the book:
https://www.sas.com/storefront/aux/en/splsb/65423_excerpt.pdf