Home

Richardvan_tHoff

I want to create a master detail subdetail report within SAS BASE (proc report). You woud have a master row with colums. The master has detail rows with different columns and detail row also subdetail rows with comments. I don't want all the columns master,detail, subdetail on one row and master, detail, subdetail should be on the same page. The result will be converted to pdf. The output would look something like the below example: Procesname Start date end date Detail info ----------------------------------------------------------------------------------------- Walking 01-01-2024 10-04-2024 I walk very slow Subproces start date end data Start place end place ----------------------------------------------------------------------------------------------------- Part 1 01-1-2024 10-01-2024 New York Amsterdam Comments -------------------------------------------------------------------------------------------- I started very well The walk was nice Subproces start date end data Start place end place ----------------------------------------------------------------------------------------------------- Part 2 10-1-2024 24-01-2024 Amsterdam Berlin Comments -------------------------------------------------------------------------------------------- Was perfect swimming 10-06-2024 10-07-2024 I love swimming detail subdetail

kyle234

I have a library that I want to subset to only include tables that are dbms_memtype='table'. Thank you!

victor1893

Hi, I have a table from which I want to store in a macro variable all columns that contain a specific value. For example: data have; input abc def ghi jkl 8.; datalines; 1 4 2 3 6 99 0 8 3 99 6 5 2 4 0 99 ; run; Here I would like to obtain all columns which contain the value 99: def, jkl.

JAE2019

Can SAS Viya 4 be integrated with Splunk?

angel17th

Hi, I would like to ask for your help regarding the issue on subject. I already tried the solution provided in the https://communities.sas.com/t5/SAS-Programming/Read-in-raw-pipe-enclosed-data-separated-by-commas-SAS-9-4/td-p/552481 solved by @Tom but the records exceeding the 257 length are truncated causing for misaligned imported records. I've tried changing the lrecl value from 1 to 32767 and the char1 to char32767 but it still doesn't solved the issue with truncation. Another issue with the raw data is that the empty records are not pipe enclosed. Hope that someone can help me with this. Thanks and advance!