About andy_wk

andy_wk · ‎08-05-2014

I have this code. I have the error below when I'm on the toto data step. WARNING: Apparent symbolic reference TODAY not resolved. Why? %macro t12; %let today=%sysfunc(compress(%sysfunc(today(),yymmddd10.),'-')); %mend; %t12; data toto; itu=put &today; run;

andy_wk · ‎07-31-2014

Thank you so much Haikuo !!!

andy_wk · ‎07-31-2014

I'm trying to get the second to last working day of any month , regardless of the holidays. I've tried with that code but I got stuck especially with the intnx , which is giving me the last day... data tata; test=today(); put test=; run; data toto; set tata; lastDay=intnx('month',"test"d,0,'E'); format lastDay ddmmyy10.; run; I'm welcoming any tips that will unlock me.

andy_wk · ‎07-22-2014

Thanks RW9. It is working great.

andy_wk · ‎07-22-2014

I've got the following file I'm trying to import namq_aux_lp 07.07.2014 namq_aux_ulc 08.07.2014 namq_aux_gph 07.07.2014 prc_hicp_cann 17.07.2014 namq_nace10_k 02.07.2014 sei_bsco_m 10.06.2014 ei_bsin_m_r2 26.06.2014 lassei_bsbu_m_r2 26.06.2014 assei_bsrt_m_r2 26.06.2014 ei_bssi_m_r2 26.06.2014 ei_bsse_m_r2 26.06.2014 ei_bsci_m_r2 26.06.2014 sts_trtu_m 17.07.2014 I've used the following proc import's proc import out=lesdates datafile="C:\work\studies\project\data\calend\bigfilev2.txt" dbms=tab REPLACE; getnames=no; run; proc import out=lesdates datafile="C:\travail\etudes\projetpib\donnees\calend\bigfilev2.txt" dbms=tab REPLACE; delimiter='09'x; getnames=no; run; But each time, instead of having 2 variables, I'm ending with one variable taking the 2 columns var1 ------------------------------ namq_aux_lp 07.07.2014 namq_aux_ulc 08.07.2014 namq_aux_gph 07.07.2014 prc_hicp_cann 17.07.2014 namq_nace10_k 02.07.2014 sei_bsco_m 10.06.2014 ei_bsin_m_r2 26.06.2014 lassei_bsbu_m_r2 26.06.2014 assei_bsrt_m_r2 26.06.2014 ei_bssi_m_r2 26.06.2014 ei_bsse_m_r2 26.06.2014 ei_bsci_m_r2 26.06.2014 sts_trtu_m 17.07.2014 What am I doing wrong??? PS: I can edit the text file but I would like to do the import without touching anything.

andy_wk · ‎07-11-2014

Thanks Xia. Runnin RW9 sql at the moment. Will run yours when everything will be completed. Cheers.

andy_wk · ‎07-11-2014

I've got the following question. I'm trying to run a partial least square forecast on a data model I have. Issue is that I need to block certain line in order to have the forecast for a specific time. What I want would be the following. For June, every line before May 2014 will be blocked (see the screenshot below). For May , every line before April 2014 will be blocked (see the screenshot below). I was thinking of using a delete through a proc sql to do so but this solution seems to be very brutal and I wish to keep my table intact. Question : Is there a way to block the line for a specific date with needing a deletion? Edit : The aim of the blocking will be to use the missing values and to run the forecast on this missing month namely here in June 2014 and in May 2014 for the second example. Plus: The mixture of English and French is normal because I've exported the file in a CSV format for a better vizualisation. Many thanks for any insight you can give me as I've never done that before and don't know if there is a way to do that (I did not find anything on the net).

andy_wk · ‎07-11-2014

Thanks RW9. It is working fine. This is the first time I'm seeing something like what you did. Definitely useful.

andy_wk · ‎07-11-2014

One more question RW9. In your query where BASE.VAR91001_t0 is null and not exists(select distinct THIS.VAR91001_t0 from WORK.HAVE THIS where THIS.NOUV_DATE > BASE.NOUV_DATE and THIS.VAR91001_t0 ne .)); How do you use specific variable name instead of VAR91001_t0 ?

andy_wk · ‎07-11-2014

RW9, Definitely do what I want but I need to have all the variables (around 5000). Is there a way to have them all? Cheers.

andy_wk · ‎07-11-2014

Hi RW9, Don't let me start on that. Thinking about drinking in the morning. Just kidding. I have a try.

andy_wk · ‎07-11-2014

I've got this table. I want to know which variables has only missing values after a specific date (like September 2013 or any other date I will put) e.g var910001_t0 or var91059_t0 will be associated with September 2013. I'm showing you here, the variables that have only missing values after September 2013 but it can be June 2014. I thought about doing a proc sql but it does not seem to do what I want. I thought about doing an array but I'm not that familiar with Array yet. Any help will be welcome as I've never done this before.

andy_wk · ‎07-08-2014

I found my answer. proc sql; update dicofr as h1 set period=(select period from correspondance as h2 where h1.name_fic=h2.name_fic) where name_fic in (select name_fic from correspondance); quit;

andy_wk · ‎07-08-2014

It should be an easy one but I'm stuck Proc sql; UPDATE dicofr SET dicofr.period = correspondance.period FROM dicofr INNER JOIN correspondance ON dicofr.name_fic = correspondance.name_fic; I was thinking my update would be done but I got this error instead. 271 proc sql; 272 update dicofr 273 set dicofr.period = correspondance.period - 73 76 ERROR 73-322: Expecting an =. ERROR 76-322: Syntax error, statement will be ignored. I've tried with a straight join with a select proc sql; SELECT * FROM dicofr INNER JOIN correspondance ON dicofr.nom_fic=correspondance.nom_fic; The select is fine. How come? Is my SQL query not correct? I don't think so ... Edited: It seems the update I want to do is not possible. Is there a way to do what I want with SAS language?

andy_wk · ‎06-20-2014

Paige, I've replaced the code as such data dico&&pays&l..1 ; set dico&&pays&l (keep=varname); call symputx('nvarname'||left(_n_),varname); run ; proc sql; insert into toto SELECT max(nouv_date),"&nvarname" FROM a&&pays&l.._1 WHERE (&nvarname ne .); And I got this error (see below) ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER.

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

Re: after a proc sql create table with a primary key , how do you do a...

Re: after a proc sql create table with a primary key , how do you do a...

Re: after a proc sql create table with a primary key , how do you do a...

after a proc sql create table with a primary key , how do you do an im...

Re: update a field by removing quarter or removing month

update a field by removing quarter or removing month

Re: how to define the lastest time of publication for a time serie

Re: how to define the lastest time of publication for a time serie

how to define the lastest time of publication for a time serie

Re: interpret the PLS regression

Re: table update with condition

Re: proc pls and logarithm

issue with the code

Re: Getting the second to last working day

Getting the second to last working day

Re: proc import

proc import

Re: knowing when there are only missing values

blocking the values after a specific date

Re: knowing when there are only missing values

Re: knowing when there are only missing values

Re: knowing when there are only missing values

Re: knowing when there are only missing values

knowing when there are only missing values

Re: table update with condition

table update with condition

Re: macro into a table and a macro variable with sas