About ajulio4

ajulio4 · ‎07-30-2025

Hello all, I want to modyfy the length of a column of my table in a casli without changing the order oaf variables.

ajulio4 · ‎05-19-2025

Hello, Thks you for the reply. On my dashbord i have crosstable with columns and line like this : And i would like to have in avariable, the sum of the distinct values of my columns Taille totale du FS(Go)

ajulio4 · ‎05-16-2025

In my reporting, i have some variables. i put table oject on my reporting with a column XX, and i wand to have anytime, the sum of the distinct value i have for my column in the table oject. Can someone helpe me please ? thks

ajulio4 · ‎10-27-2024

Thks so much

ajulio4 · ‎10-25-2024

Hello , I have an issue can someone help me. I have a colonne value like this : var ="USERNUM1, Counter{F}Compteur , USERTEXT1, Trigram{F}Trigramme ,ALL~All{F}Tous GBR~GBR{F}GBR ITA~ITA{F}ITA" Notice that after the commaas, i have tabulate. how can i have as result : var = "USERNUM1,Counter{F}Compteur,USERTEXT1,Trigram{F}Trigramme,ALL~All{F}Tous GBR~GBR{F}GBR ITA~ITA{F}ITA"

ajulio4 · ‎10-03-2024

am woorkin on viya 3.5 proc cas; table.update / table={caslib='Public',name="&reftable",where=%tslit(%str( upcase(fileref)=upcase("&form_fileref") and upcase(mail)=upcase("&form_mail") and upcase(destination)=upcase("&form_caslib") and upcase(tableout)=upcase("&form_table") ))} set={ {var="actif", value="&value."} }; run; quit;

ajulio4 · ‎10-03-2024

Hello, Please i have an erro when updating a tabl in CAS with proc cas ERROR: A collective operation failed because a conflicting collective operation was started on another node ERROR: Fatal error, action aborted: A previous operation failed due to mismatched operations across the grid. Further operations can only be performed after the communicator is repaired. ERROR: A previous operation failed due to mismatched operations across the grid. Further operations can only be performed after the communicator is repaired. ERROR: The action stopped due to errors. ERROR: A collective operation failed because a conflicting collective operation was started on another node ERROR: Fatal error, action aborted: A previous operation failed due to mismatched operations across the grid. Further operations can only be performed after the communicator is repaired. ERROR: A previous operation failed due to mismatched operations across the grid. Further operations can only be performed after the communicator is repaired. ERROR: The action stopped due to errors. Someone can tell me what happening with my code and why my request not ok Thks

ajulio4 · ‎05-21-2024

here is my problem : data montest; format tp1 time8. ; tp1= 109320; run; proc fedsql; create table montest2 as select * from montest ; quit;

ajulio4 · ‎05-14-2024

Please can someone help me. I have SAS 9 table with colonne TPS whixh specify the duration. Eg i can have in this variable modality like 30:22:00. After chargin this table in my CASLIB, for the same record this variable shows 6:22:00. Seems like SAS ignore the 24 hours . After 24hours SAS set to null the duration. How can i find issue to this problem ? Thks

ajulio4 · ‎02-20-2024

Ok.. Thks so much

ajulio4 · ‎02-19-2024

for example my variable is this form %let var = ABCD_GROUP,OPEGROU,AWSAMZ,HOMJACGFF,YEDD_DE,UEUEDD,HDHDHD_GGGGG,OPERATOR_DATA,INVOICE_MKG,GRFSDD_MKT,OFFICE_DIREC,AMZ_RECRUIT,ALL_EVENT,REZO_SAS,AHAHEHEHDH_TERR ; and in the Html <td> i want this variaable to be display this way : intead of list form separed by comma : ABCD_GROUP OPEGROU AWSAMZ AWSAMZ HOMJACGFF YEDD_DE UEUEDD HDHDHD_GGGGG OPERATOR_DATA INVOICE_MKG GRFSDD_MKT OFFICE_DIREC AMZ_RECRUIT ALL_EVENT REZO_SAS AHAHEHEHDH_TERR

ajulio4 · ‎02-19-2024

Hello, I have problem on Viya with something i want to do. Can someone tell mi if its posible and then tell me how i can do it. am filling my html table with my data. i have this for example : data _null_; file _webout; set inputData; put '<tr>'; put '<td class="tabledit-view-mode" style="cursor: pointer;">'; put '<span>' Name; put '</span>'; put '</td>'; put '<td class="tabledit-view-mode" style="cursor: pointer;">'; put '<span >' ??????????????; put '</span>'; put '</td>'; put '<tr>'; run; My problem is intead of putting ???? i want to put a variable which is too long and i have to display this variable in this way n=0; do until(n>=countw("columnVar",",")); grp = scan("columnVar",n); put grp; n+1; end; am lookin for a way to display my variable in the html <td> and </td>

ajulio4 · ‎02-16-2024

Hello. thks you so much. It helps and it works

ajulio4 · ‎02-15-2024

Hello, i have a macro variable in numeric. like &jour = 23040, In CAS i try to find line where dateColumn > &jour bu i have the error : ERROR: Operator is not unique: DATE > INTEGER Can someone help me plz.

ajulio4 · ‎12-01-2022

i want 252 colums in my table outpu so i expect "251 ; " i for my record

Online Status	Offline
Date Last Visited	‎09-09-2025 09:02 AM

Modify column length of table in a caslib

Re: SAS VA i want to have the sum of distinct value of a column

SAS VA i want to have the sum of distinct value of a column

Re: data transoding

data transoding

Re: update table in CAS

update table in CAS

Re: problem with time duration in caslib table

problem with time duration in caslib table

Re: Fill html table whith sas data on Viya

Re: Modify column length of table in a caslib

Re: data transoding

Re: Fill html table whith sas data on Viya

Re: importing csv file

Re: update table in CAS

Re: Fill html table whith sas data on Viya

Re: fedsql request

Modify column length of table in a caslib

Re: SAS VA i want to have the sum of distinct value of a column

SAS VA i want to have the sum of distinct value of a column

Re: data transoding

data transoding

Re: update table in CAS

update table in CAS

Re: problem with time duration in caslib table

problem with time duration in caslib table

Re: Fill html table whith sas data on Viya

Re: Fill html table whith sas data on Viya

Fill html table whith sas data on Viya

Re: fedsql request

fedsql request

Re: Import file with data infile and ignore CR in middle of lines