About FP12

FP12 · ‎08-23-2017

I have another problem with this solution... The columns names are extracted from the first row and I don't want. I want something like: getnames = no

FP12 · ‎08-23-2017

Thanks Reeza, It works perfectly... when there are not spaces character. What if it's "BK H" instead of "BKH"? I tried and it is not working. Do you know a solution for this?

FP12 · ‎08-22-2017

Hi, I have an Excel file with several sheet. I need to import to a table the sheet BKH..." Sometimes the sheet can be named "BKH_0210", sometimes "BKH546", or whatever else beginning by "BKH", I am sure it's the only sheet name containing and beginning by BKH So I tried: proc import datafile = "&inputdir./&input_file." DBMS = xlsx OUT = &output_table.; getnames=no; sheet LIKE "BKH%"; run; But it's not working...I just tried but I already had the feeling it wouldn't work. Do you have an idea on how I can do it?

FP12 · ‎08-22-2017

Hi, I want to convert a character A to numberic B I use the input() function. But you can only use it if you know the length of A. A = input(B,8.2) But I don't know if it is 8.2 or whatever. Do you know how I can manage it?

FP12 · ‎08-17-2017

Hi Reeza, thanks for this. I tried it and the problem remains. But why did you write 8? I want 6! ^^

FP12 · ‎08-17-2017

Hi all, I create a table using a proc sql: PROC SQL; CREATE TABLE A (B char(6) label = "BA"); QUIT; For every rows, the column B is filled in with "PA". Finally the column B of my table A has a length of 2. I would like it to remain to 6 as I ask it to do...because in a next step I merge with another table which has more than 2 characters and otherwise it creates truncation problems. Do you know how I could do it? Thanks

FP12 · ‎08-10-2017

Well, thanks, it worked. But I am not sure it's a good practice, but whatever ^^

FP12 · ‎08-10-2017

Many thanks, It worked.

FP12 · ‎08-10-2017

%macro process_8 (ext_output, transf_output_gr, transf_output_se, transf_output_su, rest_output_gr, rest_output_se, rest_output_su); data _null_; if "&HUIT" = "YES" then call execute('%nrstr(%process_8( ext_output = EXT_8, transf_output_gr = TRANSF_8_GR, transf_output_se = TRANSF_8_SE, transf_output_su = TRANSF_8_SU, rest_output_gr = REST_8_GR, rest_output_se = REST_8_SE, rest_output_su = REST_8_SU)'); run; Hi all, I defined a macro process_8, and then I call it like shown. When I do this I have the warning in title. I know I can manage it by removing the left part of the equal, but for readibility question I prefer to keep it. How can I manage it? Thanks,

FP12 · ‎08-09-2017

Hi, I am creating a file extraction macro based on this data &output_table. (where=(filename like &filenames.)); In the definition of my macro I have the two variables: -output_table -filenames I call my macro in another part by defining output_table, and filenames like: filenames = "File_52%Q&period_quarter.%.xls%" where period_quarter is another macrovariable equal to 1 in my case When I run it I have this warning, despite it is running well and give me good results: WARNING: Apparent invocation of macro Q1 not resolved. Surely because it is using the % character as a macro calling. What I don't understand is that for the second % and third %, I don't have the warning. Do you know what happens here? Thanks

FP12 · ‎08-09-2017

Thanks Kurt, In this case I prefer to extract only the useful part from my file. Like this, no more non-matching issue and no more warning. Yes I know it's a bit lazy way of doing it, but why doing more? ^^

FP12 · ‎08-09-2017

Hi all, I theorically map a file to a SAS table but usually some data are not matching as it should. For example: NOTE: Invalid data for DT_ECH_LAST in line 287 151-158. It's not so much important as I just need a part of the data in the following, and the part I need matches correctly. But i still get a warning about it: WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. I want to avoid two things: 1/ I read on Internet that if the number of non-matching data is superior to 50, the warning becomes an error. Is it true? How can I avoid it? 2/ I don't want the program to display the warning of this type, because in my program, it's kind of normal and it's not a warning. Can I do this? Thanks

FP12 · ‎07-26-2017

Hi. I have a table A like this: Name Amount1 aaa 32 bbb 23 Another table B like this Name Amount2 ccc 41 ddd 14 I try to append them in a C table like this: Name Amount1 Amount2 aaa 32 . bbb 23 . ccc . 41 ddd . 14 I do this data C; set A; run; PROC APPEND BASE=C DATA=B force;QUIT; And I have this two warnings: WARNING: Variable Amount2 was not found on BASE file. The variable will not be added to the BASE file. WARNING: Variable Amount1 was not found on DATA file. Finally my table C doesn't have the Amount2 column. How can I manage it? Thanks for answer

FP12 · ‎07-25-2017

Hi, I have this macro, which I run in a loop: %macro union( input_table, output_table, loop); %if &loop. = 1 %then %do; data &output_table.; set &input_table.; run; %end; %else %do; PROC APPEND BASE= &output_table. DATA= &input_table. force; %end; PROC DELETE DATA= &input_table.; %mend union; It works well. But I am sure there is better practice to avoid using loop value. Is there a way for the Proc APPEND to detect if the output_table exists, and if not to create it naturally with the input table? Thanks

FP12 · ‎07-24-2017

Many thanks for this. Is it only because I declared the macrovariable before entering the PROC SQL? It is strange this two ways of writing...

Online Status	Offline
Date Last Visited	‎04-09-2018 06:54 AM

CASE format in Proc SQL

Num8 to YYMMDDN8

Loop stop issue

Loop issue

CSV proc import manual modification

Re: Microsoft Excel versions

Microsoft Excel versions

Re: Macrovariable in macrovariable

Re: Macrovariable in macrovariable

Macrovariable in macrovariable

Re: CASE format in Proc SQL

Re: Macrovariable in macrovariable

Re: Macrovariable in macrovariable

Re: Delete spaces in unknown variables

Re: proc import excel sheet

PROC SQL UNION - unique vs with duplicates

Re: proc import excel sheet

Re: proc import excel sheet

proc import excel sheet

input without knowing length

Re: Format variable

Format variable

Re: WARNING: The quoted string currently being processed has become mo...

Re: % inside string

WARNING: The quoted string currently being processed has become more t...

% inside string

Re: File mapping to table

File mapping to table

PROC APPEND with new columns

PROC APPEND - Loop

Re: proc sql and trim