Recently in the SAS Community Library: SAS' @AndyRavenna publishes the second of two posts that uses statistics and machine-learning objects in SAS Visual Analytics to address real-world business problems.
Hi All, There are both Chinese and English characters in my report. I want to use the Time New Roman font for the English characters and the SimSun font for the Chinese ones. I tried a font-face list "Times New Roman, Simsun" in my style definition. Given the Time New Roman font has no glyph for Chinese characters, I think the SimSun font will be applied for Chinese. This method is often used in CSS. But the result is not what I expected. Word processor says the Chinese characters in my report have a monospace font (等线字体) rather than SimSun. By the way, if I changed Time New Roman to Courier. It works. Courier is a kind of monospace font. Does the font type matter? Anyway, I want to know whether my idea is feasible in SAS. The following is my program sample. I program in an unicode session and both kinds of fonts have been registered in SAS. Many thanks for your help in advanced! proc template;
define style MyStyle;
parent = styles.Printer;
class fonts /
'TitleFont' = ("'Times New Roman',Simsun",10.5pt,Bold)
'TitleFont2' = ("'Times New Roman',Simsun",10.5pt,Bold)
'StrongFont' = ("'Times New Roman',Simsun",10.5pt,Bold)
'EmphasisFont' = ("'Times New Roman',Simsun",10.5pt,Italic)
'FixedEmphasisFont' = ("'Times New Roman',Simsun",10.5pt,Italic)
'FixedStrongFont' = ("'Times New Roman',Simsun",10.5pt,Bold)
'FixedHeadingFont' = ("'Times New Roman',Simsun",10.5pt,Bold)
'BatchFixedFont' = ("'Times New Roman',Simsun",10.5pt)
'FixedFont' = ("'Times New Roman',Simsun",10.5pt)
'headingEmphasisFont' = ("'Times New Roman',Simsun",10.5pt,Bold Italic )
'headingFont' = ("'Times New Roman',Simsun",10.5pt,Bold)
'docFont' = ("'Times New Roman',Simsun",10.5pt)
;
end;
run;
data test;
a = "你好, 世界";
b = "Hello, world!";
run;
options nonumber nodate;
ods rtf file="test.rtf" style=MyStyle;
proc report data=test;
run;
ods rtf close;
... View more
I am seeking urgent help as the issue impacting all SAS Studio users on our Viya 4 environment. Since 9:30AM EST today, users have been encountering an error message stating "ERROR: Insufficient disk space is full, or quota has been exceeded." or "ERROR: Insufficient space in file WORK.BDXFS124.DATA." Unable to run even simple steps like proc contents, or reading data from sashelp to work directory and this issue is causing significant disruption to our daily operations, as it prevents users from performing any task in sas studio and sometime we noticed "sas studio compute context" is keep on disconnecting.
Our SAS administrator verified the status of pods, and all are working fine and we are unable to identify what caused the issue all of a sudden. Unfortunately, the impact is even more critical as we have fully transitioned to SAS Studio and do not have access to Base SAS at this time and we depend on sas studio for our daily operatoins.
Given the severity of the problem and its impact on our daily operations, any guidance or solution you can provide would be greatly appreciated.
Please let me know if there are any immediate steps we can take to free up disk space or identify the cause of the quota being exceeded. We are available to discuss this matter further at your earliest convenience.
Sincerely,
Bhaskar
... View more
data tests;
input id $ test $ result $ ;
datalines;
XYZ001 ABC01A .
XYZ001 ABC01B NE
XYZ001 ABC01C NE
XYZ001 ABC02 6
XYZ001 ABC03 5
XYZ001 ABC04 1
XYZ001 ABC05 0
XYZ001 ABC06 .
XYZ001 ABC07 10
XYZ001 ABC08 6
XYZ002 ABC01A 2
XYZ002 ABC01B 1
XYZ002 ABC01C NE
XYZ002 ABC02 15
XYZ002 ABC03 9
XYZ002 ABC04 NE
XYZ002 ABC05 7
XYZ002 ABC06 6
XYZ002 ABC07 10
XYZ002 ABC08 9
XYZ003 ABC01A 6
XYZ003 ABC01B 4
XYZ003 ABC01C 6
XYZ003 ABC02 8
XYZ003 ABC03 9
;
RUN;
proc sql;
create table sub2 as
select id,
count(test) as missed_count,
case
when max(case when test = 'ABC01A' and result in ('NE', ' ') then 1 else 0 end) = 1
then 'Y'
else 'N'
end as test_01A
from tests
where result in ('NE', ' ')
group by id
having missed_count > 3;
quit; Hello all, I have dataset for test results and created a new dataset 'sub2' to summarize which id have more that 3 missed or 'NE' result, could anyone please help in updating this code to create a new column named 'missed' with values of test which are missing or NE and multiple test separated by ','? For example for in my current sub2 dataset I have XYZ001 id, for this id new column value would be ABC01A,ABC01B,ABC01C,ABC06 Thank you in advance.
... View more
I imported a csv file from my local computer to model studio and create a forecasting project, but an error message occur stated that my data specification could not be created. The message says: The input data has no valid candidates for the time variable. Specify a table with a column that has a valid date format. How do i solve this issue? My csv file has the date column but somehow it was not recognized by SAS, instead it recognizes it as varcar, how can I change this?
... View more
proc sql; create table MostPopularRouterByState as select c.State, o.SKU, count(o.OrderID) as TotalOrders from DATA_ELE.ORDERS o inner join DATA_ELE.CUSTOMERS c on o.CustomerID = c.CustomerID group by c.State, o.SKU having calculated TotalOrders = (select max(calculated TotalOrders) from DATA_ELE.ORDERS o2 inner join DATA_ELE.CUSTOMERS c2 on o2.CustomerID = c2.CustomerID 77 where c.State = c2.State 78 group by c2.State, o2.SKU) 79 order by c.State, TotalOrders desc; ERROR: Summary functions nested in this way are not supported.
... View more