About rishabhmehra13

rishabhmehra13 · ‎10-04-2016

Hi, i am having problems using mcros.Not getting the desired output data cudata; input ID Orderdate$ Model$12. Quantity ; cards; 287 15OCT03 DeltaBreeze 15 287 15OCT03 SantaAna 15 274 16OCT03 JetStream 1 174 17OCT03 SantaAna 20 174 17OCT03 Noreaster 5 174 17OCT03 Scirocco 1 347 18OCT03 Mistral 1 287 21OCT03 DeltaBreeze 30 287 21OCT03 SantaAna 25 run; %macro cus(dsn); %if &sysday=Monday %then %do; proc print data=&dsn; run; %end; %else %if &sysday=Thursday %then %do; proc tabulate data=&dsn; class ID; var Quantity ; table ID,Quantity; run; %end; %mend cus; %cus(cudata); log NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended.

rishabhmehra13 · ‎09-26-2016

I am still not getting the desired output. both the data sets have the same values of probability and other columns too which i require but i want that the output should be all the required columns of set 1 and only 1 column to be joined to that set 1based on probability,i dont want repeating probabilities. proc sql; create table p1 as select a.Probability____ , a.Account_Name as client ,a.Opportunity_Owner as champ, a.Last_Modified_Date as modified , sum(a.Total_Media_Value) as Tot_Budget,a.Deal_Comments, b.Total_Media_Value as Digital_bdgt from d.p3 as a left join dig as b on a.Probability____= b.Probability____ group by a.Probability____ order by a.Probability____ desc; quit; ##- Please type your reply above this line. Simple formatting, no attachments. -##

rishabhmehra13 · ‎09-26-2016

i want to join table d.p4 with dig ,Probability is the id proc sql; create table p1 as select a.Account_Name as client ,a.Opportunity_Owner as champ, a.Last_Modified_Date as modified , sum(a.Total_Media_Value) as Tot_Budget,a.Deal_Comments, b.Total_Media_Value as Digital_bdgt from d.p3 as a left join dig as b on a.Probability____= b.Probability____ group by Probability____ order by Probability____ desc; quit; log 63 group by Probability____ 64 order by Probability____ desc; ERROR: Ambiguous reference, column Probability____ is in more than one table. ERROR: Ambiguous reference, column Probability____ is in more than one table.

rishabhmehra13 · ‎09-22-2016

its sorted by probabilty ##- Please type your reply above this line. Simple formatting, no attachments. -##

rishabhmehra13 · ‎09-22-2016

data sas2; set d.p3; by Probability____; if first.Probability____=1 then tot_budget=0; tot_budget+Total_Media_Value; if last.Probability____ then output; if Probability____=0 then delete; run; still getting the same error log ERROR: BY variables are not properly sorted on data set D.P3.

rishabhmehra13 · ‎09-22-2016

Hi, I want a sum of total media value grouped by probability the data set is already sorted by me data sas1; set d.p3; by Probability____; if first.Total_Media_Value=1 then tot_budget=0; tot_budget+Total_Media_Value; if last.Total_Media_Value then output; run; log NOTE: Variable first.Total_Media_Value is uninitialized. NOTE: Variable last.Total_Media_Value is uninitialized. ERROR: BY variables are not properly sorted on data set D.P3.

rishabhmehra13 · ‎09-15-2016

my question is write a macro that prints a detail report if you run it on monday and a summary report if you run it on friday(no other days) now what should i do? ##- Please type your reply above this line. Simple formatting, no attachments. -##

rishabhmehra13 · ‎09-15-2016

Getting this error neither thr print option nor a valid output statement has been given ##- Please type your reply above this line. Simple formatting, no attachments. -##

rishabhmehra13 · ‎09-15-2016

data cudata; input ID Orderdate$ Model$12. Quantity ; cards; 287 15OCT03 DeltaBreeze 15 287 15OCT03 SantaAna 15 274 16OCT03 JetStream 1 174 17OCT03 SantaAna 20 174 17OCT03 Noreaster 5 174 17OCT03 Scirocco 1 347 18OCT03 Mistral 1 287 21OCT03 DeltaBreeze 30 287 21OCT03 SantaAna 25 run; %macro cus(dsn); %if &sysday=Monday %then %do; proc print data=&dsn; run; %end; %else %if &sysday=Thursday %then %do; proc summary data=&dsn; class ID; var Quantity ; run; %end; %put SYSDAY=&sysday; %mend cus; %cus(cudata);

rishabhmehra13 · ‎09-15-2016

Still the same no result.No i want to run it for thursday to give the summary.i have changed the sysday frm friday to thursday now? ##- Please type your reply above this line. Simple formatting, no attachments. -##

rishabhmehra13 · ‎09-15-2016

If it is run on monday then print a detaik report and if on friday then a summary report (no other day) ##- Please type your reply above this line. Simple formatting, no attachments. -##

rishabhmehra13 · ‎09-15-2016

Hi, still the same result, any other thing that can be done? ##- Please type your reply above this line. Simple formatting, no attachments. -##

rishabhmehra13 · ‎09-15-2016

data cudata; input ID Orderdate$ Model$12. Quantity ; cards; 287 15OCT03 DeltaBreeze 15 287 15OCT03 SantaAna 15 274 16OCT03 JetStream 1 174 17OCT03 SantaAna 20 174 17OCT03 Noreaster 5 174 17OCT03 Scirocco 1 347 18OCT03 Mistral 1 287 21OCT03 DeltaBreeze 30 287 21OCT03 SantaAna 25 run; %macro cus(dsn); %if &sysday=monday %then %do; proc print data=&dsn; run; %end; %else %if &sysday=friday %then %do; proc summary data=&dsn; class ID; var Quantity ; run; %end; %mend cus; %cus(cudata) No errors are coming up but still not getting the desire output

rishabhmehra13 · ‎09-14-2016

proc sql; creat table q6 as select a.PRODUCT_ID,a.churn_month,b.* from d.p3 as a left join lab as b on a.PRODUCT_ID ne b.PRODUCT_ID; QUIT; lab table has 100000 records log 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 proc sql; 57 creat table q6 as _____ 1 WARNING 1-322: Assuming the symbol CREATE was misspelled as creat. 58 select a.PRODUCT_ID,a.churn_month,b.* 59 from d.p3 as a left join lab as b 60 on a.PRODUCT_ID ne b.PRODUCT_ID; NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized. WARNING: Variable PRODUCT_ID already exists on file WORK.Q6. ERROR: Insufficient space in file WORK.Q6.DATA. ERROR: File WORK.Q6.DATA is damaged. I/O processing did not complete. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 61 62 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 1:01.75 cpu time 21.80 seconds

rishabhmehra13 · ‎09-04-2016

libname r '/folders/myfolders'; proc import datafile='folders/myfolders/Loans.csv' dbms=csv out=r.per replace; run; proc print data=r.per; run; log NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/folders/myfolders/Loans.csv. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.18 seconds cpu time 0.18 seconds 63 64 proc print data=r.per; ERROR: File R.PER.DATA does not exist. 65 run;

Online Status	Offline
Date Last Visited	‎10-04-2016 10:05 AM

Using a macro variable to name a datastep

Re: Problem while merging

Problem while merging

Re: Problem usng PDV

Re: Problem usng PDV

Problem usng PDV

Re: probelm using macro

Re: probelm using macro

Re: probelm using macro

Re: probelm using macro

Using a macro variable to name a datastep

Re: Problem while merging

Problem while merging

Re: Problem usng PDV

Re: Problem usng PDV

Problem usng PDV

Re: probelm using macro

Re: probelm using macro

Re: probelm using macro

Re: probelm using macro

Re: probelm using macro

Re: probelm using macro

probelm using macro

ERROR: Insufficient space in file WORK

Problem using import