About deleted_user

deleted_user · ‎03-15-2011

This is my code where I first pull the data usin PROC SQL. select c.* ......, order1, order2 from table1 a join table 2 b on a.id=b.id join table3 c on b.cd= c.cd PROC SORT DATA=s_tmp OUT= s_sort nodupkey; BY id , cd ; RUN ; And my data looks like this: ID Code seq_no1 seq_no2 Order1 Order2 1 A 1 1 seq_no1 seq_no2 1 A 2 2 seq_no1 seq_no2 1 B 2 2 seq_no2 seq_no1 1 B 1 1 seq_no2 seq_no1 So now within an ID , I have different codes, so I want to first order by Code(eg A,B) and then Order by the values in column Order1 and Order2. So Order1 has Seq_no1 for Code A, so within Code A , I would like to order by Seq_no1 and then by Seq_no2. However within code B, first I need ot order by Seq_no2 and then by seq_no1. So a simple 'order by Order1' will not work here. Can u help me with using proc compare of a merge here?

deleted_user · ‎03-15-2011

This is my code where I first pull the data usin PROC SQL. select c.* ......, order1, order2 from table1 a join table 2 b on a.id=b.id join table3 c on b.cd= c.cd PROC SORT DATA=s_tmp OUT= s_sort nodupkey; BY id , cd ; RUN ; And my data looks like this: ID Code seq_no1 seq_no2 Order1 Order2 1 A seq_no1 seq_no2 1 A seq_no1 seq_no2 1 B

deleted_user · ‎03-15-2011

I am actually trying to merge several messages under one ID into one message for each ID. Kind of forming a story for each id. This is a business requirement. Any pointers to tackle this?

deleted_user · ‎03-15-2011

Scott, You are correct in your assumptions - the sequential dataset IS intended to replace the hard-coded values. I have not worked with PROC FORMAT before, but I will give your suggestion a try and let you know how it works. Your help is greatly appreciated - I know only a little SAS, so did not know where to even start looking for the answer.. Thanks, GES60

deleted_user · ‎03-15-2011

Apologies in advance for long winded question but any help would be greatly appreciated I need some help with a macro that will loop through data and write data to spreadsheet depending on 2 variables (the Branch and the Ref No) One data set contains sales data. Columns include ‘Branch name’, ‘Policy number’, and ‘Ref No’. This will be a daily programme and the ranges are dynamic. My aim is to create an excel spreadsheet by branch for any instance, if any, where the ‘Ref No’ field is blank and then email the output as attachment to the relevant branch If the Ref No field is not blank, no email is required. I also need some form of summary function so that if there are 3 entries for the London branch with blank Ref No field then 1 email as opposed to 3 is generated . Code I have so far can only generate output by a predefined excel template and send to one email address so is very limited: data test1; set dublindata; if Refno ne "" then delete; run; /*write reults to Excel sheet*/ libname xls pcfiles server=&_clientmachine PORT=8621 path="\\saspcomp01\C\Andy\Testsheet.xls"; proc sql; drop table xls.Testarea; quit; data xls.Testarea(dblabel=yes); set test1; run; libname xls clear; /*email excel sheet*/ filename mymail email "Blah@blah.co.uk" subject="Missing Ref No" attach=("/sas/C/Andy/Testsheet.xls" content_type="application/excel"); data _null_; file mymail; put 'Hi. '; put 'Could you please provide me with the relevant Ref No for the attached cases. '; put 'Regards '; put 'Andy '; run;

deleted_user · ‎03-14-2011

Hi ! I have a table which has one column , say order1. I want to use the value in order1 to actually order my sas dataset. Say if order1 = id, then i want to order my sas datset by id. How can we acheive this? Thanks!!

deleted_user · ‎03-14-2011

I am transposing the dataset and then using a catX on it. So if the no of records under one id is say 100, then 100 variables are created after transpose and when I concatenate them into one, it exceeds 32767 chars. Is there a way, where we can detect when the chars become greater than 32KB and we can split the recors into 2 records.

deleted_user · ‎03-14-2011

Re KSharp-- thanks for the response also. As above, yes, there are multiple data points for each subject. We haven't used a repeat statement because we weren't happy with the proc mixed fit that we got because there was too much shrinkage of the data points towards a global mean. In this case we are interested in classifying each data point individually and we don't want to mis-classify individual subjects just because they are biased by the mean behavior. We are trying to use proc glm to get individual fits for each subject that are not biased by the mean behavior (like doing an individual regression for each subject, but with a common pooled variance for all subjects rather than an independent variance for each subject). I hope that helps clarify what we're trying to achieve. Thanks for commenting.

deleted_user · ‎03-14-2011

Hi Dale, thanks for the response. I have 5862 subjects-- we've run a mixed model with random subject effects and we were able to fit that OK. We have been advised by a statistician to use a pooled variance regression to obtain individual subject-specific equations because this best preserves the heterogeneity amongst subjects compared to subject equations extracted from the repeated measures model. However, we may need to go to this route if in fact our computers do not have sufficient RAM to conduct a pooled variance regression with this many subjects. We just wanted to make sure that this was indeed a RAM limitation and not a problem with the software that could be fixed through tech support.

deleted_user · ‎03-14-2011

Hello, if you like data steps you can use a proc sql-data step solution: [pre] *consecutive years; proc sql noprint; select cats('yr',min(year)), cats('yr',max(year)),min(year),max(year) into :yr_min, :yr_max, :lb, :hb separated by ' ' from names; quit; data want; do until(last.id); set names; by id; array yr{&lb:&hb} $ 12 &yr_min-&yr_max; yr{year}=name; end; drop year name; run; *Universal; proc sql noprint; select cats('yr', years) into :all_y separated by ' ' from (select distinct(year) as years from names) order by years ; quit; data want1; do until(last.id); set names; by id; z=countw(substr("&all_y",1,findw("&all_y",cats('yr',year))+5)); array yr{*} $ 12 &all_y; yr{z}=name; end; drop year name z; run; [/pre] Marius

deleted_user · ‎03-14-2011

I created an ARIMA model in SAS, but I need to implement the formula for the forecasts in Excel. Below is the SAS code for the model. The model is AR(5,10,15,20) MA(1,5) with differencing of 5 periods. proc arima data=test; identify var=calls (5) nlag=49; estimate p=(5 10 15 20) q=(1 5); run; I tried using Y(t)-Y(t-5)=Mu+MA/AR, but the forecasts on the spreadsheet are still different from the SAS output. This notation is based on a document from SAS Support here: http://support.sas.com/documentation/cdl/en/etsug/60372/HTML/default/viewer.htm#etsug_tffordet_sect016.htm Can you please help me with translating the ARIMA forecast to Excel? Thank you. Valentin

deleted_user · ‎03-14-2011

I need to replace an existing INVALUE with a sequential dataset, and do not have clue 1 on how to do this. I am working with SAS 9.1.3 on a z/OS. The existing code looks like this: PROC FORMAT; INVALUE $FEIN '530075853' = '01' '521264413' = '02' '751588101' = '03' '520794134' = '06'; and is then used in an INPUT statement: DATA LIAB; INFILE INPUT01; INPUT @1 COMP $FEIN. @13 LOB $CHAR1. ; after the INPUT is the following: KEEP COMP LOB; The input file will only have 5 or 6 records. Any thoughts or suggestions will be greatly appreciated Thx

deleted_user · ‎03-14-2011

I need to calculate age for a dataset, but all I have is year of birth and the date they entered the program. I need to calculate the approximate age each sample was when they entered the program based on the year of his/her birth and the date they entered the program. I just am not sure the correct program to do this. I know how to do this with two actual dates, but not from a year and a date. Thank you for any help provided. JH

deleted_user · ‎03-14-2011

hello, this is not difficult. just merge "want" database with initial one. this merging will also solve the tiebreaking situation data _null_ refers at: [pre] proc sort data=have out=have_sort; by Country Item Week descending Sales; run; proc sort data=want(rename=(col1=sales)) out=want_sort; by Country Item Week descending Sales ; run; data final; merge want_sort (in=a) have_sort (in=b); by Country Item Week descending Sales ; if a and b; run; [/pre] Marius

deleted_user · ‎03-14-2011

Hello, One solution is offered by proc means with output out statement, combined with transpose procedure: [pre] data have; input Country $ Region $ Item $ Week Sales ; datalines; LV r1 i1 1 12 LV r2 i1 1 11 LV r3 i1 1 10 LV r4 i1 1 15 LV r5 i1 1 13 LT r6 i1 1 12 LT r7 i1 1 10 LT r8 i1 1 11 LT r9 i1 1 18 LT r0 i1 1 20 ; proc means data=have nway noprint; class Country Item Week; output out=want_ntr idgroup(max(sales) out[3] (sales)=)/autoname ; run; proc transpose data=want_ntr out=want (drop=_name_); by Country Item Week; var sales:; run; [/pre] Marius

Online Status	Offline
Date Last Visited	‎09-01-2015 07:02 AM

Output only special characters

Re: Promoting SAS users and groups from SAS 9.2

Promoting SAS users and groups from SAS 9.2

Re: re-assign values for consecutive obs

Re: re-assign values for consecutive obs

re-assign values for consecutive obs

Re: subset in data step

Re: Delimiter for Tab in SAS.

Re: how to Load Row Number in SAS DI

Re: how to Load Row Number in SAS DI

Create a SAS Project Scaffold on the Command Line

Introductions are in order

Using Multiple Containers

Re: Removing permenent libraries?

how to get 0 in out put

Help with calculating the scores

help with array

non-inferiority analysis

Re: Use the value of a variable

Re: Use the value of a variable

Re: CATX function

Re: Replacing PROC FORMAT INVALUE with sequential dataset

Looping Macro to create and email Excel attachment

Use the value of a variable

Re: CATX function

Re: Out of memory error with proc glm

Re: Out of memory error with proc glm

Re: Getting different results with proc transpose

Mathematical form of an ARIMA model

Replacing PROC FORMAT INVALUE with sequential dataset

calculating age using a year and specific date

Re: Is it possible to leave only largest values in table?

Re: Is it possible to leave only largest values in table?