cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Tiri6
‎05-19-2021
  • 10 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to add rows in SAS

by Fluorite | Level 6 in SAS Programming
‎05-19-2021 08:29 AM
‎05-19-2021 08:29 AM
Yes i know but at first this thread was marked as spam and it wasn't published, i don't know why. ... View more

Re: How to add rows in SAS

by Fluorite | Level 6 in SAS Programming
‎05-19-2021 08:01 AM
‎05-19-2021 08:01 AM
I don't have a maximum number, months could ideally go from 1 to 999 ... View more

How to add rows

by Fluorite | Level 6 in SAS Programming
‎05-19-2021 04:55 AM
‎05-19-2021 04:55 AM
Hi,   i need to modify my input dataset creating new rows for each customer.   My input dataset is like this:   customer - month - status 111-3-active 222-4-abandoned 333-5-abandoned   And i need to create a new dataset like this one:   customer - month - status 111 - 1 - active 111- 2 - active 111- 3- active 222- 1 - active 222 - 2 - active 222 - 3 - active 222 - 4 - abandoned 333 - 1 - active 333 - 2 - active 333 - 3 - active 333 - 4 - active 333 - 5 - abandoned   How can i do? Thank you in advance.       ... View more

How to add rows in SAS

by Fluorite | Level 6 in SAS Programming
‎05-19-2021 03:46 AM
‎05-19-2021 03:46 AM
Hi,   i need to modify my input dataset in order to create a kind of log of customer's actions.   My starting dataset is:   customer - churn month - status 111         -        3             -  abandoned 222        -        5             -  active 333        -        4             -  abandoned   I need to create a dataset like this:   customer - churn month - status       111          -           1         - active 111          -           2         - active 111          -           3         - abandoned 222        -            1         - active 222        -            2         - active 222        -            3         - active 222        -            4         - active 222        -            5         - active 333        -            1         - active 333        -            2         - active 333        -            3         - active 333        -            4         - abandoned   Could you please help me?  Thank you in advance ... View more

Re: Proc export with labels removing quotes

by Fluorite | Level 6 in SAS Programming
‎04-02-2020 06:12 AM
‎04-02-2020 06:12 AM
thank you very much. It was exactly what i needed. Have a nice day. ... View more

Proc export with labels removing quotes

by Fluorite | Level 6 in SAS Programming
‎04-02-2020 05:23 AM
‎04-02-2020 05:23 AM
Hi,   i have a problem with proc export, labels and quotes.   I need to export a file with a ":" inside the header field.   Now i'm using the classic proc export:   PROC EXPORT DATA= example OUTFILE= "path\example.csv" DBMS=DLM LABEL REPLACE; DELIMITER='2C'x; PUTNAMES=YES; RUN;   And this is what i have:   "example:1" , "example:2"    I just need: example:1 , example:2 without quotes but with the " : " inside the name of the field.   How can i do in order to export properly?   Thank you very much. Marco ... View more

how to put macro variable in an automatic email sent through sas

by Fluorite | Level 6 in SAS Programming
‎06-27-2019 04:45 AM
‎06-27-2019 04:45 AM
Hi all,   i need to put a macro variable (number of obs in a dataset) into the code that send an automatic email with sas.   I count the number of obs with this sql:   proc sql noprint; select count(*) into :count from lista ; quit; %put Count=&count.;   and then i need to put &count into the automatic email that i want to send, i tried in this way:   filename mymail email from=("XXX") to=("XXX") subject="Daily report" ; data _null_; file mymail; put 'Hi,'; put 'here the daily numbers of record'; put '&count'.; put 'Ciao'; run;     Apparently it doesn't working. Could you please help me? Many thanks,   Marco ... View more

Re: Mod function with big number

by Fluorite | Level 6 in New SAS User
‎03-27-2019 01:10 PM
‎03-27-2019 01:10 PM
Ok thanks. Are there other functions that let me to do this calculate?   ... View more

Mod function with big number

by Fluorite | Level 6 in New SAS User
‎03-27-2019 12:20 PM
‎03-27-2019 12:20 PM
Hi everybody,   i need help with the MOD function with a big number.     data asd; format check 30.; check = 310300000604156791754311182900; Y =mod(check,97); run;   i can't do this data step because of this error:   NOTE: Invalid argument to function MOD(3.103058E29,97) at line 2667 column 4. check=310300000604156791754311182900Y=. _ERROR_=1 _N_=1 NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values. Each place is given by: (Number of times) at (Line):(Column). 1 at 2667:4 NOTE: The data set WORK.F has 1 observations and 2 variables. NOTE: DATA statement used (Total process time):   Could you please help me? Many thanks.     ... View more

How to do a proc export only on Tuesday

by Fluorite | Level 6 in SAS Programming
‎03-06-2018 12:15 PM
‎03-06-2018 12:15 PM
Hi everybody,   my need is to execute a proc export all the days in the programme, but i want to obtain the output file only if the day of the week is tuesday. Could you please help me?   I wrote a datastep like this but it doesn't work. Why?   data _null_; if WEEKDAY(today())=3 then do; PROC EXPORT DATA= RLWORK.prova OUTFILE= "DIRECTORY" DBMS=DLM REPLACE LABEL; DELIMITER='3B'x;   PUTNAMES=YES; RUN; run;   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-19-2021 11:51 AM
Group Hubs for Tiri6
View All
Likes given to
Quick links