About kaitlineolson7

kaitlineolson7 · ‎12-08-2020

Hi all! If I were to create a macro variable like below, when I run %PUT &=Variable, it simply returns 15+85. Is there a way to evaluate the equation and return 100 instead? %LET Variable = 15+85; Thank you!

kaitlineolson7 · ‎12-08-2020

Hi, It looks like 'Test' in your code should be replaced with Statistic, as that is where the Chi-Square option is held. Using DEFINE, as shown below, should solve your problem! PROC REPORT DATA = dataset.ChiSqResults; COLUMN Statistic ("Statistical Results" DF Value Prob ); DEFINE Statistic / 'Test'; DEFINE Prob / 'P-Value' FORMAT = 4.2 ; DEFINE Value / FORMAT = 4.2; FOOTNOTE "Created by HS"; RUN;

kaitlineolson7 · ‎11-17-2020

Also, to better explain how the arrays are being used in the do loop -- If i=1, Minutes = Mins{Mon} = 51, 43, 48, 32 (one result associated with each person) and Day = Weekday{1} = 1 (repeated for each person), as shown below. The do loop repeats for 2 and 3 and therefore we are left with 12 observations, as desired.

kaitlineolson7 · ‎11-17-2020

Hi Amanda, I did something similar to the above post but used a second array -- DATA WORK.data1; SET WORK.data; KEEP Name Age Day Minutes; ARRAY Weekday {3} _TEMPORARY_ (1,2,3); ARRAY Mins {3} Mon -- Wed; DO i = 1 TO DIM(Mins); Day = Weekday{i}; Minutes = Mins{i}; OUTPUT WORK.data2; END; RUN; Hope this helps! Kaitlin

kaitlineolson7 · ‎11-17-2020

Hi all, I had a question about transposing a dataset to wide format when the dataset has missing data. Here is the dataset I created and the code I was using to try to transpose the data: DATA WORK.data1; INFILE DATALINES DELIMITER=','; INPUT Type $ Year HtFt; DATALINES; ; PROC TRANSPOSE DATA = WORK.data1 OUT = WORK.data2 (DROP = _NAME_ RENAME = (COL1 = Yr2009 COL2 = Yr2010 COL3 = Yr2011 COL4 = Yr2012) ); VAR HtFt; BY Type; RUN; Here was the output: The values for Maple should start at Yr2010 and the missing value should be for Yr2009 and I'm curious as to how I could remedy this? Thank you so much, Kaitlin

Online Status	Offline
Date Last Visited	‎07-30-2023 07:50 PM

Using arithmetic in a macro variable

Re: Adding to PROC REPORT

Re: Transpose using Data Step

Re: Transpose using Data Step

PROC TRANSPOSE to wide format

Using arithmetic in a macro variable

Re: Adding to PROC REPORT

Re: Transpose using Data Step

Re: Transpose using Data Step

PROC TRANSPOSE to wide format