About sophia_SAS

sophia_SAS · ‎05-07-2012

Dear SAS users, I am a beginner user to SAS macros. I would like to start with simple %let statements. Below is my data step with the %let. Please advise as to how I can fix the error. The error message from sas is below the data step. Thank you! let %let group=1; data s&group_1; (dataset name should be called s1_1) set s&group_2; (dataset name should be called s1_2) run; 924 %let group=1; WARNING: Apparent symbolic reference GROUP_1 not resolved. 925 data s&group_1; - 22 200 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_. ERROR 200-322: The symbol is not recognized and will be ignored.

sophia_SAS · ‎04-27-2012

Thank you. However I'm not sure how I an see which students received an A in all three years. I would like to track individual students rather than the overall percentage of students who received an A. (I.e. who received an A in both year 1 and year 2). Maybe I'm missing something?

sophia_SAS · ‎04-27-2012

SAS users, Using Proc freq, I would like to identify which students received a grade A (where A=1) in year 1, year 2 and year 3 and I would like to sort it by school. Here's a sample of my code: proc sort data=have; by school; proc freq data=have; tables year; where grade=1; by school; run; However I don't know how to specify that the student must have an A (grade=1) in all years, not just one. Thanks.

sophia_SAS · ‎04-17-2012

Sas users, Can you please recommend a way to fix the belwo code? I'm currently receiving the error message; "Ambiguous reference, column new_ID is in more than one table." In a nutshell I would like to create a new dataset "want" based on dataset "have_1" except I don't want to include in "want" any that are also in "have_2". The variable in common is "new_ID". There are duplicate "new_IDs" in "have_1" which may be causing the error message. proc sql; create table want as select new_ID from have_1 except select new_ID from have_2; quit; Thanks.

sophia_SAS · ‎04-10-2012

Thanks LinLin! Always very helpful!

sophia_SAS · ‎04-10-2012

Hi SAS users, I have a dataset with 3 variables: ID, date1 and date2. I would like to create a new dataset that identifies which observations have a date2 that is 5 months or greater than date1. For example using the data below, I would like to identify IDs 7 and 11 as they have a date2 that is at least 5 months greater than date1. Thanks. data have; input id date1 date2; cards; 5 05/12/2010 06/12/2010 7 06/22/2010 12/30/2010 9 02/04/2009 05/03/2009 11 03/27/2009 11/05/2009 ; run;

sophia_SAS · ‎04-04-2012

Thanks Haikuo for your help. The last code does work for when I'm combining the unique observations from base and new. What amendments do you suggest I do if I simply want to delete the duplicate observations from the new dataset? (I.e. the duplicates would be those that already exist in dataset base). Thanks.

sophia_SAS · ‎04-03-2012

Hi SAS community, I have two different datasets: 'base' and 'new'. Many of the observations within the two datasets are the same, but a few are not. I would like to identify which observations from 'new' are not in 'base' so that I can create a new dataset 'want' that includes all in 'base' and then the additions from 'new'. Thanks!

sophia_SAS · ‎03-27-2012

Hi SAS community- Below is a abbreviated version of an output from a proc freq. ID Frequency Percent and so on . . . a 4 0.40 b 2 0.20 c 1 0.10 d 1 0.10 e 1 0.10 f 1 0.10 I would like to view only the IDs that have a frequency of 2 or more (therefore would exclude IDs 'c-f'). Please advise as to how I can do this procedure. Thanks!

sophia_SAS · ‎03-20-2012

SAS Community- Please advise on a way to approach this question. No doubt it's very simple. I just can't seem to figure out the best way to tackle it. As an example, I have a number of variables including educated (1=yes, 0=no) and subject ID. Information was collected on both the primary subject and friends of the primary subject. To identify friends of the primary subjects, friends were assigned a similar subject ID as the primary subject (same digits except for the last one). Example: A primary subject ID = 99980, friend of A primary subject ID = 99982, friend of A primary subject ID =99983 B primary subject ID = 2A345, friend of B primary subject ID = 2A346, friend of B primary subject ID = 2A348 My study focuses on the education practices of the friends of the eligible primary subjects. Please help me with a code that will identify the friends of the eligible primary subjects where the eligible primary subjects is defined as having 1=yes for variable educated. Thanks!

sophia_SAS · ‎03-15-2012

You are correct. I amended the statement by adding the strip function. nmbstrip=strip(number); new_number=substring(nmbstrip,1,length(nmbstrip)-2); run; Thanks.

sophia_SAS · ‎03-15-2012

This code along with codes I previously used did not seem to work as it appears to take anywhere from 2-3 digits off the entire length. If the code works, shouldn't the output look something like this? Number New_Number 423902 4239 240986 2409 55093 550 20994 209 8203986 82039 However instead I obtain an output that looks like the last 3 numbers have been removed. Number New_Number 423092 423 240986 240 55093 55 20994 20 8203986 8203 Thanks.

sophia_SAS · ‎03-15-2012

Hi SAS community, I would like to write a substring that uses the variable, "number", starts at position 1 and has a length that stops at 2 places before the last digit. Please advise. This is what I have tried: data want; set have; new_number=substring(number,1,(-2)); run; I have also tried this method where I write out a separate substring for each length of the observations for the "number" variable. (This variable contains lengths ranging from 10-20). data want1; set have1; new_number1=substring(number,1,(10-2)); new_number2=substring(number,1,(11-2)); . .. .. .. new_number20=substring(number,1,(20-2)); run; Thanks.

sophia_SAS · ‎03-15-2012

Haikuo- One quick follow-up question, how do I do this step without using the input statement? I want to use a dataset currently located in my work library. According to proc contents for this dataset, the subject id has the variable listed as numeric with 6 as the length (though I know there are subject ids with up to 9 numbers). I'm sure this is a very simple SAS 101 question. I just can't seem to get my head around it. Thanks.

sophia_SAS · ‎03-15-2012

SAS Community- Using a large dataset, there is the numeric variable - 'SubjectID'. Within 'SubjectID' the observations including a number of different lengths. For example some SubjectID observations have 6 numbers while others have 7 or 8 numbers. SubjectID 234583 5546492 5546489 234577 68907734 68907736 234581 Please advise on a SAS function that will inform me on how many Subject IDs have 6 for a number length, 7th for a number length and 8 for a number length. Eventually, I will use this information to for a substring. Thanks!

Online Status	Offline
Date Last Visited	‎07-09-2020 05:04 PM

Re: local macro

Re: local macro

Re: local macro

local macro

Re: rolling calculations - duration of admission

rolling calculations - duration of admission

Re: Array and Column Names

Array and Column Names

Re: SAS numeric length

SAS numeric length

Re: Using Macro to create new variables

Re: fill in values in blank excel cells via sas

Re: by variables assigning new variables

Re: new date variables

Re: creating new variables with dates

%let statements and symbolic reference not resolved

Re: proc freq and where statements

proc freq and where statements

sql tables and ambiguous reference error message

Re: using dates

using dates

comparing observations in different dataset

comparing observations in different dataset

frequencies

comparing populations

substring and substracting

substring and substracting

substring and substracting

determining length count for observations within the same variable

determining length count for observations within the same variable