About cosmid

cosmid

Hi, Sorry the Subject may be confusing. Let's say I have two tables: Table One: ID x 1 a 2 b Table Two: ID y 1 A 3 C proc sql; create table want as select * from TableOne as One, TableTwo as Two where One.ID = Two.ID; quit; Desired output: 1 a A The above code will work but will give a WARNING and use the ID from TableOne. The correct version would be changing the SELECT statement to: select One.ID, x, y However, the solution only works if there's 2 variables to list. What if there are hundreds? I know it can be done using a MERGE but is there a way to write it in PROC SQL? Thanks

cosmid

Hi, Run into a problem from the SAS Professional Prep Guide: How many statements does the program below contain? proc sql; select grapes, oranges, grapes + oranges as sumsales from certadv.produce order by sumsales; quit; a. two b. three c. four d. five Answer Key: a I got this wrong because I picked b. I thought everything ends with a semicolon in SAS counts as a statement? Isn't that why they call it the QUIT statement? Thanks

cosmid

Hi, From the definition of the two: INOBS= is restricting the number of input rows OBS= is specifying the last observation Based on that, I couldn't think of a scenario where the two are different. Are they logically the same thing? Thanks

cosmid · ‎10-26-2023

Thanks for the find function. To answer your question, the real problem is: There is this variable with foreign characters, something like àäèéëïĳöü The objective is to list out all of the observations with at least one of these characters. However, the actual list is about 30+ characters, so I can write 30+ find () or. As I am writing this reply, I just realized I may be able to use the verify function and just pick out observations with normal alphanumerics.

cosmid · ‎10-26-2023

Hi, Sorry, the Subject wasn't clear. So, what I am trying to do is, I have a variable with values like the following: ID exampleVar 1 dog 2 cat 3 apple I want to return a list of IDs if the variable contains any of the following values, ('o', 'g', 'e'). So the result should be 1 and 3. I thought of verify function and prxmatch, but I couldn't quite come up with a solution with them. Is manual search the only solution? Thanks

cosmid · ‎10-24-2023

I forgot about the WHERE will be applied first. Thank you!

cosmid · ‎10-24-2023

oh, so the obs= count actually only increments if the condition is met? data want; set have(obs=10); if condition here; run; The above code will only output 10 observations even if it reads in 1000 observations?

cosmid · ‎10-24-2023

Hi, So, with the obs= option, like following: data want; set have(obs=10); run; It will limit the output dataset to have 10 observations. What I am asking is, how do you limit the dataset WANT itself? If I am creating a datset WANT based on the dataset HAVE, but there's an IF condition, and at the end I only want 100 observations even more 100 observations met the condition. I can't use the method above because I don't know how many observations it will take to meet the 100 observation conditions. Example: data want(obs=100); set have; if condition here; run; The above is just pseudo code.

cosmid · ‎09-20-2023

Hi ballardw, thanks for the explanation! Regarding the index question, I was asking if there's a way using DATA step to modify a variable's value without LOSING the index associated with that dataset. I understand that when updating a dataset, the associated index file will also be updated. I tried the following code it'll delete the index file afterwards: data have; set have; substr(YR,1,4) = '2023'; run; Assuming that the dataset HAVE is indexed. For the question regarding why the YR variable is in CHAR form and not in NUM, well, I didn't create the original dataset and just need to work on it as is. I totally agree with you that it shouldn't be in CHAR.

cosmid · ‎09-20-2023

Hi, If I have a dataset with a CHAR variable named YR that has values in YYYYMM, like 202101 to 202112 and I wanted to modify this dataset so that the YYYY will be 2023, 202301 to 202312. Also, this dataset is indexed. I used the following code: proc sql; update mydata set substr(YR, 1, 4) = '2023'; quit; For some reason, I keep getting an error of Expecting =. Question 1: What's the proper way to use the substr function in PROC SQL? Question 2: What is the correct method for modify this variable in a DATA step without losing the index? Thanks!

cosmid · ‎06-27-2023

Wow! Thanks! It would be nice if I can do that with SAS. A MERGE with and without BY confuses me enough, lol. I need to get more practice for sure. Thanks again for teaching me the trick with the use of SET!

cosmid · ‎06-26-2023

It worked. I am an idiot. For some reason I used SET instead of MERGE. Sorry for spamming. Thanks for the help!

cosmid · ‎06-26-2023

Oops...it seems that method didn't work. Instead of replacing the first 10 IDs it added 10 rows with the CMIDs fro the second dataset Two to the first dataset, One.

cosmid · ‎06-26-2023

Hi, If I have two datasets, One and Two, both has a column named ID, how do I replace One's ID with Two's ID for just first 10 observations, ignoring all other vars? Thanks!

cosmid · ‎02-07-2023

Hi, If I have a data with var1 and var2, and I wanted the final .csv file to be sorted by var2, my question is: Is it possible to sort the data in a PROC EXPORT step or the data can only be sorted by a PROC SORT before the PROC EXPORT? If it is possible to sort using PROC EXPORT, what's the syntax? Thanks!

Online Status	Offline
Date Last Visited	4 hours ago

How do I select everything with 2 tables that have 1 common ID using P...

Is QUIT; not a statement in SAS?

Logic difference between INOBS= and OBS=?

Re: How do you search a string of characters for a variable?

How do you search a string of characters for a variable?

Re: How do you limit the number of observations of the output dataset?

Re: How do you limit the number of observations of the output dataset?

How do you limit the number of observations of the output dataset?

Re: 2 questions: How to use substr in PROC SQL and how to modify a var...

2 questions: How to use substr in PROC SQL and how to modify a variabl...

Re: Is QUIT; not a statement in SAS?

Re: Logic difference between INOBS= and OBS=?

Re: How do you search a string of characters for a variable?

Re: How do you search a string of characters for a variable?

Re: How do you search a string of characters for a variable?

Re: How to convert a formatted SAS date back to a SAS numeric date?

Re: How to output a macro result to a specified .lst file?

Re: I keep getting Correct the highlighted errors and try again

Re: Are _N_ and _ERROR variables available during BY-group prcoessing?

Re: SAS Base questions from 5th Edition Book

How do I select everything with 2 tables that have 1 common ID using P...

Is QUIT; not a statement in SAS?

Logic difference between INOBS= and OBS=?

Re: How do you search a string of characters for a variable?

How do you search a string of characters for a variable?

Re: How do you limit the number of observations of the output dataset?

Re: How do you limit the number of observations of the output dataset?

How do you limit the number of observations of the output dataset?

Re: 2 questions: How to use substr in PROC SQL and how to modify a var...

2 questions: How to use substr in PROC SQL and how to modify a variabl...

Re: How to replace a column's value from another dataset

Re: How to replace a column's value from another dataset

Re: How to replace a column's value from another dataset

How to replace a column's value from another dataset

Is there a sort option in PROC EXPORT?