topic Re: Programming Question in SAS Programming

Extract a Words from Text Strings. Problem solved - TYO

sulafa — Thu, 10 Dec 2020 15:17:27 GMT

Hello SAS Communities,

I am working on a code but have some errors, below what I need to do:-

1. to concatenate three variables ( FirstInit, MiddleInit, LastInit) into one variable named Inits.

2. Extract the "City" from Text Strings(CityState).

3. Extract the "StateCd" from Text Strings(CityState).

My Code looks like this

DATA ..... ;

LENGTH SocSecNum $11

FirstInit $2

MiddleInit $2

LastInit $2

CityState $35

ZipCD $5;

SET .... (RENAME=(SocSecNum= SSN));

FirstInit = COMPRESS(FirstInit,'.');

MiddleInit = COMPRESS(MiddleInit,'.');

LastInit = COMPRESS(LastInit,'.')

Inits = CATS(FirstInit,MiddleInit,LastInit);

City = SCAN(CityState, 1, ' ,');

StateCd = SCAN(CityState, 2, ' ,');

KEEP SSN

Inits

City

StateCd

ZipCd;

RUN;

Here what the log looks like

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 DATA WORK.Contact_MS ;

74 LENGTH SocSecNum $11

75 FirstInit $2

76 MiddleInit $2

77 LastInit $2

78 CityState $35

79 ZipCD $5;

80 SET .... (RENAME=(SocSecNum= SSN));

83 FirstInit = COMPRESS(FirstInit,'.');

84 MiddleInit = COMPRESS(MiddleInit,'.');

85 LastInit = COMPRESS(LastInit,'.')

86 Inits = CATS(FirstInit,MiddleInit,LastInit);

_____

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT,

IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=.

87 City = SCAN(CityState, 1, ' ,');

88 StateCd = SCAN(CityState, 2, ' ,');

89 KEEP SSN

90 Inits

91 City

92 StateCd

93 ZipCd;

95 RUN;

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).

85:22 86:22

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).

1:1

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

WARNING: The data set ... may be incomplete. When this step was stopped there were 0 observations and 5 variables.

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.01 seconds

97 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

THANK YOU!

Re: Programming Question

sulafa — Wed, 04 Nov 2020 01:06:53 GMT

I am attaching also what is the data set looks like:-

Re: Programming Question

andreas_lds — Wed, 04 Nov 2020 05:53:07 GMT

Please post data as a data step using datalines, screenshots are hardly helpful. Then you must explain what the problem is, if you get any errors, post the complete log using the "insert code" button.

Task 1: using cats alone should be sufficient, i don't see the need for compress.

Task 2+3: Use "," as third parameter for scan, no blank inside the quotes!

Re: Programming Question

PaigeMiller — Wed, 04 Nov 2020 11:45:55 GMT

Many people will not download Microsoft Office documents because they are a security threat. Post your log by copying it as text from the LOG window (not from your MS Office document) and pasting it into the window that appears here when you click on the </> icon. Do not skip this step. Do not post LOG contents any other way.

Please go back and edit your original message and provide a meaningful title that describes your problem. A title of "Programming Question" could apply to almost every message here and is not informative. This helps everyone out as people may search for their problem and won't find it if your title says "Programming Question".

Re: Programming Question

sulafa — Wed, 04 Nov 2020 15:16:33 GMT

That makes sense, I am going to do that, thank you!

Re: Programming Question

sulafa — Wed, 04 Nov 2020 15:18:32 GMT

That Makes sense Andreas, I am going to do that, thank you so much!

Re: Programming Question

sulafa — Wed, 04 Nov 2020 15:31:13 GMT

here is my Data Step:-
DATA WORK.Contact_MS ;
LENGTH SocSecNum $11
FirstInit $2
MiddleInit $2
LastInit $2
CityState $35
ZipCD $5;
SET HypImpt.MS_Citizens (RENAME=(SocSecNum= SSN));

FirstInit = COMPRESS(FirstInit,'.');
MiddleInit = COMPRESS(MiddleInit,'.');
LastInit = COMPRESS(LastInit,'.')
Inits = CATS(FirstInit,MiddleInit,LastInit);
City = SCAN(CityState, 1, ' ,');
StateCd = SCAN(CityState, 2, ' ,');
KEEP SSN
Inits
City
StateCd
ZipCd;

RUN;

Re: Programming Question

sulafa — Wed, 04 Nov 2020 15:32:01 GMT

here is the log:-

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 DATA WORK.Contact_MS ;
74 LENGTH SocSecNum $11
75 FirstInit $2
76 MiddleInit $2
77 LastInit $2
78 CityState $35
79 ZipCD $5;
80 SET HypImpt.MS_Citizens (RENAME=(SocSecNum= SSN));
81
82
83 FirstInit = COMPRESS(FirstInit,'.');
84 MiddleInit = COMPRESS(MiddleInit,'.');
85 LastInit = COMPRESS(LastInit,'.')
86 Inits = CATS(FirstInit,MiddleInit,LastInit);
_____
22
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT,
IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=.

87 City = SCAN(CityState, 1, ' ,');
88 StateCd = SCAN(CityState, 2, ' ,');
89 KEEP SSN
90 Inits
91 City
92 StateCd
93 ZipCd;
94
95 RUN;

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
85:22 86:22
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
1:1
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.CONTACT_MS may be incomplete. When this step was stopped there were 0 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

96
97 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
109

Re: Programming Question

PaigeMiller — Wed, 04 Nov 2020 15:36:06 GMT

Would you please provide the log as I instructed, to preserve the formatting and make it easier to read? (And thank you for the subject line modification)

Re: Programming Question

sustagens — Thu, 05 Nov 2020 08:57:25 GMT

End this line with a semicolon

LastInit = COMPRESS(LastInit,'.')

Re: Programming Question

sulafa — Mon, 09 Nov 2020 02:24:30 GMT

Hello PaigeMiller,
thank you so much for follow up with me, and I am sorry I missed your message, I tried to do as instructed by failed, but the problem solved, thank you again.
best,
Sulafa

Re: Programming Question

sulafa — Mon, 09 Nov 2020 02:25:34 GMT

Hello Sustagens,
thank you so much, that works!