About Greek

Greek · ‎12-02-2013

Briliant! Thank you!~

Greek · ‎12-02-2013

Good afternoon, I am often given frequency tables which I would like to expand into data sets, which are more easy to manipulate. Is there a procedure that I could use? For example, I would like to expand the frequency table below into the consequent data set. GIVEN Age Group Laid off Retained up to 40 2 5 40-49 1 3 DESIRED OUTCOME Age Group Employment Up to 40 Laid Off Up to 40 Laid Off Up to 40 Retained Up to 40 Retained Up to 40 Retained Up to 40 Retained Up to 40 Retained 40-49 Laid Off 40-49 Retained 40-49 Retained 40-49 Retained

Greek · ‎10-04-2013

Hello, I just spotted an error, which I don't know how to solve programmatically. I have the frequency table below and I wanted to create a pie for the major 5 car manufacturers and group the rest in the category named "other." I used the other=5 option but the resulting pie is not correct. The "other" category should be 24% and not 16%. By looking at the log, I realized that SAS ignored any observation that had a relative frequency less than 1%. Do you know why is it doing that? data cars; input make $ count percent; datalines; PLYMOUTH 1 0.0530786 SCION 1 0.0530786 SUBARU 1 0.0530786 VOLKSWAGEN 1 0.0530786 INFINITI 2 0.1061571 LINCOLN 2 0.1061571 ISUZU 4 0.2123142 OLDSMOBILE 7 0.3715499 GMC 14 0.7430998 HONDA 14 0.7430998 BUICK 16 0.8492569 MERCURY 19 1.0084926 MITSUBISHI 26 1.3800425 MAZDA 28 1.4861996 SUZUKI 30 1.5923567 TOYOTA 30 1.5923567 JEEP 38 2.0169851 HYUNDAI 47 2.4946921 SATURN 52 2.7600849 NISSAN 53 2.8131635 KIA 60 3.1847134 PONTIAC 122 6.4755839 CHRYSLER 261 13.8535032 FORD 283 15.0212314 DODGE 320 16.985138 CHEVROLET 452 23.9915074 run; ods html; proc gchart data=cars; pie make / freq=percent other=5; run; ods html close;

Greek · ‎10-01-2013

Awesome! Thank you

Greek · ‎10-01-2013

I would like to create a pie chart with data that exist in the following format. How can SAS do it? I have looked into the GChart procedure, but it looks like my data need to be in the format below the graph to be able to work... Any ideas? Data that I have: A B C 5 4 6 Chart that I need: Data that Proc GChart needs to produce a pie: A A A A A B B B B C C C C C C

Greek · ‎09-12-2013

Good morning, I am trying to group "noisy" insignificant observations into one single variable so that I can focus on the observations that really matter. I have been looking to see if I can use conditionals with proc freq. The logic I am trying to implement is the following: "if a host appears less than five times group into 'other'" Basically regroup all hosts that appear less than five times into a single variable named "other" I get the table listed below, but I would like to group yahoo and aol into "other" data host_list; input host $; datalines; amazon amazon amazon amazon amazon google google google google google aol yahoo yahoo run; proc freq data=host_list order=freq; run; amazon 5 38.46 5 38.46 google 5 38.46 10 76.92 yahoo 2 15.38 12 92.31 aol 1 7.69 13 100.00 Can anybody help? Thank you

Greek · ‎09-10-2013

Hello all, thank you very much for your responses! To answer your question, someone needs to manipulate the results after I am done. Copying and pasting the original output to an excel spreadsheet is an option, but I was hoping to create a data set and export it to excel instead of doing it manually. Fugue, the n solved the problem thank you very much. Reeza, thank you for the post, this is very helpful! Regards,

Greek · ‎09-09-2013

Hello Fugue, This is the code that I used. It created the dataset that I have, but the values of Family and function are still repeated at every row... Any suggestions? data have; input family $ function $ title $ name $; datalines; A i Analyst Jim A i Analyst Ronaldo A i Analyst Zidane A i Analyst Tiger A i Manager Woods A ii Accountant Serena A ii Accountant Williams A ii manager Laura A ii manager Kristen B iii Analyst John B iii Analyst David B iii Analyst Backam B iii Analyst Anderson B iii Analyst Mike B iii Analyst Nike B iv Analyst ede B iv Generalist ukhulu B iv Generalist note B iv Generalist Noni run; proc tabulate data=have out=want; class family function title name; table family*function*title*name; run; proc print data=want; run;

Greek · ‎09-09-2013

Hello, I am trying to recreate a pivot table in excel. I have used proc tabulate and I managed to get the desired results, but the table looks like the one below. I am trying to delete the repeated values of "family" and "function" without deleting the entire row. does anybody know how to do this? Have Family Function Title Name A i Analyst Jim A i Analyst Ronaldo A i Analyst Zidane A i Analyst Tiger A i Manager Woods A ii Accountant Serena A ii Accountant Williams A ii manager Laura A ii manager Kristen B iii Analyst John B iii Analyst David B iii Analyst Backam B iii sr. analyst Anderson B iii sr. analyst Mike B iii sr. analyst Nike B iv Analyst ede B iv Analyst ukhulu B iv Analyst note B iv sr. analyst Noni Want Family Function Title Name A i Analyst Jim Analyst Ronaldo Analyst Zidane Analyst Tiger Manager Woods ii Accountant Serena Accountant Williams manager Laura manager Kristen B iii Analyst John Analyst David Analyst Backam sr. analyst Anderson sr. analyst Mike sr. analyst Nike iv Analyst ede Analyst ukhulu Analyst note sr. analyst Noni

Greek · ‎08-14-2013

Hello Siddharth! I have been using SAS for few months now so I am not the most experienced user. Even though there must be a more efficient way, here is what I have for you... Does this work? /*I arbitrarily added a few more values to test*/ data one; input user1 $ rate; datalines; A 4 A 4 A 5 A 5 A 2 A 1 A 6 A 3 A 5 A 4 B 2 B 2 B 3 B 5 B 6 B 8 B 6 run; /*Sort the data by rate so that there are no duplicate values on the same letter */ proc sort data=one nodup; by rate; run; /*sort the data again by User1 to be able to transpose in the next step*/ proc sort data=one; by user1; run; /*Transpose and create a new data set*/ proc transpose data=one out=transposed; by user1; run; /*Print to check the results*/ proc print data=transposed; run;

Greek · ‎08-09-2013

IT WORKED! Thank you so much!

Greek · ‎08-08-2013

Dear Astounding, I tried this code and I experienced some problems... I expected to create a sixth line with the word 'sum' under ID and the actual sums under everything else... Do you know what's wrong? ods html; data report; input ID employees midpoint pay; datalines; 1 20 1877000 1789000 2 17 1827000 1672000 3 17 1616000 1599000 4 28 2844000 2828000 5 18 1734000 1678000 run; data report; set report end=done; cumemployees+employees; cummidpoint+midpoint; cumpay+pay; output; if done; ID='Sum'; employees=cumemployees; midpoint=cummidpoint; pay=cumpay; run; proc print data=report; run; ods html close;

Greek · ‎08-07-2013

I don't know how to use SQL, but I keep on bumping into it. I guess I will have to learn to do cool stuff. Thank you all!

Greek · ‎08-07-2013

Hello! Do you know if we can use SAS functions vertically like in excel instead of horizontally? For example if I want the sum of each column A,B,C A B C i 1 23 12 ii 3 2 21 iii 7 5 25 I transpose to be able to use the SUM function horizontally i ii iii Sum A 1 3 7 11 B 23 2 5 30 C 12 21 25 58 then I transpose back To get the Sum the way I want it. A B C i 1 23 12 ii 3 2 21 iii 7 5 25 Sum 11 30 58 THERE HAS TO BE A BETTER WAY!

Greek · ‎08-05-2013

Formatting worked! Thank you all very much!

Online Status	Offline
Date Last Visited	‎03-28-2018 05:41 PM

Re: Proc surveyselect matched case control

Proc surveyselect matched case control

Clustering Glitch (Gower's Distance)

Re: Lag function malfunction

Re: Lag function malfunction

Lag function malfunction

Lag Function behavior problem

Re: Exporting SAS data sets

Re: Exporting SAS data sets

Exporting SAS data sets

Re: Proc surveyselect matched case control

Re: Clustering Glitch (Gower's Distance)

Re: Lag function malfunction

Re: Lag function malfunction

Re: Lag function malfunction

Re: SAS Help

Re: Expanding Frequency tables into datasets

Expanding Frequency tables into datasets

Proc Gchart: Pie error

Re: Pies with Horizontal Data

Pies with Horizontal Data

Proc Freq-Conditionals?

Re: Proc Tabulate (repeated values)

Re: Proc Tabulate (repeated values)

Proc Tabulate (repeated values)

Re: SAS Help

Re: Using SAS functions vertically

Re: Using SAS functions vertically

Re: Using SAS functions vertically

Using SAS functions vertically

Re: Proc Gplot: Axis values