Manipulating Data in Base SAS® Part 3 – Deduplicate
Recent Library Articles
Recently in the SAS Community Library: Duplicates in data can badly skew the results of an analysis. @SASJedi demonstrates data deduplication using PROC SORT with the NODUPKEY, OUT=, and DUPOUT= options and PROC SQL and PROC FedSQL
Hello! I have got a question about fitting Cox regression model to obs with different measurements with the same ID. I’m new to SAS so I don’t know exactly how to fix this problem. I have got a dataset of 471 obs. 53 out of them have got new measurements but the id of obs are the same. I tried to use this code but the results are a bit weird for me. How could I make this thing work? Is there any way to use random statement in Cox model?
... View more
Hi all, I have 4 datasets as below and requirement for the table want are : - Ignore col1 values which are not common for all 4 tables - join all col1 col2 col3 col4 values in the want table to show all different values for col2 in each table. Table 1 col1 col2 1 yes 2 yes 3 yes 4 yes 5 Table 2 col1 col2 1 yes 2 no1 3 yes 4 no1 Table 3 col1 col2 1 yes 2 no2 3 yes 4 no2 Table 4 col1 col2 1 yes 2 no3 3 yes 4 no3 table want col1 col2 col3 col4 col5 1 yes yes yes yes 2 yes no1 no2 no3 3 yes yes yes yes 4 yes no1 no2 no3 Thanks in advance kajal
... View more
proc sql;
create table t1
as
select *
from
t2
where
name like 'PNB%'
and rn in
(select distinct rn from
t4)
and
datepart(DATE) <= '7Dec2002:00:00:00'd
;quit; I have a very big dataset and its taking forever to run and many times connections disrupts and I need to wait for a long again. can you please suggest a better way to do it. Here table T2 is like very big taking almost an hour to complete the query if everything goes well or need to restart many times . Thank you in advance kajal
... View more
Hi SAS Communities,
We'll be soon migrating to SAS VIYA 4 any tips regarding logging?
Where can we see the logs for the services now is it still on the default location /opt/sas/viya/config/var/logs?
... View more