topic Basic Problem! in New SAS User

Basic Problem!

Alex901 — Tue, 22 Sep 2020 19:52:54 GMT

Hello there,

I am new user, and got stock in a question which I couldnt get it to run on SAS, any help appreciated.

the question:

Create a dataset called “small” from main and store it in the lab library. Do this problem in steps: first, use the following “keep” option to reduce the number of variables in this new data set. Next, sort the data set by child’s gender (csex). Lastly, print a list of the first 10 records for the following variables: mrace frace.

keep dmage mrace dmar dlivord dfage frace csex dbirwt primac wtgain;

thank you so much in advance

Re: Basic Problem!

PaigeMiller — Tue, 22 Sep 2020 19:54:42 GMT

Show us what you have tried so far.

Re: Basic Problem!

Alex901 — Tue, 22 Sep 2020 20:05:34 GMT

this is what i have tried, I know it is not correct so please excuse me.

data main;
set small;
if csex = '1';
keep dmage mrace dmar dlivord dfage frace csex dbirwt primac wtgain;
run;
input dmage mrace dmar dlivord dfage frace csex dbirwt primac wtgain;
proc print data = small (obs 10);
run;

Re: Basic Problem!

Alex901 — Tue, 22 Sep 2020 20:09:36 GMT

Re: Basic Problem!

Tom — Tue, 22 Sep 2020 20:13:45 GMT

What purpose do you think that third to last line is doing?
You don't seem to have anything that will sort the data as requested. How do you propose to sort the data?

Re: Basic Problem!

Alex901 — Tue, 22 Sep 2020 21:59:34 GMT

okay so I was trying a little and this is what i got

title 'Lab 6 – Problem 5';
data main;
set small (keep dmage mrace dmar dlivord dfage frace csex dbirwt primac wtgain);
main = csex;
proc sort main;
by csex;
run;
proc print data = main;
run;

thanks

Re: Basic Problem!

Cynthia_sas — Wed, 23 Sep 2020 14:47:01 GMT

Hi:

There are a few things wrong with your program. Here's a hint about one of them that should be generating errors. If you are going to reference a dataset in a procedure step you need data= -- so, for example, consider the difference in your PROC SORT versus your PROC PRINT. One is right and the other is not:

In your program, I recommend that you look up the difference between a KEEP statement and a KEEP= option and then correct your syntax accordingly. Also, what is the purpose of the main=csex; assignment statement? Are you trying to create a new variable or column called MAIN by assigning the current value of the variable CSEX? Why is the name of the variable the same as the name of the dataset you are creating? What is this statement really doing and is it doing what you need to do??

Hope this helps,

Cynthia

Re: Basic Problem!

Alex901 — Thu, 24 Sep 2020 23:58:07 GMT

THANK YOU SO MUCH!

I ran it now and it worked, sorry I just started to learn SAS and I am still new in this, I really appreciate your help Cynthia!

Data small;

Set main;

keep dmage mrace dmar dlivord dfage frace csex dbirwt primac wtgain;

run;

proc sort data = small;

by csex;

run;

proc print data = small (obs = 10);

run;

Re: Basic Problem!

Cynthia_sas — Fri, 25 Sep 2020 15:21:16 GMT

Hi:
Right now, the dataset SMALL is just a copy of MAIN, with certain variables kept in the new dataset. So, SMALL should have the same number of rows as MAIN. If you meant to subset MAIN based on some value, it looks like you forgot that statement. But I'm glad you got it working. I highly recommend our free Programming 1 e-learning class which would explain the DATA step, IF statements, KEEP statements, PROC statements and other essential things about SAS syntax and writing programs.

Cynthia