topic Re: Stuck in SAS Programming

Stuck

randythomas84 — Thu, 31 May 2018 23:10:08 GMT

I am working on something right now and I am stuck.. can anyone help me??
Data set Errors contains character variables Subj (3 bytes) and PartNumber (8 bytes). create a temporary SAS data set (Check1) with any observations in Errors that violates either of the following two rules: first, Subj should contain only digits, and second PartNumber should contain only the upper case letters L and S and the Digits.

it gives you a set of Datalines which are
datalines;
001 L1232 Nichole Brown
0a2 L887X Fred Beans
003 12321 Alfred 2 Nice
004 abcde Mary Bumpers
x89 8888S Gill Sandford
;
My Solution isn't working

data a15009.errors;
input subj
PartsNumber
Name
;
datalines;
001 L1232 Nichole Brown
0a2 L887X Fred Beans
003 12321 Alfred 2 Nice
004 abcde Mary Bumpers
x89 8888S Gill Sandford
;
run;
Proc Print data = a15009.errors;
Run;

Please Help!!

Re: Stuck

Reeza — Thu, 31 May 2018 23:14:32 GMT

@randythomas84 wrote:

My Solution isn't working

Can you post your non-working solution so we can see what approach you're taking?

@randythomas84 wrote:

I am working on something right now and I am stuck.. can anyone help me??
Data set Errors contains character variables Subj (3 bytes) and PartNumber (8 bytes). create a temporary SAS data set (Check1) with any observations in Errors that violates either of the following two rules: first, Subj should contain only digits, and second PartNumber should contain only the upper case letters L and S and the Digits.

it gives you a set of Datalines which are
datalines;
001 L1232 Nichole Brown
0a2 L887X Fred Beans
003 12321 Alfred 2 Nice
004 abcde Mary Bumpers
x89 8888S Gill Sandford
;
My Solution isn't working

data a15009.errors;
input subj
PartsNumber
Name
;
datalines;
001 L1232 Nichole Brown
0a2 L887X Fred Beans
003 12321 Alfred 2 Nice
004 abcde Mary Bumpers
x89 8888S Gill Sandford
;
run;
Proc Print data = a15009.errors;
Run;

Please Help!!

Re: Stuck

randythomas84 — Thu, 31 May 2018 23:15:56 GMT

This is my solution it just puts periods in the boxes instead of any names

Re: Stuck

novinosrin — Thu, 31 May 2018 23:17:58 GMT

data  errors;
input subj 
PartsNumber
Name
;
datalines;
001 L1232 Nichole Brown
0a2 L887X Fred Beans
003 12321 Alfred 2 Nice
004 abcde Mary Bumpers
x89 8888S Gill Sandford
;
run;

data correct;
infile cards truncover;
input subj  $
PartsNumber $
Name & $20.
;
datalines;
001 L1232 Nichole Brown
0a2 L887X Fred Beans
003 12321 Alfred 2 Nice
004 abcde Mary Bumpers
x89 8888S Gill Sandford
;
run;

Re: Stuck

randythomas84 — Thu, 31 May 2018 23:24:18 GMT

It is still just giving periods instead of giving me the errors and correcting them.

As I read it it should display everything with corrections correct?

Re: Stuck

novinosrin — Thu, 31 May 2018 23:29:53 GMT

@randythomas84 Try applying the conditions listed in the question with an if then statement after the input statement.

Please attempt. Trust me you will get the hang of it

for a start if anyalpha(subj)>0 or notdigit(subj)>0 will indicate presence of chars other than digits. My request is for you to try and come back to community to make the discussion more interesting and interactive please

Re: Stuck

randythomas84 — Thu, 31 May 2018 23:35:47 GMT

@novinosrin I would love too only i'm just starting to use SAS and I have no clue what I'm doing still.. I'm sorry I really don't I'm working on it but the syntax is a little weird to me.

Re: Stuck

novinosrin — Thu, 31 May 2018 23:57:53 GMT

meddle with this code and change the conditions as necessary:

data errors correct all;
infile cards truncover;
input subj  $
PartsNumber $
Name & $20.;
if anyalpha(subj)>0 or length(compress(partsnumber,'LS','n'))>0 then output errors;
else output correct;
output all;
;
datalines;
001 L1232 Nichole Brown
0a2 L887X Fred Beans
003 12321 Alfred 2 Nice
004 abcde Mary Bumpers
x89 8888S Gill Sandford
;
run;