About Mazi

Mazi

You’re welcome!

Mazi

data lab; infile datalines truncover ; input LABORATORY_INFORMATION $32767.; datalines; Local ID: OBS456571123N01Date Received by PH: 01/15/2020Specimen Collection Date: 01/06/2020ELR Indicator:YResulted Test: RPR Qualitative StatCoded Result: Numeric Result: Text Result: Reactive *Comments: Local ID: OBS45657123IN01Date Received by PH: 01/15/2020Specimen Collection Date: 01/07/2020ELR Indicator:YResulted Test: RPR Quantitative StatCoded Result: Numeric Result: Text Result: 1:64Comments: Local ID: OB456874123N01Date Received by PH: 03/13/2020Specimen Collection Date: 01/05/2020ELR Indicator:YResulted Test: FTACoded Result: Numeric Result: Text Result: Reactive *Comments: ; run; data lab2; set lab; array columns [9] $200 localid datercdbyph speccolldt elr_ind resultedtest codedresult numericresult textresults comments; loop: start=1; do index=1 to 9; temp1 = find(laboratory_information, "", start); temp2 = find(laboratory_information, "", temp1); columns[index] = substr(laboratory_information, temp1 + 4, temp2 - temp1 - 4); start=temp2; end; output; call missing(of columns[*]); if length(laboratory_information) > (start + 6) then do; laboratory_information = substr(laboratory_information, start + 6); goto loop; end; run; Appologies, I didnt realise it was one row. How about this?

Mazi

data lab; infile datalines truncover ; input LABORATORY_INFORMATION $500.; datalines; Local ID: OBS456571123N01Date Received by PH: 01/15/2020Specimen Collection Date: 01/06/2020ELR Indicator:YResulted Test: RPR Qualitative StatCoded Result: Numeric Result: Text Result: Reactive *Comments: Local ID: OBS45657123IN01Date Received by PH: 01/15/2020Specimen Collection Date: 01/07/2020ELR Indicator:YResulted Test: RPR Quantitative StatCoded Result: Numeric Result: Text Result: 1:64Comments: Local ID: OB456874123N01Date Received by PH: 03/13/2020Specimen Collection Date: 01/05/2020ELR Indicator:YResulted Test: FTACoded Result: Numeric Result: Text Result: Reactive *Comments: ; run; data lab2; set lab; start=1; array columns [9] $200 localid datercdbyph speccolldt elr_ind resultedtest codedresult numericresult textresults comments; do index=1 to 9; temp1 = find(laboratory_information, "", start); temp2 = find(laboratory_information, "", temp1); columns[index] = substr(laboratory_information, temp1 + 4, temp2 - temp1 - 4); start=temp2; end; run; Can you give this a try?

Mazi

Hi, if you set options validvarname=v7; SAS will automatically replace spaces in variable names with underscores. Additionally, its best to create sample data using a datalines statement showing the data you have, and another dataset, showing what you expect to get help quickly. Most users are reluctant to download excel files due to viruses and the like.

Mazi

cas mycas; libname casuser cas caslib=casuser; proc casutil; load data=sashelp.cars outcaslib="casuser" casOut="cars" replace; load data=sashelp.class outcaslib="casuser" casOut="class" replace; load data=sashelp.baseball outcaslib="casuser" casOut="baseball" replace; run; proc cas; table.tableinfo result=rc /caslib="casuser"; fragment=';'; do table over rc["TableInfo"][,"Name"]; table.tabledetails result=result/name=table caslib="casuser"; saveresult result caslib="casuser" casout=table; code="data casuser.allResults"||fragment|| "set casuser."||table||";length Data varchar(100);Data='"||table||"';run;"; datastep.runcode/code=code; fragment='(append=yes);'; end; quit; Give this a try

Mazi

Hi, Yes - We can use the saveresult statement to do this. Do you want them appended to one table or a different table for each?

Mazi

proc casutil; load data=sashelp.cars outcaslib="casuser" casOut="cars" replace; load data=sashelp.class outcaslib="casuser" casOut="class" replace; load data=sashelp.baseball outcaslib="casuser" casOut="baseball" replace; run; proc cas; table.tableinfo result=rc /caslib="casuser"; do table over rc["TableInfo"][,"Name"]; table.tabledetails /name=table caslib="casuser"; end; quit; Can you try this?

Mazi · ‎04-18-2024

@susantrueman, Thank you very much for your help with this. It is truly appreciated.

Mazi · ‎04-18-2024

Good day, I had a question relating to SAS VI 10.8 on Viya 3.5. Is it possible to delete an object (internal case) that has a relationship with other entities? The reason we want to do this is because we have a case that is "duplicated" and was accidentally logged twice. I tried adding the delete toolbar object, but received an error stating that this object could not be deleted as it has relationships with other entities. Thanks, Mazi

Mazi · ‎04-08-2024

@Patrick, Agreed. I am also not entirely sure I understand the requirement/purpose here. My thinking was to have several self joins and finally transpose the columns to have them as required.

Mazi · ‎04-08-2024

@Patrick , I was thinking the same. A hashobject would be easier in my opinion. Otherwise with SQL I am thinking of joining the table with itself

Mazi · ‎04-06-2024

data class; set sashelp.class; length agegr1 $7; if age<13 then agegr1 = '<13'; else if age < 15 then agegr1 = '13-<15'; else agegr1='>=15'; run; proc sort data=class; by agegr1; run; data final; set class; by agegr1; if first.agegr1 then page+1; run; ods rtf file="./temp.rtf" style=RTFStyle; PROC REPORT data=final headline headskip nowd split="~" spacing=0 missing style(header) = {vjust = middle font_size = 8pt font_face="Courier New"} style(column) = {just=l vjust = middle font_size = 8pt font_face="Courier New"} style(report) = {rules = groups frame = void cellpadding = 1 font_face="Courier New"} style(lines) = {font_size = 8pt} ; column page name sex ("^S={borderbottomcolor=black borderbottomwidth=1} Baseline Characteristics" age height weight) agegr1; define name / order order = internal style(header)=[just=l] style(column)=[just=l cellwidth=20%]; define page / order order = internal noprint; define agegr1 / noprint; define sex / style(header)=[just=l] style(column)=[just = l cellwidth=19%]; define age /style(column) = {just=c cellwidth = 20%}; define height / style(column) = {just=c cellwidth = 20%}; define weight / style(column) = {just=c cellwidth = 20%}; compute before _page_ /style=[borderbottomcolor=black borderbottomwidth=1]; len=length(agegr1); line @1 "Age Group: " agegr1 $varying.len; endcomp; break after page / page; run; ods rtf close; Can you try adding a style to the compute before _page_ block?

Mazi · ‎04-04-2024

Apologies, I got those mixed up.

Mazi · ‎04-04-2024

When executing in CAS data belonging to the same by group are automatically sent to the same node, therefore sorting is not required. If you have more nested levels, that is sorted within that node.

Mazi · ‎04-04-2024

@alisio_meneses , Have you tried the deduplicate action in PROC CAS ? data example; set sashelp.class; output; output; run; proc casutil; droptable casdata="example" incaslib="casuser" quiet; load data=work.example outcaslib="casuser" casout="example" replace; run; proc cas; deduplication.deduplicate / table = {caslib="casuser", name="example", groupBy={"name"}} noDuplicateKeys=true casOut={name="deduplicated", caslib="casuser", replace=true}; quit;

Online Status	Online
Date Last Visited	19m ago

Re: How do I change multiple lab results in one variable into separate...

Re: How do I change multiple lab results in one variable into separate...

Re: How do I change multiple lab results in one variable into separate...

Re: How do I change multiple lab results in one variable into separate...

Re: size of tables in CAS libraries

Re: size of tables in CAS libraries

Re: size of tables in CAS libraries

Re: Is it possible to delete an internal object that has a relationshi...

Is it possible to delete an internal object that has a relationship wi...

Re: Want to write sql query to get related party account details

Re: How do I change multiple lab results in one variable into separate...

Re: size of tables in CAS libraries

Re: Find Min and Max of five variables with min above zero for each ro...

Re: How do I pull max of multiple columns in SAS?

Re: Want to write sql query to get related party account details

Re: How do I change multiple lab results in one variable into separate...

Re: How to perform key Deduplication of CAS Tables using Hash Tables.

Re: How to perform key Deduplication of CAS Tables using Hash Tables.

Re: How to find a date interval with a specific days

Re: How to flag the last AVALC = 'Y' record prior to this AVALC='N' re...

Re: How do I change multiple lab results in one variable into separate...

Re: How do I change multiple lab results in one variable into separate...

Re: How do I change multiple lab results in one variable into separate...

Re: How do I change multiple lab results in one variable into separate...

Re: size of tables in CAS libraries

Re: size of tables in CAS libraries

Re: size of tables in CAS libraries

Re: Is it possible to delete an internal object that has a relationshi...

Is it possible to delete an internal object that has a relationship wi...

Re: Want to write sql query to get related party account details

Re: Want to write sql query to get related party account details

Re: How to add a topline for the table when table has two rows of head...

Re: How to perform key Deduplication of CAS Tables using Hash Tables.

Re: How to perform key Deduplication of CAS Tables using Hash Tables.

Re: How to perform key Deduplication of CAS Tables using Hash Tables.