Only to download the tool and install the plugins you need internet access, this can be done on any system.
Once you have the sas-viya CLI and the plugins then you transfer the tool and the plugins to your machine without internet access.
See also here Advanced: Set Up a Shared Location for more information.
... View more
Instead of using undocumented API's, I suggest to use the sas-viya transfer plugin. See some examples in the doc https://go.documentation.sas.com/doc/en/sasadmincdc/v_029/calcontentmig3x/n0u4qkc837891vn1w8pd2rbqaxzb.htm
Also have a look at this https://communities.sas.com/t5/SAS-Communities-Library/You-CAN-take-it-with-you-Saving-SAS-Viya-Content/ta-p/798055
... View more
I guess this is a case for using regular expressions. Have a look at the code below. I am not regular expression expert and there might be easier ways of doing this.
data have;
infile cards truncover;
input
text $char256.
;
re1 = prxparse('/([\s"|"\A][^"]*"\s)/');
qt1 = prxmatch(re1, text);
re2 = prxparse("/([\s'|'\A][^']*'\s)/");
qt2 = prxmatch(re2, text);
if qt1 then do;
value = prxposn(re1, 1, text);
end;
if qt2 then do;
value = prxposn(re2, 1, text);
end;
value2 = dequote(value);
cards;
"Tech Data1"
'Tech Data2' Company
abc "Tech Data" Company
def 'WOW' Company
John's & Gary's world
abc
123 "O'Reilly" here
456 'O"Reilly' here
;
... View more
Have a look at the doc for SAVERESULTS, it states that it will save a result table. Now the the table.tableExists action does not return a result table. So you can not use SAVERESULTS, unless you create your own CASL table with the content you want to save. Do you need the value whether a CAS table exists in a macro variable, then have a look at the CASL SYMPUTX function.
... View more
ODS TEXT is needed so we actually create some content in the region. The options and footnote statement are not needed for the example. Setting papersize, orientation and margins do affect the result. To position something using ODS LAYOUT ABSOLUTE I recommend to the set the proper margins. Then the X= and Y= will be measured from the margins settings.
... View more
Give this code below a go, if it works fine. Otherwise we might need some more coding. The image will automatically scale to the size of the region you define. The bordercolor and borderwidth are not really need, it is just to show the size of the region. I would also recommend to only use the ODS PDF desination and no other.
options orientation=portrait
papersize=A4
nodate
topmargin=.001in
bottommargin=.001in
leftmargin=.001in
rightmargin=.001in;
ods noproctitle;
ods escapechar="^";
title;
footnote;
ods pdf file="c:\temp\sas2pdf_example.pdf";
ods layout start width = 19cm height = 28cm ;
ods region y=2cm x=2cm width=6cm;
ods text="Some Random Information:";
ods region y=4cm x=2cm width=2cm height=2cm style={bordercolor=red borderwidth=10px backgroundimage="c:\temp\bird.jpg" };
ods text=" ";
ods layout end;
ods pdf close;
.
... View more
Are you looking for something like this? The INTNX function can give you the first/last date of a given period.
data want;
do month = 1 to 12;
someDate = mdy(month, 15, 2022);
startDay = intnx("month", someDate, 0, "B");
endDay = intnx("month", someDate, 0, "E");
output;
end;
format
somedate date9.
startDay endDay weekdate.
;
run;
proc print data=want noobs;
run;
... View more
Have a look here https://go.documentation.sas.com/doc/en/calcdc/3.5/calsrvpgm/n00003viyaprgmsrvs00000admin.htm#n03018viyaservers000000admin
... View more
I can see that if the condition is false you return missing, can you show what the preview button displays, when you do the calculation d1 - d2, maybe all the values are missing
... View more
Please show the expression you are using to calculate the difference. Also a screenshot from the two durations with the properties would help
... View more
A sas7bdat file is a SAS data set. In oder to access it one needs a SAS libref pointing to the directory where this file is stored. A LIBNAME statement can not point to a folder in SAS Content. So you need to make a binary copy of the file. see the code below for an example. Please be aware that the value used for LRECL= must be big enough to accommodate the size of the file.
/*
* make a binary copy of the file from SAS Content
* to the directory the work library is pointing to
*/
%let lrecl= %eval(1024 * 1024 * 1024 -1 );
options msglevel=i;
filename src filesrvc folderpath='/Public' name="cars.sas7bdat" recfm=n lrecl=&lrecl;
filename dest "%sysfunc(pathname(work))/newcars.sas7bdat" recfm=n lrecl=&lrecl;
data _null_;
rc = fcopy("src", "dest");
run;
data newcars2;
set work.newcars;
run;
... View more
You can achieve the percent with 1 decimal by calculating the values with new dataitems, this will allow you to specify the format you want to use.
Here is a screenshot comparing the two methods.
The example uses sashelp.cars and the following dataitems:
hp by type:
AggregateTable(_Sum_, Table(_Sum_, Fixed('Type'n), 'Horsepower'n))
hp aggr:
Sum [_ByGroup_] ('Horsepower'n)
hp aggr / hp by type %:
'hp aggr'n / 'hp by type'n
The barchart to the left uses the "Normalize groups to 100%"
The barchart to the right uses the calculated dataitem "hp aggr / hp by type %"
... View more
