About Mgarret

Mgarret · ‎01-11-2012

Hi Ksharp-- After this step: data want; retain Case_Number id FirstName LastName &list1 Agency_Name &list2 Q5 program_name Q4 &list3; set want; run; I got these errors: WARNING: Apparent symbolic reference LIST1 not resolved. WARNING: Apparent symbolic reference LIST2 not resolved. WARNING: Apparent symbolic reference LIST3 not resolved. I am not sure how to define the Macro in this case. I am fimiliar with %let but I'm not sure how to utilize it here. Matt

Mgarret · ‎01-11-2012

This looks closer to what I'm trying to accomplish. i will try this tomorrow and let you know. Thanks!

Mgarret · ‎01-10-2012

You're not being blunt at all. I'm new to SAS and I REALLY appreciate your help. I see, yes, I need to Merge Have1 and Have2 first to produce the FinalData set. Then I can order the variables. data Agency1 set FinalData retain( Case_Number ID FirstName LastName Q52a: Agency_Name Q57a: Q5 Program_Name Q4 Q64: Age); run; 2. Yes, this is a little confusing (sorry). The data I use comes from excel spreadsheets generated from another database, so I don't have control over how the raw data organized when it comes to me. I have a variable Age which can go up to a value of 10. This variable determines how many extra variables will be included in the dataset. If the max value of Age is 10, 10 Assessment variables will be in the dataset: Assessment1 to Assessment10. If the max value of Age is 4, 4 Assessment variables will be in the dataset: Assessment1 to Assessment4. When i recive the dataset if the max value of Age is 4 there won't be Assessment5, Assessment6, Assessment7, Assessment9, Assessment10 in that particular set. So, there are 10 different possible versions. I wanted to try and write the program so i would not have to change the code to reflect how many Assessment Variables are brought in. Does this make more sense? Thanks so much.

Mgarret · ‎01-10-2012

Hi all— I have two issues. Any assistance on either will be greatly appreciated #1 I've posted regarding this issue a once already but I’m still having some trouble. I have to merge two datasets together and the variables need to go into a certain order for presentation purposes. There are variables which I have to bring in using the wildcard symbol “:” because the number of variables with various question prefixes will vary from dataset to dataset (Q52a_1 Q52a_2 Q52a_3 Q52a_4……) Below was one suggestion. I have been playing on variations of this and I can’t get it to work data Want; merge Have1 (keep= Case_Number) Have2 (keep=ID ) Have1 (keep=FirstName) Have1 (keep=LastName) Have2 (keep=Q52a:) Have1 (keep=Agency_Name) Have2 (keep=Q57a:) Have2 (keep=Q5) Have1 (keep=Program_Name) Have1 (keep=Q4) Have2 (keep=Q64:) ; by ID ; run; #2 In addition, I need to define the variables that are brought into the dataset Want by the value of a variable (in this case Age). I know the example below is TOTALLY wrong but I’m just trying illustrate the issue. data want; merge Have1 Have2; if Have1 age=1 then do; Have1 (keep= Case_Number) Have2 (keep=ID ) Have1 (keep=FirstName) Have1 (keep=LastName) Have2 (keep=Q52a:) Have1 (keep=Agency_Name) Have2 (keep=Q57a:) Have2 (keep=Q5) Have1 (keep=Program_Name) Have1 (keep=Q4) Have2 (keep=Q64:) Have1 (keep=Assessent1); Output want; if Have1 age=2 then do; Have1 (keep= Case_Number) Have2 (keep=ID ) Have1 (keep=FirstName) Have1 (keep=LastName) Have2 (keep=Q52a:) Have1 (keep=Agency_Name) Have2 (keep=Q57a:) Have2 (keep=Q5) Have1 (keep=Program_Name) Have1 (keep=Q4) Have2 (keep=Q64:) Have1 (keep=Assessent1) Have1 (keep=Assessent2); Output want; if Have1 age=3 then do; Have1 (keep= Case_Number) Have2 (keep=ID ) Have1 (keep=FirstName) Have1 (keep=LastName) Have2 (keep=Q52a:) Have1 (keep=Agency_Name) Have2 (keep=Q57a:) Have2 (keep=Q5) Have1 (keep=Program_Name) Have1 (keep=Q4) Have2 (keep=Q64:) Have1 (keep=Assessent1) Have1 (keep=Assessent2) Have1 (keep=Assessent3); Output want; if Have1 age=4 then do; Have1 (keep= Case_Number) Have2 (keep=ID ) Have1 (keep=FirstName) Have1 (keep=LastName) Have2 (keep=Q52a:) Have1 (keep=Agency_Name) Have2 (keep=Q57a:) Have2 (keep=Q5) Have1 (keep=Program_Name) Have1 (keep=Q4) Have2 (keep=Q64:) Have1 (keep=Assessent1) Have1 (keep=Assessent2) Have1 (keep=Assessent3) Have1 (keep=Assessent4); Output want; by ID ; run; Again, thanks!

Mgarret · ‎01-07-2012

Ok. Thanks. I am not too familar with the retain statement so it might be easier for me to just make another datastep.

Mgarret · ‎01-07-2012

Ok. I see... and then use another Data step to organize the variables in their correct order, right?

Mgarret · ‎01-07-2012

Hi all-- I am trying to merge two datasets together. When the datasets are merged the variables need to go in a certain order. For dataset Have2 I have series questions which all start with the same prefix like Q15_1 Q15_2 Q15_3...... or like Q55_1 Q55_2 Q55_3 Q55_4 Q55_5....... The value _# tagged on the end of the variable can change. To take this into account im useing the wildcard ":" to generate lists of variables with these prefixes. Please see my code below. Here is my issue: Variables that start with Q55 or Q15 wich are also contained in Have1 are being pulled in to Want, which they should not be. These types of variables need to only be pulled in from Have2. Again, the variables brought in from Have1 and Have2 must fall into a certain order for Want. data Want; merge Have1 Have2; keep CASE_NO /*from Have1 */ Agency_Name /*from Have1 */ Program_Name /*from Have1 */ Q55: /*from Have2 */ CONNX_CaseID /*from Have1 */ Q15: /*from Have2 */ Case_Name /*from Have1 */ Case_Age /*from Have1 */ by CASE_NO; run; Any help is greatly aperciated. Thank you.

Mgarret · ‎01-06-2012

Thanks you. Question: I'm not sure what the parts in the code ive bolded mean..... array Q3_ {5} 8. (5*2); array Q17_ {9} 8. (9*20); array Q41_ {10} 8. (10*1); array Q52_ {10} 8. (10*1);

Mgarret · ‎01-06-2012

Thanks. I have tried that and it does not seem to work with multiple questions.

Mgarret · ‎01-06-2012

Hi all-- A have a series of datasets with variables that start with a prefix such as Q30_ , Q41_ , Q52_. The variables all have a value tagged onto the end. Example: Q30_ 1, Q30_ 2, Q30_ 3 and so on. The amount of varibles will be different in each dataset -- so each dataset can be different depending on how many variables with a certain prefix are generated. The dataset could look like this: Q30_1 Q30_2 Q30_3 Q30_4 Q30_5 Q41_1 Q41_2 Q41_3 Or the dataset could look like: Q30_1 Q30_2 Q30_3 Q41_1 Q41_2 Q41_3 Q41_4 Q41_5 Q41_6 Q41_7 I need to merge these variables with prefixes into other datasets. Example: For Dataset A, I need to bring in all the variables which start with Q52_, Q3_ and Q17_ from Dataset B which still need to be in numerical order by the value they have tagged on to the prefix. And then I need to bring in the variables LastName, Agency and Status from Dataset C. So the Final Dataset could look like this: FirstName LastName Q52_1 Q52_2 Q52_3 Agency Q3_1 Q3_2 Q3_3 Q3_4 Status Q17_1 Q17_2 Q17_3 Q17_4 The amount of variables that can be brought in could be different every time. So in another situation Q52_ goes up to Q52_14 and Q17_ only goes up to Q17_2 Can a create an array using each variable Prefix (im not sure how to do that)? Is there a way to select only the variables that start with "Q30_" and then select only the variables which start with "Q55_" and so on ? Any assistance is greatly appreciated. Thanks.

Mgarret · ‎12-30-2011

Thanks Tom and Art. Tom, your version was perfect for analysis. I can now effectively count the frequencies of all different interventions. This is great! Art, your version is perfect for manipulating the data to send out to agencies. Please see the version i used below . Thanks so Much! data Pre.Q60 (keep=Agency_Name Case_No Case_FirstName Case_LastName cra60_); set Pre.Presheet1; i=1; do while (scan(cra60,i,";") ne ""); cra60_=input(scan(cra60,i,";"),12.); output; i+1; end; Proc sort data= Pre.Q60; by Case_No; proc transpose data=Pre.Q60 out=Pre.Q60 (drop=_:) prefix= cra60_; var cra60_ ; format cra60_ cra60format.; by Case_No; run;

Mgarret · ‎12-30-2011

Thanks Tom and Art. Tom, your version was perfect for analysis. I can now effectively count the frequencies of all different interventions. This is great! Art, your version is perfect for manipulating the data to send out to agencies. Please see the version i used below . Thanks so Much! data Pre.Q60 (keep=Agency_Name Case_No Case_FirstName Case_LastName cra60_); set Pre.Presheet1; i=1; do while (scan(cra60,i,";") ne ""); cra60_=input(scan(cra60,i,";"),12.); output; i+1; end; Proc sort data= Pre.Q60; by Case_No; proc transpose data=Pre.Q60 out=Pre.Q60 (drop=_:) prefix= cra60_; var cra60_ ; format cra60_ cra60format.; by Case_No; run;

Mgarret · ‎12-30-2011

Thanks! last question: Where do I assign the format definitions for each value? So if I create a format cra60f do I add it to proc transpose? proc transpose data=Pre.Q60 out=Pre.Q60 (drop=_:) prefix= cra60_; var cra60_ ; by Case_No; run;

Mgarret · ‎12-30-2011

Hi Tom. Thank youaginin for your help. I got your code to work but I amstill not sure what these 3 lines of code mean. i = input(next,??best.); if i ne . then cra60_(i)=1; else put case= cra60= j= next= next $hex. ; end; The variables Next, i and j mean what? I can't seem to find a description for the format $hex. Again, thanks for all your help today!

Mgarret · ‎12-30-2011

Hi Art-- Where do I assign the format definitions for each value? So if I create a format $cra60f do I add it to proc transpose? proc transpose data=Pre.Q60 out=Pre.Q60 (drop=_:) prefix= cra60_; var cra60_ ; by Case_No; run;

Online Status	Offline
Date Last Visited	‎10-18-2017 05:30 PM

Proc fastclus: Relative importance of Variables within Clusters

Re: Identifying Lapsed Customers

Re: Identifying Lapsed Customers

Re: Identifying Lapsed Customers

Re: Identifying Lapsed Customers

Re: Identifying Lapsed Customers

Re: Identifying Lapsed Customers

Identifying Lapsed Customers

Re: Multi Sheet Excel Workbook Macro Using tagsets.excelx - Only 1 She...

Re: Multi Sheet Excel Workbook Macro Using tagsets.excelx - Only 1 She...

Re: Identifying Lapsed Customers

Re: Identifying Lapsed Customers

Re: Combining two Arrays which use regular expressions

Re: Combining two Arrays which use regular expressions

Re: tagsets.excelxp and Proc Report: Sheet Formatting/ Styling Questio...

Spanned Header: Changing the font size/type and background color

Re: Spanned Header: Changing the font size/type and background color

Re: Changing a character date var to a real date var

Forming Datasets Conditionally

Forming Datasets Conditionally

Forming Datasets Conditionally

Forming Datasets Conditionally

Issue Merging Two Datasets

Issue Merging Two Datasets

Issue Merging Two Datasets

Selecting Alternating Sets of Variables

Selecting Alternating Sets of Variables

Selecting Alternating Sets of Variables

Re: Delimiting Codes in a Single Variable into Multiple Variables

Re: Delimiting Codes in a Single Variable into Multiple Variables

Delimiting Codes in a Single Variable into Multiple Variables

Delimiting Codes in a Single Variable into Multiple Variables

Delimiting Codes in a Single Variable into Multiple Variables