Learning SAS? Welcome to the exclusive online community for all SAS learners.

sas studio more than 262 bytes long results tab blank

Reply
New Contributor
Posts: 4

sas studio more than 262 bytes long results tab blank

HI

 

my results tab is completely blank.  I get this in my long. 

 
 
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
2 TITLE;
3 FOOTNOTE;
4 OPTIONS LOCALE=en_US DFLANG=LOCALE;
NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks.
5 DATA _NULL_;
6 RUN;
 
 

previously, this was just occurring with my macros statement, however, now it's happening even within the data step.  

 
proc import OUT= tbdatafile DATAFILE = '/home/cgmacias0/EP 850 app inter epi'
DBMS=xls REPLACE;
SHEET="#LN00014";
GETNAMES=YES;
RUN;
 
*In-class assignment;
 
 
data smoking;
set tbdatafile;
 
if age lt 21 then delete;
 
*Exposure: ever/never smoker;
if nfcsmk=0 then smokecat=0;
if nfcsmk in (1,2) then smokecat=1;
 
*agecat;
if age lt 40 then agecat=1;
if age ge 40 then agecat=2;
 
*race;
*white, black, hispanic, other;
if race=1 then racecat=1;
if race=2 then racecat=2;
if race=3 then racecat=3;
if race in (4,5,6,7) then racecat=4;
 
*income;
if income=8 then income=.;
run;
 
*Consider the following covariates as potential confounders and explore missingness of these variables;
proc means data=smoking nmiss;
var bornus education farm_wkr gender racecat income agecat drinkperwk;
run;
 
proc freq data=smoking;
tables bornus education farm_wkr gender racecat income agecat drinkperwk/missing;
run;
 
*Looking at patterns of missingness - an example;
proc freq data=smoking;
tables farm_wkr*bornus/missing;
run;
 
*Complete Case Analysis - Confounder Assessment;
*We need to remove subjects with missing data on any of our covariates of interest for estimation of the crude;
 
data cca;
set smoking;
 
if education=. then delete;
if farm_wkr=. then delete;
if income=. then delete;
 
run;
 
proc logistic data=cca desc;
model tbcat=smokecat;
run;
 
%macro logistic (var);
proc logistic data=cca desc;
class smokecat (param=ref ref='0') &var;
model tbcat=smokecat &var;
run;
%mend;
 
%logistic (agecat);
%logistic (gender);
%logistic (racecat);
%logistic (income);
%logistic (education);
%logistic (bornus);
%logistic (farm_wkr);
 
 
Super User
Posts: 24,028

Re: sas studio more than 262 bytes long results tab blank

Set PARAM=REF on your class statement. As shown, it won't apply to your macro variable.

 

class smokecat (ref='0') &var / param=ref;

I don't see anything in your code that's problematic, I would expect restarting SAS would help.

 

If you're using SAS UE, I've  seen this before and it has nothing to do with your code but I don't know what causes it either. It usually doesn't affect me getting results though, so if you're not seeing anything that's problematic. You could try using a different ODS destination and seeing if that helps? 

 

%macro logistic (var);
proc logistic data=cca desc;
class smokecat (param=ref ref='0') &var;
model tbcat=smokecat &var;
run;
%mend;
 
ods html file='/folders/myfolders/demo.html' style=meadow;
ods excel file = '/folders/myfolders/demo.xlsx' style=meadow;

%logistic (agecat);
%logistic (gender);
%logistic (racecat);
%logistic (income);
%logistic (education);
%logistic (bornus);
%logistic (farm_wkr);

ods html close;
ods excel close;

 

New Contributor
Posts: 4

Re: sas studio more than 262 bytes long results tab blank

Sorry, what is SAS UE? Actually, i did restart SAS, sometimes it woks.
sometimes it doesn't . Sometimes the data step will run, but then I get a
blank results tab, with the first macros code.

Super User
Posts: 24,028

Re: sas studio more than 262 bytes long results tab blank

Run it step by step and isolate where the problem starts and tell us that. Or provide sample data so we can run your code. 

 

SAS UE is a free learning edition of SAS, University Edition.  

 

 

Are you getting results before this message? 

 

Maybe post your full log as well. 

New Contributor
Posts: 4

Re: sas studio more than 262 bytes long results tab blank

This is the  entire log running the data step only:

 

 

 
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
2 TITLE;
3 FOOTNOTE;
4 OPTIONS LOCALE=en_US DFLANG=LOCALE;
NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks.
5 DATA _NULL_;
6 RUN;
7 OPTIONS VALIDVARNAME=ANY;
8 OPTIONS VALIDMEMNAME=COMPAT;
9 FILENAME _HTMLOUT TEMP;
10 FILENAME _PDFOUT TEMP;
11 FILENAME _GSFNAME TEMP;
12 FILENAME _DATAOUT TEMP;
13 %LET SYSCC=0;
14 %LET _CLIENTAPP='SAS Studio';
15 %LET _CLIENTAPPABREV=Studio;
16 %LET _CLIENTAPPVERSION=3.7;
17 %LET _CLIENTVERSION=3.7;
18 %LET _CLIENTMODE=wip;
19 %LET _SASSERVERNAME=%BQUOTE(SASApp);
20 %LET _SASHOSTNAME=%BQUOTE(odaws01-prod-us);
21 %LET _SASPROGRAMFILEHOST=%BQUOTE(odaws01-prod-us);
22 %LET _CLIENTUSERID=%BQUOTE(cgmacias0);
23 %LET _CLIENTUSERNAME=%BQUOTE(cgmacias0);
24 %LET CLIENTMACHINE=%BQUOTE(BUMC-DOT1X-155-41-220-47.BUMC.BU.EDU);
25 %LET _CLIENTMACHINE=%BQUOTE(BUMC-DOT1X-155-41-220-47.BUMC.BU.EDU);
26 %let SASWORKLOCATION="%sysfunc(getoption(work))/";
27 FILENAME _CWD '.';
28 DATA _NULL_;
29 CALL SYMPUT('_SASWORKINGDIR',PATHNAME('_CWD'));
30 RUN;
31 FILENAME _CWD;
32
33 %LET _SASPROGRAMFILE = %NRQUOTE(%NRSTR(/home/cgmacias0/EP 850 app inter
33 ! epi/class9_matching.missing.confounding/9_InClass_MissingData-2.sas));
34 %LET _BASEURL = %BQUOTE(https://odamid.oda.sas.com/SASStudio/);
35 %LET _EXECENV=SASStudio;
36 DATA _NULL_;
37 CALL SYMPUT("GRAPHINIT","");
38 CALL SYMPUT("GRAPHTERM","");
39 RC=TSLVL('GEOCODE','N');
40 _ERROR_=0;
41 IF (RC^=' ') THEN DO;
42 CALL SYMPUT("GRAPHINIT","GOPTIONS RESET=ALL GSFNAME=_GSFNAME;");
43 CALL SYMPUT("GRAPHTERM","GOPTIONS NOACCESSIBLE;");
44 END;
45 RUN;
46 DATA _NULL_;
47 RC=SYSPROD("PRODNUM002");
48 IF (RC^=1) THEN DO;
49 CALL SYMPUT("GRAPHINIT","");
50 CALL SYMPUT("GRAPHTERM","");
51 END;
52 RUN;
53 %LET _DATAOUT_MIME_TYPE=;
54 %LET _DATAOUT_NAME=;
55 %LET _DATAOUT_TABLE=;
56 %LET _DATAOUT_URL=;
57 %SYMDEL _DATAOUT_MIME_TYPE _DATAOUT_NAME _DATAOUT_URL _DATAOUT_TABLE;
58 %LET _SASWS_ = %BQUOTE(/home/cgmacias0);
59 %LET _SASWSTEMP_=%BQUOTE(/home/cgmacias0/.sasstudio/.images/a648d321-8fb5-4fb9-a754-23e39dafd382);
60 ODS LISTING CLOSE;
61 ODS AUTONAVIGATE OFF;
62 ODS GRAPHICS ON;
63 ODS HTML5 (ID=WEB) DEVICE=PNG GPATH="&_SASWSTEMP_" ENCODING=utf8 FILE=_HTMLOUT (TITLE='Results:
63 ! 9_InClass_MissingData-2.sas') STYLE=Htmlblue OPTIONS(BITMAP_MODE='INLINE' OUTLINE='ON' SVG_MODE='INLINE'
63 ! CSS_PREFIX='.ods_a648d321-8fb5-4fb9-a754-23e39dafd382' BODY_ID='div_a648d321-8fb5-4fb9-a754-23e39dafd382' );
64 ODS PDF (ID=WEB) STYLE=Pearl FILE=_PDFOUT;
65 &GRAPHINIT;
66 OPTIONS FIRSTOBS=1;
67 OPTIONS OBS=MAX;
68 OPTIONS DTRESET DATE NUMBER NOTES;
69 OPTIONS NOTES STIMER SOURCE NOSYNTAXCHECK;
70
71 proc import OUT= tbdatafile DATAFILE = '/home/cgmacias0/EP 850 app inter
71 ! epi/class9_matching.missing.confounding/TBData_missings_blank.xls'
72 DBMS=xls REPLACE;
73 SHEET="#LN00014";
74 GETNAMES=YES;
75 RUN;
76
77 *In-class assignment;
78
79
80 data smoking;
81 set tbdatafile;
82
83 if age lt 21 then delete;
84
85 *Exposure: ever/never smoker;
86 if nfcsmk=0 then smokecat=0;
87 if nfcsmk in (1,2) then smokecat=1;
88
89 *agecat;
90 if age lt 40 then agecat=1;
91 if age ge 40 then agecat=2;
92
93 *race;
94 *white, black, hispanic, other;
95 if race=1 then racecat=1;
96 if race=2 then racecat=2;
97 if race=3 then racecat=3;
98 if race in (4,5,6,7) then racecat=4;
99
100 *income;
101 if income=8 then income=.;
102 run;
103
104 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
105 ODS HTML CLOSE;
106 &GRAPHTERM; ;*';*";*/;RUN;QUIT;
107 QUIT;RUN;
108 ODS HTML5 (ID=WEB) CLOSE;
109
110 ODS PDF (ID=WEB) CLOSE;
111 FILENAME _GSFNAME;
112 DATA _NULL_;
113 RUN;
114 OPTIONS VALIDMEMNAME=COMPAT;
115 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;
116
 
Super User
Posts: 24,028

Re: sas studio more than 262 bytes long results tab blank

So it looks like you're using SAS Academics on Demand with SAS Studio.

 

The error is not with your code, it's an issue with SAS but that is a NOTE and shouldn't affect you getting results in any way. 

 

I don't think your two issues are related here, they could be, but I suspect not.

 

For the first issue, contact support@sas.com to let them know of the issue, and you can probably include the link to this thread. 

Or perhas @ChrisHemedinger has an alternative solution.

 

Your code shows no results from the log below because you didn't run anything that would have generated results. 

 

 

Community Manager
Posts: 3,467

Re: sas studio more than 262 bytes long results tab blank

I don't see anything wrong in the log either.  Are you enrolled in a class that has a predefined library? There could be something with that setup that is causing this.  Any other classmates experiencing the same?

 

I'll move this to the SAS Analytics U forum.  A tech support consultant might chime in, but if it's a continuing issue you can track with SAS Tech Support.  

 

To disable this warning (not really a solution), run:

 

options noquotelenmax;

 

Chris

Super User
Super User
Posts: 8,290

Re: sas studio more than 262 bytes long results tab blank

Do you have AUTOEXEC code defined?  Perhaps that is where the unbalanced quote is?

 

Otherwise it looks like something is wrong with the code that SAS/Studio is generating and you might need to talk to your site admin or SAS support.

New Contributor
Posts: 4

Re: sas studio more than 262 bytes long results tab blank

i'm not familiar with AUTOEXEC code? 

 

 

What is that? How do I define it?

Super User
Posts: 24,028

Re: sas studio more than 262 bytes long results tab blank


@cgmacias wrote:

i'm not familiar with AUTOEXEC code? 

What is that? How do I define it?

 

 

delete_autoexec.PNG

Autoexec is code that will run automatically when you start SAS. You could add specific option or libname statements or formats that would then be ready when you're working without having to explicitly call or define them every time.

Super User
Posts: 10,623

Re: sas studio more than 262 bytes long results tab blank

The NOTE is a clear sign that you have unbalanced quotes somewhere upstream in code that was sent to the workspace server.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 10 replies
  • 312 views
  • 0 likes
  • 5 in conversation