About cosmid

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!

cosmid · ‎01-04-2023

This expandtabs feature is very good to know. Thank you! Also, I realized what my issue was and I had asked the wrong question. I had a word document with few columns and I am only interested in one of the column values. When I copy and paste from word document to UNIX SAS, the output included multiple columns, but when I paste them into SAS Windows, the output had the correct result. That's when I realized SAS UNIX and SAS Windows treats tabs differently. But this expandtabs is going to help in the future I am sure of it. I am going to spend a bit time to study it more. Thanks again for the info!

cosmid · ‎01-03-2023

Hi ballardw, looking back at my question, it didn't make sense to me. Thanks for pointing that out.

cosmid · ‎01-03-2023

Hi, How do you read in only the positions of characters you want if the dataset has tabs, spaces? Example: data colINPUT; length x $10; input x $ 3-11; datalines; 1 abcdefgh tab spaces something 12345 aabc sf dss thirdrecord run; How do I create a data from column 3 to column 11 only? So with the sample above, the output dataset should be: abcdefgh abc thirdreco The code didn't work.

cosmid · ‎12-29-2022

Thank you Koen!

%lowcase vs lowcase

Re: Question regarding whether SAS resets values in the PDV

Question regarding whether SAS resets values in the PDV

How do I find the SAS catalogs for formats such as date9., comma8. etc...

Question on many to many merge

Is there a way to print the libname var in the log?

Re: How to replace a value from a column with the value of column from...

Re: How to replace a value from a column with the value of column from...

Re: How to replace a value from a column with the value of column from...

How to replace a value from a column with the value of column from ano...

Re: how to truncate table

How to concatenate values in SAS

Re: DO WHILE vs. DO UNTIL

Re: %lowcase vs lowcase

Re: %lowcase vs lowcase

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 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?

Re: How to use SAS column input with tabs and spaces for simple data s...

Re: How to use SAS column input with tabs and spaces for simple data s...

How to use SAS column input with tabs and spaces for simple data set?

Re: How do you define the width of a format value name?