The following data is given and sorted by id and date. I would like to find out how many days lie between data entries of class A and of B within an id creating a new variable called ‘days_diff’. The goal is to be able to calculate if the difference in days exceeds a predefined… Read More calculating time periods between specific data entries
the following data structure is given: ID CASE VALUE DUMMY 123 4736 E10 1 123 1254 N65 0 123 0997 E11 1 123 7655 x 0 987 1234 x 0 987 6376 E10 1 987 0980 E18 0 I want to know: How can i create a new variable that includes if someone actually has… Read More SAS code to identify different values in multiple rows according to one subject
I have a dataset with 20 variables that all start with date_, that represent the date of a particular procedure. I wish to use an arrays and do to create 20 new variables that have the same name, except the date_ is replaced with time_, and is equal to the number of days between the… Read More SAS: create new variables from array
I have table in SAS like below: data type: ID – numeric TYPE – character ID TYPE 111 {"Top":10} 222 {"abC":"false","Top":111, "aa":5} 333 {"Top":15.2} … … And I need to create new column "COL1" base on column "TYPE" where I need to extract value which is after character "Top": So I need something like below:… Read More How to extract some value from character column in PROC SQL in SAS Enterprise Guide?
I am obtaining values from two tables. When I run the subquery in its own PROC SQL statement in SAS, it runs fine, with the count of citations for each ID. When I input the subquery into my SELECT outer query, it gives me ERROR: Subquery evaluated to more than one row. I am having… Read More How is my SQL subquery evaluating to more than one row? When run independently, it works fine, but doesn't work in a SELECT subquery
I need to change sas code into PostgreSQL. But I couldn’t understand this code. Please help me to translate following code into SQL code. data fc_action_v1; set action_targets; Region_mod = upcase(region); rename ‘2nd_Item_nr’n = Prodnumber; run; Is this above sas code equivalent to following sql code? create table data fc_action_v1 as select region_mod as region,… Read More Sas to Postgres Migration
suppose to have the following: ID Rep Year 0001 exA 2015 0001 exA 2015 0002 exA 2015 0002 exB 2015 0002 exA 2015 0002 exC 2015 0003 exC 2016 0003 exA 2016 0003 exD 2016 0003 exA 2016 ….. … …. is there a way to subset IDs based on the appearance of exA in… Read More Subset records based on the occurrence of one observation but also additional ones
I’ve got some data in the form: file_date | segment |grade | volume 30Jun2017 | 1 | A0 | 1000 31Jul2017 | 1 | A0 | 542 31Aug2017 | 1 | A0 | 4863 . . I want to transpose this so that it’s in the form: grade | segment | 30Jun2017 | 31Jul2017 |… Read More SAS, proc transpose without blank spaces
I would like to create a new table with all tables contained within a library and the variables within each of those tables. I know I can use something like the below to get the table name but I cant find much on getting each variable. I have multiple libraries and each has potentially hundreds… Read More SAS – Can I create a table of all table names within a library and then all variables within those tables?
For example I want to output only the first 5 observations in the table CARS which satisfies the WHERE statement that Horsepower is greater than 265. DATA test(obs=5); SET SASHELP.CARS; WHERE Horsepower > 265; RUN; The above doesn’t work. This seems very simple but I’m not sure how to achieve what I want here. >Solution… Read More How can I output a certain number of observations satisfying a where statement in SAS