Hi all, This might be a simple question: I have week and year information, how can I get the corresponding month? Thanks a lot! Lizi ... View more

Hi community, I am trying to examine correlation between two variables by group, and there are over 100 groups. What would be a quick and efficient to do that rather than running corr/reg group by group? For example, I have variables group, var1 and var2 in data "have". There are over 100 groups (1-150), and each group has around 50 observations. I need to get correlation between var1 and var2 by group. My dumb way is: proc corr data=work.have;      var var1 var2;     where group=1; run; Thank you all. Lizi ... View more

,Hi, When I tried to import a zipped csv file to SAS, the data was imported successfully. But the values of the date variable are all missing. Below is the sample data: Sale_date city_cd brand MODEL_YEAR Units 1/1/2013 501 CV 2013 1 1/1/2013 501 CV 2013 1 1/1/2013 CV 2013 1 1/1/2013 609 A 2013 1 1/1/2013 717 CV 2012 1 1/1/2013 717 GM 2013 1 1/1/2013 619 CV 2012 1 1/1/2013 619 CV 2013 1 1/1/2013 613 CV 2013 1 1/1/2013 676 CV 2013 1 I used the following statement: filename sale SASZIPAM 'C\Sales.zip'                                                                                                                      member="Sales.csv";                                                                                                                                                                                                                                           data newdata;                                                                                                                               infile sale (Sales.csv) DLM='2C0D'x dsd missover firstobs=2;                                                                            input Sale_date City_CD Brand $ MODEL_YEAR Units;                                                                                 run; I also tried to set the date variable as character through the statement: data newdata;                                                                                                                               infile sale (Sales.csv) DLM='2C0D'x dsd missover firstobs=2;                                                                            input Sale_date $ City_CD Brand $ MODEL_YEAR Units;                                                                                 run; This way the values of the date variable are truncated. Anyone has any suggestions? Thank you. ... View more

Hi everyone, I am trying to read tables stored in sql server in SAS (configuration has been set up). This is my very first time to read files in the configuration setting. I set the library by the following statement: libname sql odbc dsn=’sqldb’; Then I checked what files in the library "sql": proc sql; connect to odbc(dsn=’sqldb’); create table test as select * from connection to odbc (ODBC::SQLTables);                                                               quit; proc contents data=test; run; I can see tables and views in the temporary file ‘test’. But when I tried to set a table based on the file ‘table1’ in the "sql" library, it says there is no such file. data new;   set sql.table1; run; Did I read the file from SQL server in SAS in a right way? Please suggest! Millions of thanks. Lizi ... View more

Is there a quick and more efficient way to rewrite the procedure below? data a;set a;   if var_ctg_1=1 | var_1=1 then var1=1;   if var_ctg_2=1 | var_2=1 then var2=1;   if var_ctg_3=1 | var_3=1 then var3=1;   if var_ctg_4=1 | var_4=1 then var4=1;   if var_ctg_5=1 | var_5=1 then var5=1; run; Thanks a lot. Lizi ... View more

Hi all, I've got decent help here and am still looking for more. This time I am trying to find records with minimum values. My sample data looks like below: personid days_gap 1 0 1 0 1 10 1 10 1 10 1 15 2 9 2 9 2 9 2 9 2 24 2 24 2 30 2 30 3 1 3 6 3 6 3 8 3 8 3 8 3 9 3 9 3 9 My target data is personid days_gap 1 0 1 0 2 9 2 9 2 9 2 9 3 1 That is, I want to find records with minimum value of days_gap for each personid. Does anyone know a way to do it? Thanks a lot as always! Lizi ... View more