topic Re: Advanced Programming Course Error in Advanced Programming

Advanced Programming Course Error

smokinjack1559 — Sun, 27 Nov 2022 21:14:11 GMT

When I do the practices I get this error:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 data work.NationalPreserves;
74 set pg3.np_acres;
NOTE: Data file PG3.NP_ACRES.DATA is in a format that is native to another host, or the file encoding
does not match the session encoding. Cross Environment Data Access will be used, which might
require additional CPU resources and might reduce performance.
75
76 Exp='/(N PRES\s|N PRESERVE\s|NPRES\s|NPRE\s)/o';
77 Pid=prxparse(Exp);
78 Position=prxmatch(Pid,ParkName);
79 if Position;
80 ParkName=prxchange('s/N PRES\s|N PRESERVE\s|NPRES\s/NPRE /', 1, ParkName);
81 run;

ERROR: Some character data was lost during transcoding in the dataset PG3.NP_ACRES. Either the data
contains characters that are not representable in the new encoding or truncation occurred
during transcoding.
NOTE: The DATA step has been abnormally terminated.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 73 observations read from the data set PG3.NP_ACRES.
WARNING: The data set WORK.NATIONALPRESERVES may be incomplete. When this step was stopped there
were 4 observations and 8 variables.

Re: Advanced Programming Course Error

MarkusWeick — Mon, 28 Nov 2022 07:42:16 GMT

Hi @smokinjack1559,

in which of the practises did you get this error?

Best

Markus

Re: Advanced Programming Course Error

Kurt_Bremser — Mon, 28 Nov 2022 09:25:24 GMT

There is a mismatch in the encoding (UTF vs. ASCII) between your SAS and the dataset. Run a PROC CONTENTS on the dataset.

Re: Advanced Programming Course Error

smokinjack1559 — Mon, 28 Nov 2022 13:15:03 GMT

All the ones I tried so far.

The latest is Level 1 Practice: Using the PRXMATCH and PRXCHANGE Functions

I am using virtual lab.

Re: Advanced Programming Course Error

smokinjack1559 — Mon, 28 Nov 2022 15:07:20 GMT

Today, I can not launch virtual lab. Citrix just spins. Cyber Monday after a four day weekend?

I set up SAS studio. I ran the program and did not get the same errors as in virtual lab.

Re: Advanced Programming Course Error

MarkusWeick — Mon, 28 Nov 2022 16:11:54 GMT

That's what I would have tried too. I used SAS ondemand fpr academics for the whole practise part.