12-19-2017 11:36 AM
When I try to run the code I'm given to set up the data for the SAS Programming I: Essentials online training course for the SAS Enterprise Guide, the following error message appears:
An error occurred executing the workspace job “Program”. Integration technologies failed to submit the code. [Error] failed to transcode data from U_UFT8_CE to U_LATIN1_CE encoding because it contained characters which are not supported by your SAS session encoding. Please review your encoding= and locale= SAS system options to ensure that they can accommodate the data that you want to process. A portion of the source string, in hex representation is: [None] 7f7a8d474124: 3b 2a 27 3b 2a 22 3b 2a 2f 3b 71 75 69 74 3b 72 |;*’;*”;*/;quit;r|
[None] 747a8d474134: 75 6e 3b 0d 0a 4f 50 54 49 4f 4e 53 20 50 41 47 |un;..OPTIONS PAG|
[Error] Some code points did not transcode.
I am obviously brand new to SAS (hence why I'm taking the first training course), and I'm not sure how to change the encoding options or whatever to run this code so that I can set my data up for the course. I went down a rabbit hole the other day trying to register the sasionza.dll file (only to get another error message), so I'd like to know how to fix this so that I can actually take the course.
12-19-2017 11:48 AM
Thanks for your quick response. Here's the first part of the code (there was no log generated). The error message comes up even when I run this bit:
%let path = %sysfunc(pathname(work)); libname orion "&path"; data _null_; if "&sysscp"="WIN" then do; call symputx('rawdata',"&path\"); end; else do; call symputx('rawdata',"&path/"); end; run;
Thanks for your help,
12-19-2017 11:58 AM
When the file pops up with the code to run, rather than download that, copy it from the editor and paste it into a SAS program.
Do note that it's currently set to create the library in WORK which would disappear at the end of every session and you'd have to recreate it each time you restarted SAS. That seems cumbersome.
%let path = %sysfunc(pathname(work)); libname orion "&path";
I would consider changing the path to a folder/location you had permanent access to.
12-19-2017 12:04 PM
Right--that's what I did. The setup window in the course contains a hyperlink that opens up to a window with a bunch of code that I copy and paste into the EG program window in a new project, and then when I ask it to run, that error message comes up--I'm not sure what you're asking me to do differently (aside from changing the path).
12-19-2017 11:53 AM
I get a 4x6 table titled The MEANS Procedure in the Results window, and here's the log for that:
1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROJECTPATH=''; 5 %LET _CLIENTPROJECTNAME=''; 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGSR TEMP; 12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 13 STYLE=HtmlBlue 14 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/6.1/Styles/HtmlBlue.css") 15 NOGTITLE 16 NOGFOOTNOTE 17 GPATH=&sasworklocation 18 ENCODING=UTF8 19 options(rolap="on") 20 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 21 22 GOPTIONS ACCESSIBLE; 23 proc means data=sashelp.class;run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: PROCEDURE MEANS used (Total process time): real time 0.09 seconds cpu time 0.01 seconds 24 25 26 GOPTIONS NOACCESSIBLE; 27 %LET _CLIENTTASKLABEL=; 28 %LET _CLIENTPROJECTPATH=; 29 %LET _CLIENTPROJECTNAME=; 30 %LET _SASPROGRAMFILE=; 31 32 ;*';*";*/;quit;run; 33 ODS _ALL_ CLOSE; 34 35 36 QUIT; RUN; 37
12-19-2017 12:51 PM
That sucks. Unfortunately I don't have any other suggestions.
I'm guessing you're not in NA?
Either way, consider contacting email@example.com or firstname.lastname@example.org to see if they can provide additional support to get you set up.
If you're using EG I imagine you have a site license so they'll help you get it set up. If you don't have a valid SAS license it doesn't come with support
12-19-2017 01:19 PM
Actually--I'm an idiot. I went through the code some more, and I found that there were some characters that just looked like black question marks, and when I googled the words with these, they're characters with umlauts and ß's and such, so I just looked through the whole program and replaced those black question marks with u's and ss's and I'm good, haha. I'd like to be able to figure out how to get to where I can work with foreign characters like that, but at least now I can participate in the course.
Thanks for taking the time to respond to my situation.
12-19-2017 01:20 PM
Do you have add ons do your browser? That may try and interpret a text file, like a markdown or something that would cause that issue? The files don't seem to have that issue for everyone.
12-19-2017 01:28 PM
Hmm, well I tried opening up the same window in Internet Explorer, and it's just interpreting it like this:
So, the same thing happened in a different browser. I'll look into it though.