I'm trying to find the quartiles for a variable in my data set, then create a new variable that takes different values depending on the quartile.  4 if the percentage for  var1 is greater than the third quartile 3 if the percentage for  var1 is between the median & the third quartile 2 if the percentage for  var1 is between the first quartile & the median 1 if the percentage for  var1 is lower than the first quartile . ( missing value) if the percentage is not given Format the new_var to name the groups “high”, “med-high”, “med-low”, and “low”, respectively. Add a label to the variable as well.   my data looks like this: data mydata; input var1 income location percentage;  1 500 ny 100% 2 400 nj 90% 3 400 ma 80% 4 800 va 80% 5 500 ca 75% 6 600 ma 70% 7 900 wv 60% 8 1000 ny 50% 9 100 pa 40% 10 760 wy 20%   ... View more

I am trying to merge the 2 datasets by var1 and create 3 datasets outputs, one that has var1 in both, one that has var1 with no income, one that has var1 with no grad_year the data looks like this:   data mydata; input var1 income; datalines; 1 400 2 500 3 500 7 600 8 900 9 1000 run;   data mydata2; var1 grad_year 1 2018 2 2019 4 2020  5 2019  6 2017 11 2019   merging is not an issue for me. I think i should use the 'if then output' statement for this but i could not figure it out. Thanks ... View more

How do i output data with one single observation(01,04 in the following)?   data have; input ID $ date date9. number; format date date9.; datalines; 01 01jan2020 2 03 05jan2020 11 05 14jan2019 9 02 01jan2020 5 02 14jan2021 4 02 22jan2021 12 02 21jan2021 1 03 13feb2020 21 04 02feb2020 12 ; run; ... View more

I'm new to sas, and trying to learn. In an exercise I'm doing, I'm given ID, date, suger level in my data. i am asked to Output all observations after the first for each person to a dataset. Do i use an if then else statement?  Also, how do i output all observations for patients with only one record to a dataset Here is my code for first which i figured. I just can not figure out the code for observations after the first:   proc import datafile='patient2.xlsx' dbms=xlsx replace out=patients; sheet="Sheet1"; getnames=yes; proc sort data=patients; by patient date; run; data patientsObs; set patients; by patient Date; if first.patient then output; rename suger = firstobs; proc print data=patientsObs; run; ... View more