About gsk

gsk · ‎11-03-2019

Thank you for the response! I meant how do we get to MySASDataset if we have a list of values stored in &list?

gsk · ‎11-03-2019

How? I don’t think tranwrd or replace would work because they only work with certain expression (not macro containing a list of values)

gsk · ‎11-03-2019

How do we use macro objects/variables when we have a list of values we want to replace with? For example, %list contains 001 002 003 004. Let's say we have subject IDs like this: SUBJ-001-M SUBJ-002-J SUBJ-005-K SUBJ-007-K SUBJ-004-N I want to say: replace the number between - and - to single - if the number is one of the macro objects, and eventually end up with: SUBJ-M SUBJ-J SUBJ-005-K SUBJ-007-K SUBJ-N

gsk · ‎10-31-2019

In SAS can we do something like proc sql; select a.*, b.new_var from data1 as a left join data2 as b on a.subjid=b.subjd; quit; but b.new_var is created if an observation from a has missing(variable1). If missing(a.variable1), then read b.variable2, b.variable3, b.variable4 and create a new_var based on some direction involving variable2 and variable3 and variable4.

gsk · ‎10-25-2019

Thank you!! I looked up the syntax but still don't understand this part count(distinct ifc(degree=' ','9999',degree)) as degree_flag Could you please explain what distinct ifc(degree=' ','9999',degree) mean..?

gsk · ‎10-24-2019

I want to count number of distinct values of subcategories/subgroups within a group. For example, I have dataset called data: data data; infile datalines missover delimiter=','; length Name $6 School $12 Degree $10 ; input Name $ School $ Degree $ ; datalines; David, Brown, CS David, UC Davis, David,UC Davis, Psych Linda,UPenn, Statistics Robert,U of T , Statistics Robert, UCLA , Math Sally, Northwestern, English Sally, NYU, English ; For this data, group is individual, and first subgroup is school, and second subgroup is major. David attended two distinct schools Brown and UC Davis, out of 3 of his rows. He studied three distinct fields CS, blank (blank needs to be counted as its own subgroup), and Psych. I want to get his school_count to be 2 and major_count to be 3. Eventually, I want a dataset like this: data want; infile datalines missover delimiter=','; length Name $6 School $12 Degree $10 school_flag degree_flag 3.; input Name $ School $ Degree $ school_flag degree_flag 3.; datalines; David, Brown, CS, 2, 3 David, UC Davis, , 2, 3 David,UC Davis, Psych, 2, 3 Linda,UPenn, Statistics, 1, 1 Robert,U of T , Statistics, 2, 2 Robert, UCLA , Math, 2, 2 Sally, Northwestern, English, 2, 1 Sally, NYU, English, 2, 1 ; Is there a way to do this using data steps or proc sql? Thank you!

gsk · ‎08-19-2019

Sorry for not clarifying my question. If I have a variable with values of long sentences. For example, for an observation, let's say I have: "SAS was re-designed in SAS 76 with an open architecture that allowed for compilers and procedures. The INPUT and INFILE statements were improved so they could read most data formats used by IBM mainframes. Generating reports was also added through the PUT and FILE statements. The ability to analyze general linear models was also added[27] as was the FORMAT procedure, which allowed developers to customize the appearance of data.[23] In 1979, SAS 79 added support for the CMS operating system and introduced the DATASETS procedure. Three years later, SAS 82 introduced an early macro language and the APPEND procedure.[23] SAS version 4 had limited features, but made SAS more accessible. Version 5 introduced a complete macro language, array subscripts, and a full-screen interactive user interface called Display Manager.[23] In 1985, SAS was rewritten in the C programming language. This allowed for the SAS' Multivendor Architecture that allows the software to run on UNIX, MS-DOS, and Windows. It was previously written in PL/I, Fortran, and assembly language.[19][23] In the 1980s and 1990s, SAS released a number of components to complement Base SAS. SAS/GRAPH, which produces graphics, was released in 1980, as well as the SAS/ETS component, which supports econometric and time series analysis. A component intended for pharmaceutical users, SAS/PH-Clinical, was released in the 1990s. The Food and Drug Administration standardized on SAS/PH-Clinical for new drug applications in 2002.[19] Vertical products like SAS Financial Management and SAS Human Capital Management (then called CFO Vision and HR Vision respectively) were also introduced.[28] JMP was developed by SAS co-founder John Sall and a team of developers to take advantage of the graphical user interface introduced in the 1984 Apple Macintosh[29] and shipped for the first time in 1989.[29]Updated versions of JMP were released continuously after 2002 with the most recent release being from 2016.[30][31][32][33][34][35][36] SAS version 6 was used throughout the 1990s and was available on a wider range of operating systems, including Macintosh, OS/2, Silicon Graphics, and Primos. SAS introduced new features through dot-releases. From 6.06 to 6.09, a user interface based on the windows paradigm was introduced and support for SQL [37] was added.[23] Version 7 introduced the Output Delivery System (ODS) and an improved text editor. ODS was improved upon in successive releases. For example, more output options were added in version 8. The number of operating systems that were supported was reduced to UNIX, Windows and z/OS, and Linux was added.[23][38] SAS version 8 and SAS Enterprise Miner were released in 1999.[19]" I want to create variables off of this variable. First derived variable would be: "SAS was re-designed in SAS 76 with an open architecture that allowed for compilers and procedures. The INPUT and INFILE statements were improved so they could read most data formats used by IBM mainfr" because that's the first 1-200 letters. Second derived variable would be: "ames. Generating reports was also added through the PUT and FILE statements. The ability to analyze general linear models was also added[27] as was the FORMAT procedure, which allowed developers to cu" because this is 201-400 letters. I want to create 9 variables off of the variable even though 9 variables might not be able to contain all the sentences.

gsk · ‎08-12-2019

Let's say I have a variable named text, and let's say it has values of some long texts for each observation. I want to tell sas this: make a variable named var1 if the text variable length is greater than 1, and put the text variable's index number of 1 to 100 into var 1; make a variable named var2 if a variable length is greater than 101, and put the text variable's index number of 101 to 200 into var 2, and so forth. Could we achieve this using array? So the resulting dataset would be: text var1 var2 ,..., var10 blah blah blah,.,a b,..b (may not exist if text is not long enough)

gsk · ‎07-09-2018

-Edited reply- Data would consist of 50 observations from each group. Then, I would like to calculate a statistic of the observations within each group while excluding one observation from the group at a time. Then, in the end, I would be able to calculate a variance estimate for each group. Hm, I see.. Then I don't think I should use SURVEYFREQ. Sorry, I can't provide data but I think any data should work. I think I should use codes like https://blogs.sas.com/content/iml/2017/06/21/jackknife-estimate-standard-error-sas.html but instead, do leave one out within a group.

gsk · ‎07-09-2018

I have data with some categorical variables with missing values in them. I need variance estimates of the data based on leave i-th observation out within each group inside a categorical variable. (So in the end, I would have the number of estimates same as the number of observations in each group and k variance estimates for k groups in a categorical variable). Is using ROC SURVEYFREQ with strata statement and VARMETHOD=JACKKNIFE specification a correct way to do this? Or do I need to make a loop like this: https://blogs.sas.com/content/iml/2017/06/21/jackknife-estimate-standard-error-sas.html ? Also, if I need to make a loop like that for k groups, how do we construct proc iml codes? Thank you in advance! I would greatly appreciate any help.

gsk · ‎04-15-2018

Thank you, I've changed the three macros to take in one variable only (by deleting the loops) and because of that, they don't have i anymore. And yes, I forgot to add %eval(&i+1) and have added that line at the end of the macro I want to make. Now, how do we check if a scanned variable in &allvar is in any of &numlist/&charlist/&datelist and run one of the macro functions numsum/charsum/datesum accordingly?

gsk · ‎04-15-2018

I have: &numlist, which has a list of numeric variables in a dataset &datelist, which has a list of date variables in a dataset &charlist, which has a list of character variables in a dataset &varordered, which has a list of all numeric, date, character variables of a dataset in alphabetical order. %macro numsum: summarizes a list of numeric variables %macro charsum: summarizes a list of character variables %macro datesum: summarizes a list of date variables I want to make a macro function that takes in &varordered and runs one of the three macro functions according to the variable type of the variables in the &varordered list. I'm doing this because I want to produce a summary output of every variable alphabetically. I'm worried if taking in a list of num/char/date variables would be a problem though, since I would be feeding in one variable at a time, not a list of num/char/date, from &varordered. To sketch the idea, I think this form would work for the macro? %macro (allvar= &varordered); %let i=1; %do %until (%scan(&allvar,&i)= ); %let var=%scan(&allvar,&i); /* Here, I want to do: */ /* if the scanned variable in allvar is numeric (in &numlist), run a macro function called numsum */ /* if the scanned variable in allvar is character (in &charlist), run a macro function called charsum */ /* if the scanned variable in allvar is a date variable (in &datelist), run a macro function called datesum */ %end; %mend allvar ; *************************************; Code for one of the three macro functions I have fyi: %macro charsum; %let i=1; %do %until (%scan(&charlist,&i)= ); %let var=%scan(&charlist,&i); proc sql noprint; select count (distinct &var) into :valcount from met.dema_669; quit; %if &valcount<=6 %then %do; proc freq data=met.dema_669; tables &var / missing; title "Frequency table for &var"; run; %end; %else %do; data _null_; file print; length sentence $200; sentence="Variable &var is not tabulated; all or most values unique"; put sentence; put _page_; %end; title; %let i= %eval(&i+1); %end; %mend charsum; Thank you for the help in advance!

gsk · ‎04-13-2018

I want to create macro variables of lists of numeric, character, and date variable (separately) and their respective number of variables. Below is my code so far but I don't know how to add codes to create macros to store the number of each variable type. proc sql noprint; select name into :numlist separated by ' ', / * HERE.. I don't know what to write. something like len(&numlist) or count(name) into :numvalcount is what I want to do. */ from dictionary.columns where libname='MET' and memname='DEMA_669' and type='num' AND FORMAT^='DATE9.' order by name; select name into :datelist separated by ' ', / * HERE.. I don't know what to write. */ from dictionary.columns where libname='MET' and memname='DEMA_669' and type='num' AND FORMAT='DATE9.' order by name; select name into :charlist separated by ' ', / * HERE.. I don't know what to write. */ from dictionary.columns where libname='MET' and memname='DEMA_669' and type='char' order by name; quit; So in the end I want to have: %put &numlist; %put &charlist; %put &datelist; %put &numvalcount; %put &charvalcount; %put &datevalcount;

gsk · ‎04-13-2018

Let's say I have (numlist,datelist, charlist are all variable lists): %put &numlist; a c e %put &datelist; b d %put &charlist; f z I want to combine a, c, e, b, d, f, z and make an output of a string that has values of a b c d e f z so that I could feed this string into a macro to do a set of analysis on each of these variables. How do I combine &numlist, &datelist, &charlist and order the values alphabetically?

gsk · ‎04-08-2018

Thank you for the reply! But for Hatchback and Highway MPG for instance, 32.5 is not the average of 31.7, 32.2, and 36. Same as SUV and City MPG, SUV and Highway MPG, etc. Also, what does rbreak indicate? It doesn't have averages of all cars for each City MPG either.

Online Status	Offline
Date Last Visited	‎09-20-2020 12:24 PM

Check all prior values and leading values within a group to create a f...

Store macro variable based on values on two variables

Re: subtract a date variable only if the next date is not a certain le...

subtract a date variable only if the next date is not a certain length

proc report across a variable but output another variable's value in t...

data step with SET somehow deletes observation

Re: Find special characters in a string, take them off and do a calcul...

Find special characters in a string, take them off and do a calculatio...

Re: Compare dates but only up to the same length

Re: Compare dates but only up to the same length

Re: Find special characters in a string, take them off and do a calcul...

Re: Find special characters in a string, take them off and do a calcul...

Re: How to assign the value of a column to a macro variable in a data ...

Re: How to assign the value of a column to a macro variable in a data ...

Re: How to assign the value of a column to a macro variable in a data ...

Re: Don't know what's wrong with my (simple) macro function

Re: Replace if a macro value with a value

Re: Replace if a macro value with a value

Replace if a macro value with a value

Merge with a dataset and create a new variable if a value of an existi...

Re: Counting number of different values in multiple subcategories

Counting number of different values in multiple subcategories

Re: Creating a new variable based on an existing variable if it has mo...

Creating a new variable based on an existing variable if it has more t...

Re: Construct a jackknife sample based on groups (leave kth-group)

Construct a jackknife sample based on groups (leave kth-group)

Re: How to find a match among different macro lists

How to find a match among different macro lists

How do we create both distinct variables and number of variable counts...

How to combine macro values and order tham alphabetically?

Re: Proc report role of summarize after break variable