About spastranas

spastranas · ‎05-11-2021

Have the following logic I would like to code. After a client places an order, it has to wait a ceirtan number of days before they are elegible to place a second order. I need to look at each transaction and determine if the order is elegible or not (if enough days have passed). example: if the client places and order in Jan 1st, and the days to wait are 10, the next elegible order will be on Jan10. there can be transactions in between, but they wont be elegible. The first transaction for the client should always be marked as elegible. so the data I have in the following: data Have; input client ordernumber daysTowait orderDate :ddmmyy10. ; format mydate ddmmyy10.; datalines; 1 1 10 01/01/2021 1 2 10 03/01/2021 1 3 10 25/01/2021 1 4 10 25/01/2021 2 1 10 01/02/2021 2 2 10 03/02/2021 2 3 10 05/02/2021 ; run; I would lke to write a query that returns the following based on the data I have 　 data want; input client ordernumber daysTowait orderDate :ddmmyy10. NextElegibilityDate :ddmmyy10. isElegible $ ; format mydate ddmmyy10.; datalines; 1 1 10 01/01/2021 01/01/2021 Yes 1 2 10 03/01/2021 10/01/2021 No 1 3 10 25/01/2021 10/01/2021 Yes 1 4 10 25/01/2021 04/02/2021 Yes 2 1 10 01/02/2021 01/02/2021 Yes 2 2 10 03/02/2021 10/02/2021 No 2 3 10 05/02/2021 10/02/2021 No ; run; Any help would be appreciated.

spastranas · ‎09-16-2020

I need to transpose each row and use the correct format. I was hoping I could import all as numeric rather than percent, so that I can format it after I have transposed the data.

spastranas · ‎09-16-2020

Thank you. The task at hand, is to take the report as it is, and automate the transposing of the columns so that it can be consumed in tableau. Thus, why I need to figure out how it import as number rather than percent.

spastranas · ‎09-15-2020

I am importing an excel file, but the dataset that is returned, has all my values as percent. so while I would expect to see a value of 266000, the dataset returns 266000000% I attached the example excel file. Here is the code that I am using: PROC IMPORT OUT= MyData DATAFILE= "&Dir.Test.xlsx" DBMS=XLSX REPLACE; SHEET="ex"; GETNAMES=No; DATAROW=7; RUN; Any suggestions on how to return the values with no format? I appreciate any help I can get! Sandra

spastranas · ‎08-19-2020

spastranas · ‎08-19-2020

Anyone knows why would it be grayed out, and how to enable it? any help would be appreciated it.

spastranas · ‎08-19-2020

I will set up a maintenance task that re-creates the table with the index, in a regular basis. I have not decided how often, I will have to see how fast the performance degrades. For the delete, I will just use a Proc sql delete statement, but the modify performed just as fast. My job will go from 2 hours to 15 minutes. However the maintenance task will take from 30 to 60 mins, depending on how busy is the server. Still a huge gain even if I recreated it every time. Thank you again.

spastranas · ‎08-14-2020

This is very helpful. Thank you!

spastranas · ‎08-14-2020

This is helpful. I am evaluating how to actually modify the dataset, but re-write is an option. Thank you for your reply!

spastranas · ‎08-11-2020

I have to delete row from a huge table. Currently I am doing it with a merge, but it is extremely slow. Is there a way to delete it using has tables? my code does not fail, but it does not delete the rows. Here is what I am traying to do, using as an example a dataset from sashelp. * My Production dataset will have about a billion rows; data allCarsDataset; set sashelp.cars; data acuraDataset; set sashelp.cars (where=(make='Acura')); run; *I need to delete all records from the AllCarsDataset, if they exist on the second dataset; data _null_; set WORK.allCarsDataset; length Make $8; if _n_=1 then do; declare hash B(dataset:"acuraDataset"); B.definekey("Make"); B.definedata("Make"); B.definedone(); end; rc2=B.find(); if rc2=0 then delete; run;

Online Status	Offline
Date Last Visited	‎05-12-2021 04:18 AM

Help creating a query to loop thorugh data

Re: Proc import returns all my data as percent

Re: Proc import returns all my data as percent

Proc import returns all my data as percent

Re: Program>Enhanced Editor Key is grayed out

Program>Enhanced Editor Key is grayed out

Re: Delete data from a huge dataset using hash

Re: Delete data from a huge dataset using hash

Re: Delete data from a huge dataset using hash

Delete data from a huge dataset using hash

Re: Proc import returns all my data as percent

Re: Program>Enhanced Editor Key is grayed out

Re: Delete data from a huge dataset using hash

Re: Delete data from a huge dataset using hash

Re: Delete data from a huge dataset using hash

Help creating a query to loop thorugh data

Re: Proc import returns all my data as percent

Re: Proc import returns all my data as percent

Proc import returns all my data as percent

Re: Program>Enhanced Editor Key is grayed out

Program>Enhanced Editor Key is grayed out

Re: Delete data from a huge dataset using hash

Re: Delete data from a huge dataset using hash

Re: Delete data from a huge dataset using hash

Delete data from a huge dataset using hash