cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
LucasW
‎03-13-2023
  • 8 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received
This widget could not be displayed.

Re: IF FIRST.ID with Proc SQL

by Calcite | Level 5 in SAS Enterprise Guide
‎03-07-2023 06:43 PM
‎03-07-2023 06:43 PM
Hi @Reeza thank you soooo much!  ... View more

Re: IF FIRST.ID with Proc SQL

by Calcite | Level 5 in SAS Enterprise Guide
‎03-07-2023 05:37 PM
‎03-07-2023 05:37 PM
Hi @Quentin,   I've learned only simple sub-queries, but I believe it counts as one query. Unfortunately, the school I'm in has a tendency the teach the simple stuff and then request on exams tasks that were never saw in class... They say we need to figure it out ourselves...    So, with the code that I did, I got this:   ID Name Score AVG_SCORE 1 David 45 59.5 1 David 74 59.5 2 Sam 45 45 3 Ram 54 54 4 Bane 87 88.5 5 Mary 92 92 4 Bane 90 87 6 Dane 23 23 7 Jenny 87 87 8 Ken 87 87 9 Simran 63 63 10 Priya 72 72   But I need to eliminate the duplicate students and keep the lowest score, like this:     ID Name Score AVG_SCORE 1 David 45 59.5 2 Sam 45 45 3 Ram 54 54 4 Bane 87 88.5 5 Mary 92 92 6 Dane 23 23 7 Jenny 87 87 8 Ken 87 87 9 Simran 63 63 10 Priya 72 72   Thank you for your help! ... View more

Re: IF FIRST.ID with Proc SQL

by Calcite | Level 5 in SAS Enterprise Guide
‎03-07-2023 04:51 PM
‎03-07-2023 04:51 PM
Hi Tom,    Sorry to not return with a table. Below is the question that I received, I hope it clarifies:   With PROC SQL, find the average SCORE present in the data, in a single query. Call the column containing the result AVG_SCORE and store the result in a table called AVG_SCORE_TABLE. NOTE: A student (NAME) can be present twice, in this case, remember only keep the minimum score recorded.   So far the code that I did worked (below), but the I have duplicate rows with only the SCORE column with different values.   Create table AVG_SCORE_TABLE as Select name, score, mean (score) as AVG_SCORE   from readin1 Group by name, score Order by AVG_SCORE DESC; Run;   I don't know where to include the query to keep only the minimum score. Thanks for your help!   ... View more

Re: IF FIRST.ID with Proc SQL

by Calcite | Level 5 in SAS Enterprise Guide
‎03-07-2023 04:16 PM
‎03-07-2023 04:16 PM
Hi Tom,    Is it possible to include Min or Max if I already have another query in between? In my task I have to create an extra column with the average, and then if there is a duplicate, I need to keep the row that had the min original score, example:   Create table readin1 as Select id, name, mean (score) as score_average, min(score) as score   from readin1 Group by id, name;  Run; ... View more

Re: IF FIRST.ID with Proc SQL

by Calcite | Level 5 in SAS Enterprise Guide
‎03-07-2023 03:30 PM
‎03-07-2023 03:30 PM
I totally get it what both of you are saying, that's why after researching a lot, I ended up asking here. It is not the first time that I receive a reply saying it is not possible to do this or that with Proc SQL... I guess my teacher have no clue what he is asking for... and probably he is not an expert on the subject himself... Difficult will be for me to question him about it without saying that I asked a ton of experts...  Thank you a lot @ballardw and @Kurt_Bremser ! ... View more

IF FIRST.ID with Proc SQL

by Calcite | Level 5 in SAS Enterprise Guide
‎03-07-2023 01:18 PM
‎03-07-2023 01:18 PM
Is there any way to get IF First.ID result with PROC SQL? Please let me know.   data readin; input ID Name $ Score; cards; 1 David 45 1 David 74 2 Sam 45 2 Ram 54 3 Bane 87 3 Mary 92 3 Bane 87 4 Dane 23 5 Jenny 87 5 Ken 87 6 Simran 63 8 Priya 72 ; run;   PROC SORT DATA = READIN; BY ID; RUN;    DATA READIN1; SET READIN; BY ID; IF FIRST.ID; PROC PRINT; RUN;   Desired output:  Thank you!!!   ... View more

Re: Create a table with library content with no details

by Calcite | Level 5 in SAS Enterprise Guide
‎03-07-2023 01:13 PM
‎03-07-2023 01:13 PM
Thank you @Tom ! ... View more

Create a table with library content with no details

by Calcite | Level 5 in SAS Enterprise Guide
‎03-03-2023 02:11 PM
‎03-03-2023 02:11 PM
Hello everyone, I was requested to write a procedure that validates that the WORK library contains the requested tables with the right nomenclature, example given below:  File’s name Name of the table in SAS ex_1.csv ex_1 ex_2.csv ex_2 ex_3.csv ex_3 ex_4.csv ex_4   I've created a project, then imported the 4 tables and then used the procedure below: proc datasets library=work memtype=data; run; I was not able to reproduce what it was requested, but only the below: Directory Libref Engine Physical Name FilenameOwner NameFile SizeFile Size (bytes) WORK V9 C:\Users\augus\xxxx\Prc2 C:\Users\augus\xxxx\Prc2 DESKTOP-xxx\augus 4KB 4096  # Name Member Type File Size Last Modified1234 ex_1 DATA 2MB 2023-03-03 13:45:49 ex_2 DATA 2MB 2023-03-03 13:45:50 ex_3 DATA 2MB 2023-03-03 13:45:50 ex_4 DATA 35MB 2023-03-03 13:45:55   Then I've used the below in an attempt to remove the details from Directory, but keeping the library name:  PROC CONTENTS NOPRINT DATA=work._ALL_ OUT=WORK DETAILS DIRECTORY MEMTYPE=DATA; RUN;   proc sort out=work       dupout=memname       nodupkey;       by memname; run;   But I got a table with a lot of details and no file name. The table headers and (content) were:  Libname (Work), Memname (tables_names), Memlabel (empty), Typemem, Name (a variation of tables_names), Type (1,2), Length (8...11), Varnum (2...22), Label (empty), Format (Best, $CHAR), Formatl (2,5,11), Formatd (0), Informat (Best, $CHAR), Informl (2,5,11), Informd (0), Just (0), NPOS (16...217), NOBS (2694...133665), Engine (V9), Crdate and the list go on with no relevant info.   Only the libname and memname columns gave what I needed, is it possible to remove the rest of the columns and insert one with the original names of the files?   Thank you for the help!   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-13-2023 02:46 AM
Likes given to
View All
Quick links