About almmotamedi

almmotamedi · ‎02-09-2016

Here is a sample of my data. Thank you for help

almmotamedi · ‎02-09-2016

I see. Could you please advise how to "rename" or fix the variable name? (doing this manually is a very time consuming task). Thank you

almmotamedi · ‎02-09-2016

I have imported several csv files into SAS separately using import data wizard. Now, I would like to merge (combine) them together. But, it seems that the format of one of the variables is not consistant in all the files. Could you please how do I fix this?, or what is wrong with my below code? DATA SCOPES.ENTIRE_DATABASE_SCND_CONST; SET WORK.SCOPESCALCULATIONS_SECONDARYCON1 ( rename='COT00503.D_SRVY'n=COT00503_D_SRVY_str in=special ) WORK.SCOPESCALCULATIONS_SECONDARYCON2 ( rename='COT00503.D_SRVY'n=COT00503_D_SRVY_str in=special ) WORK.SCOPESCALCULATIONS_SECONDARYCO49 ( rename='COT00503.D_SRVY'n=COT00503_D_SRVY_str in=special ) WORK.SCOPESCALCULATIONS_SECONDARYCO54 ( rename='COT00503.D_SRVY'n=COT00503_D_SRVY_str in=special ) WORK.SCOPESCALCULATIONS_SECONDARYCO64; run;

almmotamedi · ‎02-09-2016

Sure, I think my best bet is using wildcard (I created a new thread for that). I appreciate if you take a look at that. The code works for some INPUT variables but not for all of them! I am so frustrated!!

almmotamedi · ‎02-09-2016

Here is my wildcard code: data details_FEB; infile "/v_share/Xiaomin/SCOPES/sas_dataset/Oct-08-2015/ScopesCalculations_SecondaryConstruction_*" linesize = 300 firstobs = 2; input C_ST $3.0 C_DSTRB_AREA $5.0 N_RSK $5.0 IsRevision9 $1.0 ScheduleNumberException $2.0 IsAsgrReportExists $2.0 ConstructionClass 1.0 COT00503.C_CSP_CONST_CLS 1.0 ERROR: DATA STEP Component Object failure. Aborted during the COMPILATION phase. ERROR 557-185: Variable COT00503 is not an object. COT00503.F_CSP_CONST_CLS 1.0 CombustibilityClass 1.0 COT00503.C_COMB_CLS 1.0 COT00503.F_COMB_CLS 1.0 COT00503.N_STOR 1.0 PartialSprinklerCreditFactor 1.0 LimitedSupplyCreditFactor 1.0 COT00503.C_SPK $1.0 SprinklerCreditType $1.0 COT00512.C_IPM $1.0 InternalProtectionMethod $1.0 TotalFloorArea 6.0 COT00504.R_TL_FLR_AREA 6.0 TotalRoofArea 6.0 COT00504.R_TL_RF_AREA 6.0 TotalSpecificFloorArea 6.0 COT00504.R_TL_SPEC_FLR 6.0 TotalFloorAndRoofArea 6.0 COT00520.C_SEC_CONST $1.0 COT00511.N_BGN_LVL 1.0 COT00511.N_THRU_LVL 1.0 COT00511.C_VO_PROT $1.0 COT00515.N_SCHD 15.0 FloorLevel 1.0 COT00516.N_LEN*COT00516.N_WDTH 6.0 COT00516.C_LVL_TYP $10.0 IsLowestFloor $10.0 COT00511.F_DIV_WL $10.0 COT00516.F_OTH $10.0 COT00516.C_AS_TYP $10.0 COT00520.N_SQFT $10.0 COT00520.C_RF_SRFC $10.0 COT00520.F_COMB_SB $10.0 COT00520.F_FOAM_PLSTC $10.0 COT00520.F_ACPT_TB $10.0 COT00520.R_PCT_STOR_AFCT $10.0 COT00520.R_PCT_OTH_FLR 3.0 COT00520.C_BLDG_COND $5.0 Percentage $5.0 COT00520.R_PCT_OTH_FLR $5.0 EffectiveArea $5.0 COT00520.R_TL_FLR_AREA $5.0 Charge $5.0 COT00520.R_CHRG $5.0 COT00520.F_CHRG $5.0 SecondaryConstructionCharge $5.0 COT00520.R_TL_SEC_CONST $5.0; run; Could you please help?

almmotamedi · ‎02-09-2016

Here is my wildcard code: data details_FEB; infile "/v_share/Xiaomin/SCOPES/sas_dataset/Oct-08-2015/ScopesCalculations_SecondaryConstruction_*" linesize = 300 firstobs = 2; input C_ST $3.0 C_DSTRB_AREA $5.0 N_RSK $5.0 IsRevision9 $1.0 ScheduleNumberException $2.0 IsAsgrReportExists $2.0 ConstructionClass 1.0 COT00503.C_CSP_CONST_CLS 1.0 ERROR: DATA STEP Component Object failure. Aborted during the COMPILATION phase. ERROR 557-185: Variable COT00503 is not an object. COT00503.F_CSP_CONST_CLS 1.0 CombustibilityClass 1.0 COT00503.C_COMB_CLS 1.0 COT00503.F_COMB_CLS 1.0 COT00503.N_STOR 1.0 PartialSprinklerCreditFactor 1.0 LimitedSupplyCreditFactor 1.0 COT00503.C_SPK $1.0 SprinklerCreditType $1.0 COT00512.C_IPM $1.0 InternalProtectionMethod $1.0 TotalFloorArea 6.0 COT00504.R_TL_FLR_AREA 6.0 TotalRoofArea 6.0 COT00504.R_TL_RF_AREA 6.0 TotalSpecificFloorArea 6.0 COT00504.R_TL_SPEC_FLR 6.0 TotalFloorAndRoofArea 6.0 COT00520.C_SEC_CONST $1.0 COT00511.N_BGN_LVL 1.0 COT00511.N_THRU_LVL 1.0 COT00511.C_VO_PROT $1.0 COT00515.N_SCHD 15.0 FloorLevel 1.0 COT00516.N_LEN*COT00516.N_WDTH 6.0 COT00516.C_LVL_TYP $10.0 IsLowestFloor $10.0 COT00511.F_DIV_WL $10.0 COT00516.F_OTH $10.0 COT00516.C_AS_TYP $10.0 COT00520.N_SQFT $10.0 COT00520.C_RF_SRFC $10.0 COT00520.F_COMB_SB $10.0 COT00520.F_FOAM_PLSTC $10.0 COT00520.F_ACPT_TB $10.0 COT00520.R_PCT_STOR_AFCT $10.0 COT00520.R_PCT_OTH_FLR 3.0 COT00520.C_BLDG_COND $5.0 Percentage $5.0 COT00520.R_PCT_OTH_FLR $5.0 EffectiveArea $5.0 COT00520.R_TL_FLR_AREA $5.0 Charge $5.0 COT00520.R_CHRG $5.0 COT00520.F_CHRG $5.0 SecondaryConstructionCharge $5.0 COT00520.R_TL_SEC_CONST $5.0; run; Could you please help?

almmotamedi · ‎02-09-2016

Yes, I can change the header rname to whatever I want, but the column will appear as an empty column! Also, I get "Variable is not an object." error when I run the code. Thank you for help

almmotamedi · ‎02-08-2016

Thank you so much. All of my variables are either numeric or character, EXCEPT one variable : its name is "COT00503.D_SRVY" and its a "date" Do you think that basically there is a problem with its name? (because of dot) And, how do I specify its FORMAT in INPUT statement? Thank you

almmotamedi · ‎02-08-2016

Great, thank you. One quick question about the example INPUT statement you mentioned; do I need to specify any value? or calling the variable (column header) is enough? for example, in this line, @45 E $6.0 , what is exactly the $6.0 ? My files all have the same layout and header, but they have obviously different values and row numbers Thank you

almmotamedi · ‎02-08-2016

I had completed my code by adding INPUT after that. Here is my code again: filename two ("/v_share/Xiaomin/SCOPES/sas_dataset/Oct-08-2015/ScopesCalculations_SecondaryConstruction_ 01_10092015_1158.csv" "/v_share/Xiaomin/SCOPES/sas_dataset/Oct-08-2015/ScopesCalculations_ScopesCalculations_SecondaryConstruction_ 02_10092015_1219.csv"); data test; infile two; INPUT C_ST C_DSTRB_AREA $ N_RSK $ COT00503.D_SRVY $ IsRevision9 ScheduleNumberException IsAsgrReportExists $ COT00503.D_SCHD_APLY $ ConstructionClass COT00503.C_CSP_CONST_CLS COT00503.F_CSP_CONST_CLS CombustibilityClass COT00503.C_COMB_CLS COT00503.F_COMB_CLS COT00503.N_STOR PartialSprinklerCreditFactor LimitedSupplyCreditFactor COT00503.C_SPK $ SprinklerCreditType $ COT00512.C_IPM $ InternalProtectionMethod $ TotalFloorArea COT00504.R_TL_FLR_AREA TotalRoofArea COT00504.R_TL_RF_AREA TotalSpecificFloorArea COT00504.R_TL_SPEC_FLR TotalFloorAndRoofArea COT00520.C_SEC_CONST $ COT00511.N_BGN_LVL COT00511.N_THRU_LVL COT00511.C_VO_PROT $ COT00515.N_SCHD FloorLevel COT00516.N_LEN*COT00516.N_WDTH COT00516.C_LVL_TYP $ IsLowestFloor $ COT00511.F_DIV_WL COT00516.F_OTH COT00516.C_AS_TYP $ COT00520.N_SQFT $ COT00520.C_RF_SRFC COT00520.F_COMB_SB,COT00520.F_FOAM_PLSTC,COT00520.F_ACPT_TB COT00520.R_PCT_STOR_AFCT COT00520.R_PCT_OTH_FLR COT00520.C_BLDG_COND | $ Percentage,COT00520.R_PCT_OTH_FLR EffectiveArea COT00520.R_TL_FLR_AREA Charge COT00520.R_CHRG COT00520.F_CHRG SecondaryConstructionCharge COT00520.R_TL_SEC_CONST; run; I am not sure what address I should refer to for "Infile" statement (as you mentioned). Thank you

almmotamedi · ‎02-06-2016

Reeza, my previous thread did not get an appropriate answer. Thats why I created a new question thread.

almmotamedi · ‎02-05-2016

I already posted the code in my previous posts. The files are all csv files in a same folder with a same struture. Thanks

almmotamedi · ‎02-05-2016

Yes I did. But I still get an error, and i think there is something wrong with my DATA statement. i appreciate if you help with it

almmotamedi · ‎02-05-2016

Could you please give me some advice on how to import tens of csv files into my SAS database at once?, it seems that there are different ways to do it, however, I am not sure which way is more straightforward as I am pretty new into SAS. I already tried DATA statement, using INPUT and Infile commands, but it gives me error. Thank you for help,

almmotamedi · ‎02-05-2016

No, that I got connected to the local machine, it seems that the "filename" statement is fine. But, there should be something wrong with the "data" statement. Could you please advise? filename two ("/v_share/Xiaomin/SCOPES/sas_dataset/Oct-08-2015/ScopesCalculations_SecondaryConstruction_ 01_10092015_1158.csv" "/v_share/Xiaomin/SCOPES/sas_dataset/Oct-08-2015/ScopesCalculations_ScopesCalculations_SecondaryConstruction_ 02_10092015_1219.csv"); data test; infile two; INPUT C_ST; run; ERROR: /v_share/Xiaomin/SCOPES/sas_dataset/Oct-08-2015/ScopesCalculations_ScopesCalculations_SecondaryConstruction_ 02_10092015_1219.csv. FATAL: Unrecoverable I/O error detected in the execution of the DATA step program. Aborted during the EXECUTION phase. Thank you

Online Status	Offline
Date Last Visited	‎04-26-2016 01:04 PM

Re: Comparing same variable from two datasets

Re: Comparing same variable from two datasets

Re: Comparing same variable from two datasets

Re: Comparing same variable from two datasets

Re: Comparing same variable from two datasets

Re: Comparing same variable from two datasets

Comparing same variable from two datasets

Re: How to combine (not merge) two data sets?

How to combine (not merge) two data sets?

Re: Expansion from rows to columns?

Re: Converting date to Character

Re: How to compare values in two columns regardless of the row orders?

Re: Match Merging By Two Variables

Re: Match Merging By Two Variables

How do I write a macro to...import multiple text files that have the s...

How does "bypass data cleansing process" work in the Import Data task?

Re: ERROR in Input

Re: ERROR in Input

Variable has been defined as both character and numeric

Re: Importing several csv files into SAS

ERROR in Input

Re: Importing several csv files into SAS

Re: Importing several csv files into SAS

Re: Importing several csv files into SAS

Re: Importing several csv files into SAS

Re: Importing several csv files into SAS

Re: Importing several csv files into SAS

Re: Importing several csv files into SAS

Re: Importing several csv files into SAS

Importing several csv files into SAS

Re: Physical file does not exist