Hi, I want to reproduce this situation:  Text Object Example – Using a New Data Item that I see in this library New Max/Min Aggregate Measure for Date and Datetime Formats!  but I can't format the new value in date format (point 5. Change the Format to the desired date format)   Can you help me? Thanks a lot Luca ... View more

Hi, I have this code:   %let path=prova/qa/luca; data _null_; if findw("&path.",'/qa/','/')=1 then run_build = 1; else if findw("&path.",'/prod/','/')=1 then run_build = 1; else run_build = 0; call symputx('run_build',run_build); run; %put &=run_build; I have to search exactly '/qa/' or '/prod/' and then I expect 1 as a result of run_build, but I get 0. How can I do it?   Thanks Luca ... View more

Hello, I would like to be able to read the attachments (zipper format) of emails that arrived at a mailbox. Is there any SAS procedure that can allow me to do this?   Thank you Luca ... View more

Hi! I would like to know if there is a way to select a part of the text in a column and be able to copy it (without having to download the table in xlsx format). Now I use List Table Object.   Thanks  Luca ... View more

Hello, I wanted to export a SAS table to xlsx and define it inside a table. In xlsx it would be defined here: Thanks Luca ... View more

Hi. I wanted to reproduce this excel result on VA but I can't manage the colors. Is it possible?   Thanks Luca ... View more

Hi,  I have this code that works:   %let caslib = AAAA; %let libname=SASHELP; %let table=CARS; cas mysess sessopts=(caslib=&caslib.); caslib _ALL_ assign; /* load */ proc casutil; load data=&libname..&table. outcaslib="&caslib." casout="&table." REPLACE; run; proc cas; loadactionset / actionSet="dataDiscovery"; run; dataDiscovery.profile result=r / table={name="&table."}, casOut={name="Profilazione", replace=true}; run;   but if i use this it gives me an error:   %let caslib = AAAA; %let libname=SASHELP; %let table=CARS; cas; libname &caslib. cas caslib=&caslib.; /* load */ proc casutil; load data=&libname..&table. outcaslib="&caslib." casout="&table." REPLACE; run; proc cas; loadactionset / actionSet="dataDiscovery"; run; dataDiscovery.profile result=r / table={name="&table."}, casOut={name="Profilazione", replace=true}; run;     I just changed the bold part. Instead of allocating all CAS I allocate only one. The error are: ERROR: Could not connect to the Hadoop cluster. ERROR: Table 'CARS' could not be loaded. ERROR: Failure opening table 'CARS': A table could not be loaded. ERROR: The action stopped due to errors. Thanks Luca   ... View more