About alepage

alepage · ‎02-15-2018

I am not very familliar with proc format.. and I would like to solve my problem. how can I use the value of rank into a dataset and assign the proper value of 100 to Temp1; proc format ; value PtPerfo 1=120 2=110 3=100 4=80 5=70 6=50 7=40 8=34 9=32 10=30 ; run; The code of Data Temp work fine. But not the one of Data Temp2. %let T=3; Data Temp; Temp1=%sysfunc(putn(&T,Ptperfo)); run; Data Temp2; rank=3; Temp1=%sysfunc(putn(rank,Ptperfo)); run;

alepage · ‎02-14-2018

The second dataset may look like that 17 15 20 21 16 17 The values of the first column (dataset2) goes in var3 (dataset1) and the values of the second column (dataset2) goes in var5 (dataset1) . Consider the possibility that the second line (dataset2) is selected first (to go at the first line in dataset1) then the first line (dataset2) go at the second line of dataset1 and finally the last line of dataset2 goes at the end of dataset1. I am looking for a solution but only with very small dataset (max observations = 10 and few variables)

alepage · ‎02-14-2018

I agree with you but imagine that you don't have any key to make the join but you know the position of the values you want to pick from dataset1 and you know the position where the values should go in dataset2. I will never do that for a large dataset but what can we do in the case we have few values to transfert.

alepage · ‎02-14-2018

Hello, I have an existing dataset with five variables (5 columns) Three of those columns are already filled up with data. If I have the data for the two empty columns in another dataset, how can we transfer the data from one dataset to the other without using a join or macro value in the case we don't have a key to do a by statement? Suppose that the values of var2 (numeric) and those of var5 (characters) are in another dataset by that there is not sustainable key to make the join. Please note that the incomplete dataset may have only few observations, let's say, not more than 10. How can we do that task? Regards, Alain Ex: var1 var2 var3 var4 var5 AN1 1 AP AN2 6 AD AN3 8 EP

alepage · ‎02-07-2018

I have found my mistake. Thanks!

alepage · ‎02-07-2018

I have try your code and it is not working I have try the following if txtype ne quote_credit then do; policy_credit='test' ; end; and it works. But for some reason I don't know, I am not able to assign the value of creditedby to policy_credit. creditedby = 'aaa1234'; Any idea why.

alepage · ‎02-07-2018

Hello, I have a dataset with few variables. 4 of those (string variables) are: createdby policy_credit quote_credit txtype. When txtype ne 'quote' I would like to take the value of creditedby and put it into policy_credit then set quote_credit to empty. Data Soumweb1A; set SoumWeb1; if txtype eq 'policy' then policy_credit = updatedby; run; This code is note working, Why?

alepage · ‎02-06-2018

Hello, I would like to know how to initialize selected variables to zero to replace missing value by zero in proc sql create table In the example below, I would like to have missing(web) and missing(internet) set to zero. How is it possible to do that in a pro sql procedure? Regards, proc sql ; create table internet as select A.id, A.class, A.date,A.performer,A.title,A.category, A.web, B.internet from dataset1 A full join dataset2 B on A.id=B.id quit;

alepage · ‎01-23-2018

Hello, When you do a proc template and procedure that you will run after the proc template will use this template. How is is possible to first list the user define template and to clear those. Regards, Alain

alepage · ‎01-16-2018

I agree with you. Alain

alepage · ‎01-16-2018

Hello, I have seen a lot of message on how to check if a dataset is empty but many of the proposed codes generate errors. Here's my little contribution to the community. I have test this code and it seems to works properly. Please note that my dataset named base is empty (no column, no observations) and &records gives zero. You can replace the dataset by sashelp.class to test with a non zero dataset. It works fine with both situation. you can use the macro variable &records with a conditionnal statement to do what you want. data _null_; /*data step to check for number of records in your dataset*/ %global records; %let records=0; set base end=last; if last then call symput("Records",put(_n_,8.)); /*_n_ is observation number in sas dataset*/ run; %put &records;

alepage · ‎01-16-2018

Thanks a lot for your help. Please note that my %MEND statement to end the definition of %loop in not missing (see the 3 last lines) %end; %mend loop ; %loop(&liste1.); moreover, I agree with you that I have error(s) generated by the execution of my macro function either %rapport or %calcul; Regards, Alain

alepage · ‎01-15-2018

I have tried this solution but still the same error?

alepage · ‎01-15-2018

Hello SAS Experts, I am receiving this error message (The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks.) while run the code bellow. How do we correct this problem? Here's my code: %let liste1=4514 4530 4532 4548 4557 4595 4598 4621 4631 4673; %macro loop(vlist); %let nobs1=%sysfunc(countw(&vlist));/*Number of sale agents*/ %do i=1 %to &nobs1; %let Temp=%sysfunc(compress(%scan(&vlist,&i))); %calcul(&Temp); %rapport(&Temp); %end; %loop(&liste1.); log file: 1 Le Système SAS 13:04 Monday, January 15, 2018 1 ;*' _ 49 1 ! ;*";*/;quit;run; 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. 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='VT_Outil Ma Contribution par agent 2018_ALP3' _______________________________ 49 3 ! ; 4 %LET _CLIENTPROCESSFLOWNAME='Flux de processus' _ 49 4 ! ; 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. 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE='S:\IAAH\IaahCycleSAS_DEV\Rapports\TRTRPDNC\Operationnel\VT_Outil Ma Contribution par agent 8 ! 2018_ALP3.sas' _ 49 8 ! ; 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. 9 %LET _SASPROGRAMFILEHOST='LT1300'; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 FILENAME EGSR TEMP; 15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 16 STYLE=HTMLBlue 17 STYLESHEET=(URL="file:///C:/Program%20Files/SAS94/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css") 18 NOGTITLE 19 NOGFOOTNOTE NOTE: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks. 20 GPATH=&sasworklocation 21 ENCODING=UTF8 22 options(rolap="on") 23 ; 24 25 GOPTIONS ACCESSIBLE; 26 %let liste1=4514 4530 4532 4548 4557 4595 4598 4621 4631 4673; 27 %macro loop(vlist); 28 %let nobs1=%sysfunc(countw(&vlist));/*Number of sale agents*/ 29 %do i=1 %to &nobs1; 30 %let Temp=%sysfunc(compress(%scan(&vlist,&i))); 31 %calcul(&Temp); 32 %rapport(&Temp); 33 %end; 34 %loop(&liste1.); 2 Le Système SAS 13:04 Monday, January 15, 2018 35 36 GOPTIONS NOACCESSIBLE; 37 %LET _CLIENTTASKLABEL=; 38 %LET _CLIENTPROCESSFLOWNAME=; 39 %LET _CLIENTPROJECTPATH=; 40 %LET _CLIENTPROJECTPATHHOST=; 41 %LET _CLIENTPROJECTNAME=; 42 %LET _SASPROGRAMFILE=; 43 %LET _SASPROGRAMFILEHOST=; 44 45 ;*';*";*/;quit;run; 46 ODS _ALL_ CLOSE; 47 48 49 QUIT; RUN; 50

alepage · ‎01-11-2018

Hello, I am not very confortable with proc format so excuse me if my question seem very basic. how do you select the good wkVarname? for example, suppose that weeknumber is 34 then I would select wkVarName=P31_35. The rest of your code to select dynamicaly the variable is working as long as you select the good wkvarname at first. Thanks for help Alain

Online Status	Offline
Date Last Visited	a week ago

Re: How to use a macro variable in a if else condition

Re: How to use a macro variable in a if else condition

Re: How to use a macro variable in a if else condition

How to use a macro variable in a if else condition

Re: How to use a proc datasets move statement but with a password

How to use a proc datasets move statement but with a password

Re: Not famillar with _IORC_

Re: Need two run the SAS code two time to get the marcro variable valu...

Need two run the SAS code two time to get the marcro variable value. ...

Re: What's the best and more efficient method to map / define one vari...

Re: How to use a macro variable in a if else condition

Re: How to use a proc datasets move statement but with a password

Re: How to use a proc datasets move statement but with a password

Re: How to use a proc datasets move statement but with a password

Re: Need two run the SAS code two time to get the marcro variable valu...

Re: how to get a bearer token using SAS

case when else end as varname is not working properly when the variab...

Re: Searching a specific value in many dataset then putting some info ...

Re: Searching a specific value in many dataset then putting some info ...

Re: How to rename a file using unix command mv

selecting the good value from a proc format

Re: Asking the experts / transfering data from one dataset to another?

Re: Asking the experts / transfering data from one dataset to another?

Asking the experts / transfering data from one dataset to another?

Re: how to assign a variable value to an other variable under conditio...

Re: how to assign a variable value to an other variable under conditio...

how to assign a variable value to an other variable under condition

sas proc sql create table / initialize value to zero

how to list user defined template and how to clear the active one

Re: Trying to execute two macro function while passing the ith value o...

how to check if a dataset is empty

Re: Trying to execute two macro function while passing the ith value o...

Re: Trying to execute two macro function while passing the ith value o...

Trying to execute two macro function while passing the ith value of a ...

Re: creating a datasubset based on the weeknumber of the year