Have a look at the code below. It shows how to determine the "type" of record and process it accordingly.
See also Testing a Condition Before Creating an Observation
data want;
infile cards truncover;
/*
* define variables
*/
length
type $ 2
name $ 25
line $ 80
;
/*
* read a record
* and keep it in the buffer, the @ at the end
*/
input
@1 type $2.
@
;
/*
* check for type of record, the logic may vary depending
* on the data
*
* if EW, then process detail
* else process "header"
*/
if type = "EW" then do;
input @1 line $80.;
output;
end;
else do;
retain name;
input @1 name $25.;
end;
datalines;
John,Doe
EW202207070053899 FOR RESOLUTION W260560364 JUNGE NAT POB 098 169644
EW202207070055230 FOR RESOLUTION W263027005 RACE NAT PPS 114 161087
EW202207070055230 FOR RESOLUTION W263027005 RACE NAT PPS 114 161087
Mitchelle, Stark
EW202205020079881 SEE NOTES W268135093 LEE SGB FAX 738 177390
EW202206270042457 FOR RESOLUTION W255586930 RIGGS NAT FAX 754 737493
EW202206270042457 FOR RESOLUTION W255586930 RIGGS NAT FAX 754 737493
EW202206270042457 FOR RESOLUTION W255586930 RIGGS NAT FAX 754 737493
EW202206270042457 FOR RESOLUTION W255586930 RIGGS NAT FAX 754 737493
;
... View more
Providing sample data and expected result will help in understanding what you want.
You can mock up something with sashelp.cars, this is available in every SAS installation.
In my experience when you use control objects on page or report level they will also filter aggregated data sources.
Also have a look at the AggregateCells operator, as this allows you to define a different bygroup for aggregation as is used on the object.
... View more
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
