An Idea Exchange for SAS software and services

Comments
by SASTestUser
on ‎04-12-2012 08:09 PM

Great tip.  Thank you, Renee.

by New Contributor DRSmith
on ‎04-19-2012 01:45 PM
Don't be afraid.  I am a professional.
by New Contributor DAnkrah
on ‎07-29-2014 11:55 AM

Hello,

I just installed SAS University Edition on my laptop. When i pressed SAS start studio to have a feel of the platform I got this message: "the launch of the server process failed with an unknown status code". What should i do now? Can anyone help?

Kind regards,

Daniel

by SAS Employee reneeharper
on ‎07-29-2014 01:00 PM

Daniel,

Your comment has a much better chance of being answered if you post it to . I will post it there for you. Be sure to look for it.

The direct link to your question is

by New Contributor DAnkrah
on ‎07-31-2014 04:45 PM

Thank you for your help. Nevertheless, I am still not connected.

Cheers

by dineshshashtri
on ‎02-04-2015 02:47 AM

Hi,

I want to fetch data from a dataset(BASE_BOTOX) and add the observations to a new dataset(FLAG_BASE) only if not found in HIST_TEST dataset.

but I am not sure How to increment the date after each execution. Please help..

I am writing the below code:-

%let dsn=1;

%let start_dt= %sysevalf('1FEB2014'd);

%let end_dt = %sysevalf('3FEB2014'd);

/*%LET L=%EVAL(%qsysfunc(inputn(&end_dt.,8.)) - %qsysfunc(inputn(&start_dt.,8.)));*/

%LET L=%sysevalf(&end_dt.-&start_dt.);

%put &L. &start_dt. &end_dt.;

%let inDS=base_botox1;

%let day=day;

%let interval=1;

%let align=sameday;

%mac1(start_dt1=&start_dt.,end_dt1=&end_dt.);

%macro mac1(start_dt1=,end_dt1=);

%do dt = 1 %to &L. %by 1;

data temp_&dsn.;

set &inDS.;

where clm_pd_dt between %sysfunc(intnx(&day.,&start_dt1.,&L.,'s')) and &end_dt1.;

run;

proc sql;

create table flag_&dsn. as

select * from temp_&dsn.

where mbr_sys_id not in(select mbr_sys_id from btx.hist_test);

quit;

proc append base=flag_base data=flag_&dsn.;

run;

proc append base=btx.hist_test data=flag_&dsn.;

run;

%mend;

by SAS Employee CommAdmin
on ‎02-05-2015 03:15 PM

Hi there .. you have posted a question at the bottom of a document. If you could please post your question in one of these communities you will have a better chance of getting an answer.

Thanks for being part of Communities on SAS Smiley Happy

by Occasional Learner Tanichiwa
on ‎07-11-2015 10:06 AM

Hi there, I am using SAS university edition, and I am new to this.

data work.price_increase;

   set orion.prices;

run;

proc print data=work.price_increase;

var Product_ID Unit_Price Year;

run;

The code that I executed is not working.I get errors.

ERROR: File ORION.PRICES.DATA does not exist.

ERROR: Variable PRODUCT_ID not found.

ERROR: Variable UNIT_PRICE not found.

ERROR: Variable YEAR not found.

Can someone help me please. Thank you.

by SAS Employee reneeharper
on ‎07-13-2015 03:20 PM

Hi Tanichiwa

You will have much better luck if you post this question to the community. Many users and support folks hang out there.

Good luck.

Renee

Idea Statuses
Top Liked Authors