Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Home
- /
- About FerGui1
11-02-2021
FerGui1
Fluorite | Level 6
Member since
06-21-2021
- 11 Posts
- 0 Likes Given
- 1 Solutions
- 0 Likes Received
-
Latest posts by FerGui1
Subject Views Posted 1072 11-02-2021 04:02 PM 1083 11-02-2021 03:29 PM 1112 11-02-2021 12:34 PM 1150 11-02-2021 11:12 AM 1032 10-15-2021 02:19 PM 1070 10-15-2021 12:50 PM 1865 06-23-2021 05:06 PM 1943 06-22-2021 09:51 AM 1943 06-22-2021 09:50 AM 1944 06-22-2021 09:48 AM -
Activity Feed for FerGui1
- Posted Re: Re-formatting a sas output using proc report on Statistical Procedures. 11-02-2021 04:02 PM
- Posted Re: Re-formatting a sas output using proc report on Statistical Procedures. 11-02-2021 03:29 PM
- Posted Re: Re-formatting a sas output using proc report on Statistical Procedures. 11-02-2021 12:34 PM
- Posted Re-formatting a sas output using proc report on Statistical Procedures. 11-02-2021 11:12 AM
- Posted Re: Formatting & rearranging tables using proc sql on Statistical Procedures. 10-15-2021 02:19 PM
- Posted Formatting & rearranging tables using proc sql on Statistical Procedures. 10-15-2021 12:50 PM
- Posted Re: Retaining common observations within a data set following different criteria. on SAS Programming. 06-23-2021 05:06 PM
- Posted Re: Retaining common observations within a data set following different criteria. on SAS Programming. 06-22-2021 09:51 AM
- Posted Re: Retaining common observations within a data set following different criteria. on SAS Programming. 06-22-2021 09:50 AM
- Posted Re: Retaining common observations within a data set following different criteria. on SAS Programming. 06-22-2021 09:48 AM
- Posted Retaining common observations within a data set following different criteria. on SAS Programming. 06-21-2021 06:14 PM
11-02-2021
04:02 PM
PaigeMiller, It works just as I needed. Thank you so much!
... View more
11-02-2021
03:29 PM
Hi, Is this what you need? data tryout1; INPUT Shelf $ Category $ Article $ Value; CARDS; A Office Art1 54.566 A Office Art2 47.3333333 Shared Office Art1 48.2 Shared Office Art2 50.1833333 B Office Art1 54.9133 B Office Art2 51.646 A Home Art1 50.18 A Home Art2 46.1133333 Shared Home Art1 54.913 Shared Home Art2 51.6466667 B Home Art1 42.9 B Home Art2 49.9666667 ; proc sort data=tryout1; by category; proc report data=tryout1; by category; columns article shelf,value; define article/group; define shelf/across; define value/sum format=best8.1; run;
... View more
11-02-2021
12:34 PM
Hi PaigeMiller, Thank you so much for your assistance. I run your proposed coding and got the output below. I will still need to: 1. Sort the shelf columns so that it shows in the order Shared, A, and B 2. Replace the 'Value' row by the shelf headings (Shared, A, and B) 3. Eliminate the 'Shelf' row 4. Round all the values to 1 decimal place Could you help on that?
... View more
11-02-2021
11:12 AM
Hello, I have a SAS output like the one showing in table 1 and i would like to format it so that I have the two tables shown in tables 2 and 3. Any assistance on this will be greatly appreciated. table 1 Shelf Category Article Value A Office Art1 54.566 A Office Art2 47.33333 Shared Office Art1 48.2 Shared Office Art2 50.18333 B Office Art1 54.9133 B Office Art2 51.646 A Home Art1 50.18 A Home Art2 46.11333 Shared Home Art1 54.913 Shared Home Art2 51.64667 B Home Art1 42.9 B Home Art2 49.96667 table2 Office Article Shared A B Art1 48.2 54.6 54.9 Art2 50.2 47.3 51.6 table 3 Home Article Shared A B Art1 54.9 50.2 42.9 Art2 51.6 46.1 50.0
... View more
10-15-2021
02:19 PM
Yes, L1 and L2 will have numeric values. Thanks.
... View more
10-15-2021
12:50 PM
Hello, I have two data sets, data1 & data2, shown below data1 label name var value L1 A v1 4 L1 B v1 3 L1 C v1 6 L1 D v1 7 L1 E v1 4 L2 A v1 5 L2 B v1 1 L2 C v1 2 L2 D v1 8 L2 E v1 3 L1 A v2 18 L1 B v2 12 L1 C v2 4 L1 D v2 18 L1 E v2 14 L2 A v2 12 L2 B v2 4 L2 C v2 12 L2 D v2 20 L2 E v2 10 data2 label var stat L1 v1 0.05 L1 v2 0.01 L2 v1 0.07 L2 v2 0.05 I want to use them to create a new table, table1, with the format below: v1 name L1 L2 A 4 5 B 3 1 C 6 2 D 7 8 E 4 3 stat 0.05 0.07 v2 name L1 L2 A 18 12 B 12 4 C 4 12 D 18 20 E 14 10 stat 0.01 0.05 I do not know much about the use of proc sql, but for wat I read it seems that it is the right tool for doing this. Any help on this will be much appreciated.
... View more
06-23-2021
05:06 PM
Hi Mkeintz, It works. Thank you much for your assistance on this.
... View more
06-22-2021
09:51 AM
Hi Reeza, The major data set is: Data set A Period Batch Condition Response1 Response2 Response3 1 1 A 1 1 B 1 1 C 1 1 D 1 1 E 1 2 A 1 2 B 1 2 C 1 2 D 1 2 E 2 1 B 2 1 C 2 1 D 2 1 E 2 2 B 2 2 C 2 2 D 2 2 E 3 1 C 3 1 D 3 1 E 3 2 C 3 2 D 3 2 E 4 1 D 4 1 E 4 2 D 4 2 E The Batch variable is a block effect in the experiment (replication). From this data set I need to create 3 sub data sets for further analyses: The first one (sub data set A1) should only include common observations within the variable Condition for Period 1 and Period 2, s this sub data set will look like: Sub data set A1 Period Batch Condition Response1 Response2 Response3 1 1 B 1 1 C 1 1 D 1 1 E 1 2 B 1 2 C 1 2 D 1 2 E 2 1 B 2 1 C 2 1 D 2 1 E 2 2 B 2 2 C 2 2 D 2 2 E The second one (sub data set A2) should only include common observations within the variable Condition for Period 1, Period 2, and Period 3, so this sub data set will look like: Sub data set A2 Period Batch Condition Response1 Response2 Response3 1 1 C 1 1 D 1 1 E 1 2 C 1 2 D 1 2 E 2 1 C 2 1 D 2 1 E 2 2 C 2 2 D 2 2 E 3 1 C 3 1 D 3 1 E 3 2 C 3 2 D 3 2 E And the third sub data set will include all periods, so it will look like: Sub data set A3 Period Batch Condition Response1 Response2 Response3 1 1 D 1 1 E 1 2 D 1 2 E 2 1 D 2 1 E 2 2 D 2 2 E 3 1 D 3 1 E 3 2 D 3 2 E 4 1 D 4 1 E 4 2 D 4 2 E
... View more
06-22-2021
09:50 AM
I did that but the only output I've got was a column with the condition values that were common among periods, nothing else.
... View more
06-22-2021
09:48 AM
Hi MKeintz, My apologies if I was not clear with my question. To be more clear, the major data set is: Data set A Period Batch Condition Response1 Response2 Response3 1 1 A 1 1 B 1 1 C 1 1 D 1 1 E 1 2 A 1 2 B 1 2 C 1 2 D 1 2 E 2 1 B 2 1 C 2 1 D 2 1 E 2 2 B 2 2 C 2 2 D 2 2 E 3 1 C 3 1 D 3 1 E 3 2 C 3 2 D 3 2 E 4 1 D 4 1 E 4 2 D 4 2 E The Batch variable is a block effect in the experiment (replication). From this data set I need to create 3 sub data sets for further analyses: The first one (sub data set A1) should only include common observations within the variable Condition for Period 1 and Period 2, s this sub data set will look like: Sub data set A1 Period Batch Condition Response1 Response2 Response3 1 1 B 1 1 C 1 1 D 1 1 E 1 2 B 1 2 C 1 2 D 1 2 E 2 1 B 2 1 C 2 1 D 2 1 E 2 2 B 2 2 C 2 2 D 2 2 E The second one (sub data set A2) should only include common observations within the variable Condition for Period 1, Period 2, and Period 3, so this sub data set will look like: Sub data set A2 Period Batch Condition Response1 Response2 Response3 1 1 C 1 1 D 1 1 E 1 2 C 1 2 D 1 2 E 2 1 C 2 1 D 2 1 E 2 2 C 2 2 D 2 2 E 3 1 C 3 1 D 3 1 E 3 2 C 3 2 D 3 2 E And the third sub data set will include all periods, so it will look like: Sub data set A3 Period Batch Condition Response1 Response2 Response3 1 1 D 1 1 E 1 2 D 1 2 E 2 1 D 2 1 E 2 2 D 2 2 E 3 1 D 3 1 E 3 2 D 3 2 E 4 1 D 4 1 E 4 2 D 4 2 E
... View more
06-21-2021
06:14 PM
Hello, From the data set below (data set A) I need to retain (or extract to a subdata set) common Condition values between the Period 1 and 2 (which would be B, C, D, and E); I also need to do the same among Period 1, 2 and 3 (C, D, E); and among Period 1, 2, 3, and 4 (D, E). Any help on this will be much appreciated. Thanks. Data set A Period Condition Response1 Response2 Response3 1 A 1 B 1 C 1 D 1 E 2 B 2 C 2 D 2 E 3 C 3 D 3 E 4 D 4 E
... View more
