Thank you for your quick answer, Tom! This what I supposed: with the null put I continue writing on the line that is being held by a previous PUT statement with a trailing @ (in case of nodigit values on the beginnig of line). Yes, thank you, I see, I'm going to replace length(scan(line,1,','))>12 by length(scan(line,1,','))>3, beacause I have a shorter words in other files. Sorry for disturbing with all my questions :slightly_smiling_face: Have a nice day! Marie
... View more
The data appears to contain values with an encoding the session is unable to display. Try starting a SAS session with Unicode Support enabled. In Windows there should be an icon for that in the SAS group.
... View more
Glad it helped.
There are always many options and you have to consider if the retained solution always
do what you expect. For instance, if your data contains products as "AAPEZZGBTT" they will match
the condition 'like "%PE%GB%". If you want to check precisely that the string is "PE" followed by
two digits followed by "GB", you can use a regexp as follows :
data want;
set have;
where prxmatch("/^PE\d{2}GB$/", trim(cd_produit));
run;
... View more
The VNEXT call routine will iterate through the PDV variable names. The first call will return the first variable name.
Use the returned variable name in a DOSUBL function call that runs a 'slicing' step.
Example:
data _null_;
if 0 then set sashelp.cars;
length _name_ $32;
call vnext(_name_);
rc = dosubl("data want; set sashelp.cars (keep=" || trim(_name_) || ");");
stop;
run;
... View more
Hi @SASdevAnneMarie ,
Here is a link to a topic in the latest user's guide for scheduling a project or process flow:
Scheduling Projects and Process Flows
I don't know what version you are running, but the steps should be similar in earlier versions.
Does this help you get started?
thanks,
Jennifer
... View more
Hi MarieT and Cynthia, Good question and testing on new ODS WORD. A lot of things can go wrong when an RTF file does not open. Sometimes it's your input data. For example, if you have a long string characters with unpaired {} or some other strange character that causes some other character lost. Does anyone know how many columns SAS ODS RTF proc report support? Older version of Word supports 31, and the new Word supports 63. See the attached. Best Regards Jianmin Long
... View more
